web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Query for policy

Microsoft Dynamics AX (Archived)

Query for policy

(0) Share

Report

Report

Posted on by Skribl

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

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (1)

Mea_ 60,284 on at

Like (1)

Report

Did you try SysQueryRangeUtil::currentUserId() ? You can read about SysQueryRangeUtil usage here blogs.msdn.microsoft.com/.../using-dynamic-query-values-sysqueryrangeutil-in-dynamics-ax

Was this reply helpful? Yes No
Skribl 40 on at

Like (0)

Report

Nope it do not work. I need to put some dynamic value in Datasource range node.

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

It would be helpful if you tell us more, like do you have any error or what?

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Skribl 40 on at

Like (0)

Report

Sorry,

SysQueryRangeUtil::currentUserId() worked. Thank you ;)

i put class method directly in datasource range node as (SysQueryRangeUtil::currentUserId()).

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Martin Dráb 4 Most Valuable Professional

#1

#3

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans