Customize Filter

[rha2000]

Hello

In the filter of the form I have a field that I want to compare it to other field.

For example,
I have three fields: field1, field2 and field3

In the filter I show the field1 (let's call field1_show)

Then on the sql query would
field1_show = field1 OR field2 = field1_show field1_show OR = field3

I tried to do it with the prefilter option from the list but I could not.

As I customize the filters?

Regards

 

[rha2000]

Simply put, I can make a search field that searches multiple fields?

 

[troester]

You can create a search form and then redirect to the list via URL filtering (I think using "Use as search data" would do ANDs).

But if it's just ORs you may enable "Search all" in list settings and add your 3 elements.