filter data user / admin

Hi!

I’m developing an application where I have an admin user and a regular user. I want admin to be able to check all the data and user to view only his own records.
If I use a WHERE user = [usr_login] it works - but I still need admin to check all the records of all users. How I can accomplish this?

Thanks,
Emma

Re: filter data user / admin

I finally got this using the group/application security module!

I have a question: How can I hide menu items depending on the group user?

Re: filter data user / admin

Hi. Glad you figured it out - congrats :slight_smile:

To make the menu items go away when you do not have the security to use the apps they link to, just go to the settings of the menu app itself, look for something that hides them… can’t remember the exact heading of the setting - set it to yes I believe.

I use that all the time. It does indeed the menu items, even those that are items that don’t link directly, but that have sub items that do link to apps you can’t access. It is very nice system. You can have each type of group see a completely different menu structure. Just be sure to leave them a logout menu item :slight_smile:

I would look up the exact setting but my system is running the v6.0.005 update right now :slight_smile:
Peace,
Jamie

Re: filter data user / admin

thanks!!!

works perfectly!
:slight_smile: