2. PHPRunner General questions
  3. [SOLVED]  general filtering
This topic is locked
[SOLVED]

 general filtering

 		1/2/2010 5:30:01 PM
PHPRunner General questions
T
 titanic author

say we have a database schema and every table has a foreign key refers to USER_ID. In other words, there are several users and each of them has pictures, files etc
can we filter tables such that whenever a user logs in only his/her pictures, files are listed.
I can guess it is simply a "where" thing but not sure how to do it..?
thanx in advance...
similar question...
For same condition say we want to add new record. (say upload a new photo) Is there anyway to assign "session_ID" to "owner_ID" attribute of table, automatically?
so every upload will automatically will belong to logged in user...
thanx in advance ...
A
 		alang 1/3/2010

Sounds like you might be best to look at using advanced security where users can only see their own data for this table.
T
 		titanic author 1/4/2010



Sounds like you might be best to look at using advanced security where users can only see their own data for this table.


not really... I would also like to see other pages if neccessary...
A
 		Aleix 1/4/2010



not really... I would also like to see other pages if neccessary...


Hello Titanic;
In advanced security I think that you can select in which table or vista to apply the security level.
J
 		Jane 1/7/2010

Hi,
use Users can see and edit their own data only security method for these tables:

http://www.xlinesoft.com/phprunner/docs/advanced_security_settings.htm
Then create custom view on the Datasource tablestab where user can see all records.