Add Range in AOT Query where worker is not logged in person

(0) Share

Report

Posted on by Community Member

Hi,

I have HcmWorker as datasource in my AOT Query and i want to restrict the resultset by not having logged in person in the output. Here please consider that all ax users have corresponding worker related to it.

If i want to include current user i would use (currentWorker()) in the value field of the Range. but I'm not sure how to exclude current worker. I tried !(currentWorker()) but it doesn't work. Any hint would be helpful.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Sort by

AX 2012 r3 2,426 on at

Like (0)

Report
Copy link

Link copied!

Hi VDY,

Are you using AOT Query or is it Query using X++

Regards.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

It's AOT query. I believe I mentioned that in my question.

I could put the range in the executeQuery() method of the datasource after adding this AOT query to the Form.

but just want to know if it's possible to exclude logged in worker at design time.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

It is somewhat unclear on what you mean by logged in worker.

But if you mean Online users form, the table behind is called SysClientSessions. If you want to start from HCMWorker, then you need to join that with UserInfo, after which you can link it to SysClientSessions based on Id (which is UserId).

That way you can filter your workers by putting a range on the SysClientSessions.Status field.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Vilmos,

You are correct that i want to filter based on current user id. but i want to exclude them from the output. Is that possible to exclude without adding UserInfo table in the join.

Was this reply helpful? Yes No
Adam Duckworth 130 on at

Like (0)

Report
Copy link

Link copied!

Its not as simple as !(curUserId()) is it?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

that's why my query.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 239,735 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
I gave it a try and it seems that "it doesn't work" in this case means that when trying to put such a range value, AX immediately shows this error: Invalid value (!(currentWorker())) specified in the query predicate.

I would simply create a new method (such as notCurrentWorker() in SysQueryRangeUtil - then you can use it in the same way as currentWorker().

It can be as simple as this:

public static str notCurrentWorker() { return strFmt('!%1', DirPersonUser::currentWorker()); }

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,

Thanks for guiding to right direction.

I tried it. but as my Range is on RecId field of HcmWorker, it doesn't accept string value returned from notCurrentWorker() method.

I throws below error.

"Query extended range failure: Syntax error near 0."

I think I should go with the executeQuery method filter.

Was this reply helpful? Yes No
Martin Dráb 239,735 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Of course it does accept strings. The range value is a string, regardless of the type of your field. If you provide a number, is converted to string before setting as a range value. Also, I tested it before sending my reply.

You either have a bug in the method, or you're using it wrong.

Was this reply helpful? Yes No