2. PHPRunner General questions
  3. filter a table with a button - need help
This topic is locked

filter a table with a button - need help

 		4/2/2023 9:49:59 AM
PHPRunner General questions
F
 francesco author

i want to apply a filter on multiple values of field macchina:
var link = 'commessaview_list.php?f=(macchina~equals~4~or~macchina~equals~5~or~macchina~equals~6~or~macchina~equals~8~or~macchina~equals~18)';
but it only works on the first number (macchina~equals~4) and ignore the other ones.
where is the issue?

Sergey Kornilov admin 4/2/2023

Make sure that you ran this filter manually first. Once you got it working, copy and paste the URL into your code.
francesco 4/2/2023

i ran manually but it works only on the first condition
W
 		wedi 4/3/2023

Hello franceso,
could you send us the whole SQL statement?
Maybe there is a join that distorts the where clause.
francesco 4/4/2023

It wasn't an sql problem.
As suggested from Admin, set "OR" search in macchina field and use filters provided from phprunner for multiple search. Then just copy the syntax displayed in browser and paste inside button code and it works flawlessy.