multiple ids search on one field

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.
Post Reply
mishanian
User
Posts: 120

multiple ids search on one field

Post by mishanian »

Hi,
I have a table like:

id, name, status 

and data like

1, a, 1
2, b, 1
3, c, 2
4, d, 3

and status field is a drop-down search when I generate the table by PHPMaker on the search like

requestinfoslist?cmd=search&x_status_id=1

it is showing all of the records with status=1

is it possible to show all the records with status 1 or 2? how should be the URL
something like?

requestinfoslist?cmd=search&x_status_id=1,2

Actually, I would like to give 2 buttons to the user instead of all of the statuses

On (with status =1,2 for example) and Off (status=3,4 for example)
what is the best approach to do so?


mobhar
User
Posts: 11660

Post by mobhar »

If you are using v2023, then you may use Query Builder in order to perform search with criteria that cannot be handling by Quick or Advanced Search.


Post Reply