My custom doctype “Contacts” contains a child table “Category” and assigns a contact to several categories. The child table “Category” is of type Select. In Contacts Listview, for example, I want to filter the contacts that are in category A and in category C. The result is always empty, although there are contacts that contain both categories. What is the problem and how to fix it?
You could try a “like” filter instead of multiple “equals” filter as the way it is designed, every filters works like an “AND” condition in SQL.
If I use “like” instead of “equals” it is not possible to choose the category from a drop down selection. The user then has to memorize all categories. This also does not solve the problem that I want to query several categories at the same time.
I am having this same issue. Can someone resolve? @NCP ?
Specifically, my Constituent Doctype has an Event RSVP child table. My users need to be able to filter the list of Constituents to those with a “Yes” RSVP to one Event, and an unset RSVP to another. What is the best solution for this?