CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 filter rows but all rows for admin

Print topic Send  topic

Author Message
rbaldwin
Posted: 11/21/2003, 11:32 AM

In my grid i wish to show all records if the user logged in is Admin but only show the logged in user's rows if the logged in user is a regular user.

showing the logged in users i accomplished via the querry builder.

But now i'm thinking that i'll have to remove the where from the querry builder and do something in a before show event.

Any suggestions?
Nicole
Posted: 11/22/2003, 5:26 AM

Hello,
I suppose that you can modify the WHERE clause in the Before Execute Select event (refer to CCS Help for sample code) if the logged in user is administrator remove the relevant WHERE condition.

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.