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.