This topic is locked

Two criterias for filtering data

2/6/2011 3:21:27 PM
PHPRunner General questions
K
kausi author

I would like based on user filter the records. Currently the PHPRunner has an exelent facility to do it with one criteria. E.g. user table has company field and data table has company field then when they match only these record are shown.

I would like to set up two criterias. E.g. user table has company1 and company2 field. Data table has as well company1 and company2 field. Then when company1 and company2 fields match in data and user table the these records are shown.

But if user is set in premissions to see all records he will see only record which match with company1.

How would be best way to accomplish this?

Sergey Kornilov admin 2/8/2011

I guess you can use Dynamic SQL Query technique explained here:

http://xlinesoft.com/phprunner/docs/update_multiple_records.htm