2. PHPRunner General questions
  3. [SOLVED]  Filter Lookup Wizard
This topic is locked
[SOLVED]

 Filter Lookup Wizard

 		11/5/2019 11:26:44 AM
PHPRunner General questions
M
 Melanie authorDevClub member

I am trying to filter a lookup wizard on an Add page. In the Where portion of the lookup wizard I am putting this:
fleet_link=':user.fleet_id' (this fleet_id field is in the login table I am using).
But it has no effect.
Any help why this doesn't work?
N
 		Nir Frumer 11/5/2019

hi

please check this on the manual
https://xlinesoft.com/phprunner/docs/secapi_get_user_data.htm
hope it helps
M
 		Melanie authorDevClub member 11/5/2019



hi

please check this on the manual
https://xlinesoft.com/phprunner/docs/secapi_get_user_data.htm
hope it helps


Thanks but yeah that doesn't help. I love PHPRunner because I am not a php, or java programmer and can do most things I need - but this is when it is bad because I am very lost trying to do custom things. I found this in the manual and it looks very straightforward - but doesn't do what I was hoping it would do.
This feature can be used anywhere where you use SQL Queries. With SQL variables you can write cleaner code and easily implement custom dropdown boxes or advanced security. SQL variables are case-insensitive.
Where to use it:
·In regular SQL queries that you enter on "SQL Query" screen
·In WHERE Tabs on "SQL Query" screen
·[size="4"]In Lookup Wizard WHERE clause[/size]. It can be used in dropdowns that are dependent on any type of field, dependent on master dropdown, dependent with more complex rule than equality (i.e. age is more than selected).
WHERE CustomerID= ':user.CustomerID'
WHERE CustomerID= ':session.UserID'
lefty 11/5/2019



Thanks but yeah that doesn't help. I love PHPRunner because I am not a php, or java programmer and can do most things I need - but this is when it is bad because I am very lost trying to do custom things. I found this in the manual and it looks very straightforward - but doesn't do what I was hoping it would do.
This feature can be used anywhere where you use SQL Queries. With SQL variables you can write cleaner code and easily implement custom dropdown boxes or advanced security. SQL variables are case-insensitive.
Where to use it:
·In regular SQL queries that you enter on "SQL Query" screen
·In WHERE Tabs on "SQL Query" screen
·[size="4"]In Lookup Wizard WHERE clause[/size]. It can be used in dropdowns that are dependent on any type of field, dependent on master dropdown, dependent with more complex rule than equality (i.e. age is more than selected).
WHERE CustomerID= ':user.CustomerID'
WHERE CustomerID= ':session.UserID'


After Successful login event add
$_SESSION["fleet_id"]=$data["fleet_id"];
Then use your variables as you stated. Did not think we had to do this anymore , but maybe we do for sessions.

Sergey Kornilov admin 11/5/2019

As a first step - make sure you use the latest version and build of PHPRunner, v 10.3, build 34039.
M
 		Melanie authorDevClub member 11/5/2019



As a first step - make sure you use the latest version and build of PHPRunner, v 10.3, build 34039.


Confirmed this is the build I am using - does not filter my lookup.
M
 		Melanie authorDevClub member 11/5/2019



After Successful login event add
$_SESSION["fleet_id"]=$data["fleet_id"];
Then use your variables as you stated. Did not think we had to do this anymore , but maybe we do for sessions.


Yes - did this too.
Sergey Kornilov admin 11/6/2019

Did you test this lookup wizard in PHPRunner itself or in the generated application? It is very strange that it simply displays the same list of items according to what I see it should either display no items or produce an error (assuming that something doesn't work).
M
 		Melanie authorDevClub member 11/6/2019



Did you test this lookup wizard in PHPRunner itself or in the generated application? It is very strange that it simply displays the same list of items according to what I see it should either display no items or produce an error (assuming that something doesn't work).


I just created a desktop app for it and ran it - no change. No error, but the list is not filtered.
Sergey Kornilov admin 11/6/2019

It will really help if you answered my question. Desktop application is irrelevant here.
How do you test this lookup wizard, in PHPRunner software itself (on the same screen where you setup lookup wizard) or in the generated application (in the web browser)?
If your answer is the latter - then you need to perform the next step of troubleshooting which will be printing all SQL queries on the page. You need to see the exact SQL query that this lookup wizard produces. Here is the article that explains how to do so: https://xlinesoft.com/phprunner/docs/debugging_tips.htm
M
 		Melanie authorDevClub member 11/7/2019



It will really help if you answered my question. Desktop application is irrelevant here.
How do you test this lookup wizard, in PHPRunner software itself (on the same screen where you setup lookup wizard) or in the generated application (in the web browser)?
If your answer is the latter - then you need to perform the next step of troubleshooting which will be printing all SQL queries on the page. You need to see the exact SQL query that this lookup wizard produces. Here is the article that explains how to do so: https://xlinesoft.com/phprunner/docs/debugging_tips.htm


Sorry I did not get back sooner to answer. I started over on this application (instead of moving it from older version to 10.3) and everything is now working.