How best to search with categories on queries (aka using a category prompted criteria on a query)

Version 1

    How to search for items in a query using a prompted criteria on a category? And to be able to choose from a dropdown and search sub-categories as well?


    To ensure the prompted criteria displays as a dropdown and not just a texbox modify the query and when dragging it to the criteria panel make sure you drag the relationship itself and not any attribute (Title, Full Name etc) below it.


    If you specify the condition as "Is Equal To" (as is by default) the query will only search for items that match the exact category selected.  If you change this to "Is Equal To Category" this will search for items with the selected category plus all children of that category.


    ITBM all versions