Help/Suggestions with data filtering with multiple columns

Guys, need some help or guidance. I have the example of filtering data with text input working https://wappler.io/docs/#Filtering-Database-Query-with-a-Text-Input and have used this several times, but now I need to filter on two columns of data. So basically a searchfield1 OR searchfield2. So instead of just filtering off ProductName, I can filter off ProductCode also. I have added another text input field and variable, then on my query I added another row and the condition is “OR”. That didn’t work, and I then I changed it to “AND”. That doesn’t work either. Has anybody done this, and if so, how?

Community Page
Last updated: