How can I show all 'TrainingSession' records, when I'm performing reduction based on a related field.
I have a document that show user training for my organization. Section Access allows supervisors to only view training data for their subordinates, while Training adminstrators can see data for all users.
I have implemented section access reduction on the EMPLOYEE field...
star is *;
LOAD * Inline [
The administrator is only able to see training session data when the session has enrolled employee.
Is there a way to grant access to all data without using the Star.
If I remove the Star ('USER,ADMIN,') it works fine in the developer, but prompt me for a UID and PWD when deployed on the sever.