2. PHPRunner General questions
  3. Multiple Owner ID Question
This topic is locked

Multiple Owner ID Question

 		10/11/2010 10:59:06 AM
PHPRunner General questions
T
 text author

Hi Anne/Sergey
I am trying to filter OwnerID on either of two fields (email and mobile number) I saw a thread where this is possible using a before SQL query but am struggling with it. Would you have any sample code that I could try.
Thanks very much
Richard
Sergey Kornilov admin 10/11/2010

Here is the article that explains how you can build dynamic sql queries:

http://xlinesoft.com/phprunner/docs/modify_sql_query_on_the_fly.htm
In your specific case you can use something like this:



$strWhereClause = whereAdd($strWhereClause, "OwnerID='7035953819' or OwnerID='test@test.com'");


Now you need to amend this code using real email and mobile number. I guess you store them in some session variables and then use in this event.
T
 		text author 10/13/2010

Thanks Sergey, just need to work the session bit out now!



Here is the article that explains how you can build dynamic sql queries:

http://xlinesoft.com/phprunner/docs/modify_sql_query_on_the_fly.htm
In your specific case you can use something like this:



$strWhereClause = whereAdd($strWhereClause, "OwnerID='7035953819' or OwnerID='test@test.com'");


Now you need to amend this code using real email and mobile number. I guess you store them in some session variables and then use in this event.