This topic is locked

Modify lookup where clause

10/28/2018 5:17:53 PM
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.

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

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.