2. PHPRunner General questions
  3. Lookup Wizard
This topic is locked

Lookup Wizard

 		12/28/2012 6:36:11 AM
PHPRunner General questions
L
 lewisekrantz author

Users Table
jones

smith

atlas
Projects Table

999 main

833 first

505 third
Project_Users Table (authorized projects by user)
jones 999 main

smith 833 first,505 third
Objective
On each page of my system the user Selects Project from a drop down box

I want each users drop down box to only show the projects that they are authorized to see
I would be happy to pay someone to make this mod or tell me how. Either is fine

I can be reached at lewisekrantz@esolve.com
M
 		mrdave 12/28/2012



Users Table
jones

smith

atlas
Projects Table

999 main

833 first

505 third
Project_Users Table (authorized projects by user)
jones 999 main

smith 833 first,505 third
Objective
On each page of my system the user Selects Project from a drop down box

I want each users drop down box to only show the projects that they are authorized to see
I would be happy to pay someone to make this mod or tell me how. Either is fine

I can be reached at lewisekrantz@esolve.com


Well this is an ugly solution, but you can try:

modify the sql on projects table

select address,project_users.lastname as users from projects

inner join projects_users on instr(project_uses.addresslist,projects.address)

then you could simply use advanced permissions on the table limiting access by users.
I don't think you get any value from indexing here though.
Sergey Kornilov admin 12/28/2012

I second the solution Dave suggested.
Created a Custom View in PHPRunner on the top of that SQL query, apply advanced security settings to this custom view and use this view as a datsource for your Lookup wizard field.