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.