lookup querry to get workers under cuurnet user/manger

(0) Share

Report

Posted on by Community Member

hello evryone i'm new to D365 F&O and i have a task where i need to create a field in a dialog that shows the name of the workers under the current user

So i have this line of code

HcmPositionWorkerAssignment::doesWorkerReportToManager(hcmWorker.recId,HcmWorker::find(HcmWorkerLookup::currentWorker()).recId,true);

that is supposed to return true if a worker is under the current user.

So My problem is i don't know how tu use it in a lookup querry

My dialog table name NouvelleMesuresDialogTmp and the field is Employee

any help would be nice thank you

I have the same question (0)

All responses (21)

Answers (1)

André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (0)

Report

Hi Wassim77,

Can you elaborate on the functional requirement? Just mentioning that you have a dialog, does not tell what it is about. You also shared just a technical table name which is a customization. We can't guess what exactly you need to achieve. Can you clarify your requirement with a detailed description and/or a screenshot as illustration?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

thank you André for your response i will try to clarify.

i'm creating Disciplinary Mangement system under Employee Selfservice in order to do that a created a new form

in this form when clicking on the new button a dialog opens in this dialog the user needs enter some informations and some other informations are already initialized like the current user

i have a field where the user chose a worker from his team to apply the mesure on him

So here i need to get the team circled in blue into my field cicled in black

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

Hi wassim77 ,

You need to use 3 tables to get the workers who all are reporting to team leader.

1. Get the position for the "Team Leader".

2. Join HcmWorker - HcmPositionWorkerAssignment - HcmPosition - HcmPositionHierarchy with the relations.

3. Add range to HcmPositionHierarchy table for field "ParentPosition" and the value should be the "Team leader" position.

Thanks,

Girish S.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you for your response girishs

I'm really new to d365 can you elaborate more

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

Hi wassim,

So lets go step by step, Try to get the "Team Leader"( from your screen shot it is "Julia funderbuek") position using select statement.

After that you can build lookup query.

Thanks,

Girish S.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
So this is my code

Query query = new Query(); QueryBuildDataSource queryBuildDataSource; QueryBuildRange queryBuildRange; SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(HcmWorker), sender); sysTableLookup.addLookupField(fieldNum(HcmWorker,PersonnelNumber)); sysTableLookup.addLookupMethod(tableMethodStr(HcmWorker,name),true); queryBuildDataSource = query.addDataSource(tableNum(HcmWorker)); sysTableLookup.parmQuery(query); sysTableLookup.performFormLookup();

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

On the same lookup method get the team leader position using select statement.

After that add the datasource with hcmworker table as mentioned in the previous posts.

Add the range to parent position field. Query value you will get it from select statement .

Thanks,

Girish S.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

can you perform the changes on te code please

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

Hi wassim,

Try it on your own, If you had any doubt means you can post here we will help you with suggestions.

Please see the below link for getting the position assigned to the worker.

https://dynamicsax4u.wordpress.com/2014/05/16/get-position-of-a-worker/

Also for lookup with multiple table joins and ranges, please see below link.

https://learn.microsoft.com/en-us/dynamicsax-2012/developer/how-to-add-a-lookup-form-to-a-control

Thanks,

Girish S.

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

Hi Wassim,

Are you able to solve this?

Thanks,

Girish S.

Was this reply helpful? Yes No