2. PHPRunner General questions
  3. Dropdown multiselection
This topic is locked

Dropdown multiselection

 		6/12/2017 11:20:00 PM
PHPRunner General questions
F
 firecloud author

Is it possible to make dropdown multiple selection filter to use or condition , when i turn the debug the sql query

(upper(MswId)=upper('select1,select2'))



is there any option to make to

MswId in ('select1','select2')

or

MswId ='select1' or MswId ='select2')
dermemo 6/13/2017

If I understand you correctly you want to have an OR condition on a dropdown field within PHPRunner.
To do so, select Lookup Wizard as the type of field and then edit the Query (Button where it says "Edit query")
Change the query to something like:

SELECT * FROM table WHERE UPPER(MswId) = 'select1' OR UPPER(MswId) = 'select2'


Hope that it is what you meant.
Kindly, Ozan
F
 		firecloud author 6/13/2017



If I understand you correctly you want to have an OR condition on a dropdown field within PHPRunner.
To do so, select Lookup Wizard as the type of field and then edit the Query (Button where it says "Edit query")
Change the query to something like:

SELECT * FROM table WHERE UPPER(MswId) = 'select1' OR UPPER(MswId) = 'select2'


Hope that it is what you meant.
Kindly, Ozan



Thanks for respond, maybe picture give more better description.


[/url]
F
 		firecloud author 6/15/2017



Thanks for respond, maybe picture give more better description.

[/url]







I think this one should be basic feature. still not found any solution
jadachDevClub member 6/15/2017

If I understand, you need to use contains in the search options.
M
 		Maven Consulting 6/16/2017

Hi

Check this plug-in.
https://xlinesoft.com/marketplace/products_view.php?editid1=26



I think this one should be basic feature. still not found any solution