I made a query with mandatory criteria the user have to select, but the others non mandatory criteria conditions can lead to multiple user criteria (e.g., check-boxes , drop-downs list and regular fields). So I can’t code the conditions or filters in advance, because I have no idea, which criteria the users will select.
Currently, I have moved the initial query result to a table with:
$w(“#table1”).rows = tableRows;
Actually, I have in mind do do a loop in the tablerows and delete the rows that don’t match the user’s criteria.
I also have no idea how I can search the non-matching rows, but I believe It’s manageable. Your help for that one also could help me.