2. PHPRunner General questions
  3. Problem with Lookup wizard in fields, phpr 10.91
This topic is locked

Problem with Lookup wizard in fields, phpr 10.91

 		5/3/2023 12:35:30 PM
PHPRunner General questions
K
 kohle author

Hi,
I dont know if this is a bug. When I choose a SQL view in the field lookup wizard, there is no WHERE oportunity .
If its not a bug, my question is why ?
img alt
If I choose a normal table there is the WHERE field :
img alt

Sergey Kornilov admin 5/3/2023

Yes, this is how it should work. Your SQL View may be a stored procedure call which means you cannot add a WHERE clause there. WHERE clause is only meant to work with tables.

K
 		kohle 5/3/2023

Hi,
when I think about SQL, than a stored procedure is the only SQL what doesnt work with the WHERE clausel. I am curios, what else dont accept a WHERE in a sql view?
SQL without WHERE, I think this is only in phprunner. Never see this before.
Why you dont let the delevoper decide to use or not.

The WHERE Clause would be really helpful and shorten the time of developing.
rg
J.