2. PHPRunner General questions
  3. UNION ALL Alternative
This topic is locked

UNION ALL Alternative

 		3/11/2022 1:38:12 AM
PHPRunner General questions
J
 JoeB7774 author

Hello,

I have a drop down that is based on a table. Let's say that The table values are 1,2,3,4,5. If I need to add a 0 to that list (to make the list 0,1,2,3,4,5) but I CAN'T add it to the table (nor can I do a query in the database), is there a way to accomplish this within PHPRunner? Normally I would do a UNION ALL but I understand that's not an option in PHPRunner.

Thanks,

Joe
Sergey Kornilov admin 3/11/2022

You can create a view in your database based on UNION ALL SQL query and then use this view as a data source in PHPRunner.

J
 		JoeB7774 author 3/12/2022

Would it also be possible to simply add the extra item using JavaScriptOnLoad? Similar to a user removing 'Please Select' from a drop down?