Skip to Content
Former Member
Mar 04, 2009 at 05:25 PM

How to get results for authorized field levels without selecting variables?



How can I run a query WITHOUT selecting variables and get only authorized field level results?

If a user selects the variables, they get accurate results.

If they run the query without selecting variables. They get no authorization and I am told to add aggregation to their roles.

If I add aggregation ability to the two field level objects, (0emplgroup and 0emplsgroup) for HR data and run the query, I get ALL results. Field level security is not checked.

The Employee Groups and Employee Sub-Groups are many. We do not want users having to select variables in these fields. We want them to just run the query and get results based on their field level values in their authorizations. Any suggestions?

Thanks in advance for any help.