Power Search function

Need help Database
1

Hi there,

Does any body have any ideas on how to implement a power search function?

I only need to search one database, however I have 4 criteria for this search, of which all four might not be active at the same time (See Below Image). Results of this search will appear in a repeating group.

Screenshot 2023-02-05 193045
Screenshot 2023-02-05 193045765×730 17.8 KB

Any number of the search criteria can be used at once, so there could be just 1, 2, 3 or 4. Or any other makeup of the four inputs (this could be 24 permutations).

So I’m a bit stumped as to what to do. I’ve looked at Fuzzy search plugins but I’m not sure if this is what I need. Any help with power search tips would be greatly appreciated.

Thanks in advance.

2

you can set up the search with all 4 conditions from the inputs and check ignore empty constraints.

3 Likes
3

Thank you so much!

This works a treat. I wish I’d have known this sooner, this enables so many possibilities elsewhere in my application.

Your help is much appreciated.

4

Happy to help :slight_smile:

Cheers
Mariano