View from AOT query with currenUser() as range

(0) Share

Report

Posted on by Community Member

Hi, I've created an AOT query in AX 2012R3 with a range where the userId is set to (currentuser()).

Let's say I am logged in as User1. This works fine. I get all the records from the table that where created by the User1. All other user can see their own records as expected when using this query.

However, when I use this query as a datasource in a view I need to synchronise the view with the database in order to see the records of User1. At the same time all other users can see the User1 records as the view is synchronised with currentUser = User1. Please advise how I can make sure the view is only showing the records for the currentUser.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Sort by

István Orosz 2,137 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Would you add some more details please about your query?

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 305,465 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi LouisH,

This is as far as I have experienced not possible. The synchronization is indeed replacing it with the actual user. You can actually use eXtensible Data Security to constrain the records based on the user (then remove the current range in the view). Another option is to apply a filter on a form or report during runtime.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Andre,

Thanks for the quick reply. Good to read that your findings are like mine.

Kind regards

Louis

Was this reply helpful? Yes No