CurrentUserId() method as the range in the static query ( AOT query)

(0) Share

Report

Posted on by martinarul

223

Hi Friends,

I am trying to give the CurrentUserId() method from SysQueryRangeUtil class as the range in the static query (AOT query) to filter the record related to the currnent user.

The value is not getting filtered. if I hard-code the current user id as "abcuser" in the range it works fine

Note: we cannot use the metnod "curUserId()". we need to use method from the class SysQueryRangeUtil.

Have you come across this kind of issue?

your help much appreciated.

Regards

Martin

I have the same question (0)

All responses (10)

Answers (1)

Martin Dráb 237,795 Most Valuable Professional on at

Like (0)

Report

How did you try to use it? Do you know that the value must be (currentUserId()) and not just currentUserId()?

Was this reply helpful? Yes No
martinarul 223 on at

Like (0)

Report

Hi Martin,

I gave the range value as you suggested only. I gave within the brackets but it did not work as well.

I tried the following ways:

(CurrentUserId())

SysQueryRangeUtil::CurrentUserId()

(SysqueryRangeUtil::CurrnetUserId())

none of it seem to work.

Regards

Martin

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Martin,

Martin Dráb is right, (currentUserId()) is the correct statement. I can confirm that it works. How did you decide that it doesn't work? Maybe you expect another behavior?

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

HI Martin Arul,

The SysQueryRangeUtil class includes a number of functions that list pages used to dynamically control the data that is shown based on the value that id returned by the function.

As mentioned, The function call has to use the same syntax as passing expressions in a range value.the whole value needs to be surrounded by an opening "(" and closing ")".

Please refer : community.dynamics.com/.../using-dynamic-query-values-sysqueryrangeutil-in-dynamics-ax-115157664

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

Was this reply helpful? Yes No
martinarul 223 on at

Like (0)

Report

Hi Sergei,

I am using dynamics 365 F&O (Update31), I had put the range as Martin suggested only but, it does not filter the record based on the current user ID.

Regards

Martin. A

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Martin,

How do you run operation (batch or not)?

Was this reply helpful? Yes No
martinarul 223 on at

Like (0)

Report

Hi Sergi,

Basically I wanted to create a static query to be applied in the security policy for XDS purpose and wanted to filter the data based on the current user who logged-in. when I attached that query in a View and opened in the table browser, it did not filter the record. if I give one user value as a string (e.g: "abcUser") then it works fine, but if I give as (CurrentUserId()) it is not filtering the record.

For testing purpose i created a simple view and added "purchTable" as datasource and and added "createdBy" field as range and gave the range value as "(currentUserid()), it did not filter the data for me.

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Martin,

But it's not a query object. I'm not sure if it's working for views as views are physically created in DB as real SQL views.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,795 Most Valuable Professional on at

Like (0)

Report

This can't work. The method will be executed just once, on synchronization, and this single user ID will be included in the view definition.

If you need a view, let it return a column with user IDs and filter this column in a query.

Was this reply helpful? Yes No
martinarul 223 on at

Like (0)

Report

Hi Martin,

As you mentioned, my query was combined with tables and views, unfortunately my range was in the view and so it took only one userID during the synchronization.

Regards

Martin

Was this reply helpful? Yes No