40
Hello,
need some help with one issue.
I have Query AOT that I using in Policy. Problem is that i have one dynamic range for one of tables. I should add current user id to range value.
I tried to solve it by setting rangeField in init method, but policy execute pure query (do not invoke init method).
Is there a change to put method into range parameter or any other ways to solve this problem?
*This post is locked for comments
a workable way that i have done in past was
1) creating a table that has refresh frequency per session. You can find many table named as e.g. MyLegalEntities etc. similarly you can create a table named MyUserId. Keep refresh frequency per session.
2) in your query make a join with MyUserId (Table)
3) use your query in Security Policy
if you will follow the white paper from Microsoft, that has example based on similar architecture
Did you try SysQueryRangeUtil::currentUserId() ? You can read about SysQueryRangeUtil usage here blogs.msdn.microsoft.com/.../using-dynamic-query-values-sysqueryrangeutil-in-dynamics-ax
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (