Hello,
I would like to filter a list of companies using 5 multi-select criteria. I’m using Xano as my backend.
My problem is that the multi-select options are stored in a different database from the companies. The criteria (options) are linked to the company database via a dedicated API (Addon) in Xano.
I don’t know how to filter with criteria and companies in 2 different databases.
I hope my explanations are clear enough :-).
Could you please help me?
You need to fetch the options from your db1 and use them - pass them as a filter properties to the other one.
What exactly is the issue? Could you specify the issue?
Hello @Broberto ,
Sorry for my late reply.
As you can see in the attachments, I have 5 multi-select as search criteria. I’m looking for the right filter to sort my companies according to the user’s search choices.
When I use “Contains”, the companies are filtered, but not in the way I want. In fact, the companies displayed must match all the criteria selected by the user. When I test with “Has any of”, my filtering no longer works.
Thanks in advance