BAQ to shows employees for the current logged in User

[Ahorodenski (Alex Horodenski)]

I need to create a BAQ that will show all the employees for a specific SuperID. And the SuperID needs to default to the Employee ID of the current logged in user.

[knash (Ken Nash)]

@Ahorodenski

SuperID

not familiar with this term.

What are you trying to do with the BAQ results?

[JMPCONJ (John Magee)]

@knash

@Ahorodenski

SuperID

not familiar with this term.

Field EmpBasic.SupervisorID…so I guess the BAQ just needs to pull all EmpBasic records where CurrentUser = EmpBasic.SupervisorID?

[Ahorodenski (Alex Horodenski)]

Correct, the SuperVisorID

[JMPCONJ (John Magee)]

Assuming I’m reading this right…add table EmpBasic to your BAQ diagram and set this table criteria…then select the other fields from the table to be displayed (first name, last name, etc)

[Ahorodenski (Alex Horodenski)]

Want to generate a BAQ that filters the employee to the supervisor, so the supervisor cannot see any other employees but theirs and want it to be auto filtered without them entering their Employee ID to filter. Cant trust some of them

[Ahorodenski (Alex Horodenski)]

Thanks JMPCONJ, that is what I needed