2. PHPRunner General questions
  3. Modify lookup where clause
This topic is locked

Modify lookup where clause

 		10/28/2018 17:17:53
PHPRunner General questions
H
 headingwest author

Hi,
Is there any way to totally change a Lookup where clause.
EG:
From:

" WHERE CITY LIKE %S"
To:

" WHERE COUNTRY IS NULL "
I'd like to be able to do it the same way you can modify a table/view where clause.
Thanks for any help.
Sergey Kornilov admin 10/29/2018

You can modify WHERE clause of Lookup Wizard under 'Edit as' settings on this field.
H
 		headingwest author 10/29/2018



You can modify WHERE clause of Lookup Wizard under 'Edit as' settings on this field.


Hi Sergey, I need to replace the WHERE clause in code depending on certain criteria.
S
 		steveh 10/30/2018

Use a php functionb
"". Myfunction()
Define it in appinit.
Steve
Sergey Kornilov admin 10/30/2018

You can manipulate lookup's table WHERE clause the same way you do with a regular table:

https://xlinesoft.com/phprunner/docs/modify_sql_query_on_the_fly.htm
gehrenfeld 10/31/2018

I use IF statements.
IF expression THEN

statements;

END IF;
Use can use IF and ELSE in SQL statements.