I suspect there's a simple query to be able to do this but it's not something I've tried before. I'm trying to create a user-friendly way for a client to, from within the category edit screen, to indicate that a given category should or should not display within a drop down on the site. The general idea is that while they may have 20 categories, only 3-5 of them would be seen as "primary" and therefore should display in the dropdown menu at the top of the site.
So for user friendliness, I though adding a custom category field with a simple select list of no vs. yes would be the way to go. But the channel categories loop doesn't have a search parameter, so I suspect that I will need a query to loop through the categories in the given group and pull out only those with the custom category field of "display" with a value of "yes".
Can a query expert out there help me out?