Filtering a database

Hi Harte!

What you’re trying to achieve is multi-field filter.
Take a look at this thread, it should give you the push towards the road you’re seeking!

Anyway, in order to create a multi-filter search , more than one field is required for comparison inside the called function/event.
As I see from the code you posted, in every event that is being called there is only one field to refer to thus revoking other referencing from other fields in other events.
All you’re actually missing is combining those conditions .
Try to read into the WixDataFilter API and look at the examples there.

Also, I’ve noticed that you have asked about this issue before in other threads.
As much as we’d like you to conquer your goals and help you with pointing you to the right direction, in this forum we do not rewrite code for the users but provide them with directions and tools to overcome the issues they’re facing.

If you feel that you need help in rewriting your code you can always turn to the WixArena where you can hire a WixCode expert (and many other kinds of experts) to help you with your site.

Hope it helps!
Best of luck

Doron. :slight_smile: