Scalability of filtering repeating groups using states

Hard to give exact advice without seeing how your database is set up.

Looks to me though like you may also need to show what those filters are on the searches.

You also need to consider that when you have these 3 conditionals the Checkbox Held is checked is going to be yes when Checkbox Comments is checked and Checkbox Held is checked. Also, Checkbox Comments is checked is yes when Checkbox Comments is checked and Checkbox Held is checked, so you need to add an and operator to the first two conditionals so that it is Checkbox Held is checked and Checkbox Comments is not checked and vice versa.

This post may help you

But definitely put up some screen shots of the filters and your database structure which are both related to how the search results will be returned and how to set it up properly overall