BAQ - Security

[changchai (Chai Chang)]

I have a request from a user for a particular BAQ. They want this BAQ available to all plants, but only users in that particular plant(s) can pull data from that plant(s) only. I turned the BAQ into a dashboard, create a test user, and when I run the dashboard, it is pulling data from all plants. Anyway how it can be secure so that only data from the plant(s) the user have access to can query the data?

[josecgomez]

Sure add the current user as criteria as well as the table which lists the Plants they have access to to the query and filter on that.

[pchestnut (Phillip Chestnut)]

Try using the BAQ Special Constant on the table with Plant = CurrentPlant.

[changchai (Chai Chang)]

Okay thanks. Was going to ask how to add in Current User, but that helps.