displaying employee job title on form

(0) Share

Report

Posted on by munsif

1,536

hi expert, i want to display employee job title (designation) on my custom form, the data coming from two different tables, hcmworkerposition details table and premployeementinformation,

i just add both data set on my custom form data set, and set property for join property on form for table HmcworkerPosition toPremploymentInformation, also add control field employee position on form and reference data source hcmworker position table,

but the data is not coming accurate..

please guide me.

Regards.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

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

Like (0)

Report

Can you please explain the problem? "data is not coming accurate" isn't very specific. Also, what's the relation between those tables? If you mean some standard table, please give us exact names (my version of AX contains neither HcmWorkerPosition nor PrEmployeementInformation table).

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

If you want a solution for standard AX, use HcmPositionWorkerAssignment table. You can use its description() method, or join it with HcmPositionDetail and get the description from there.

Was this reply helpful? Yes No
munsif 1,536 on at

Like (0)

Report

thanks martin for you kind and valuable relay as always,actually the form on which i want to display employee designation as customized table not standard,and having fields

EMPLOYMENTTYPE EARNINGRULECODE BENDEDRULECODE PAYGROUPCODE ENTITLEMENTRULECODE BASICSALARY EMPLOYEEID DAILYWORKINGHOURS PAYMENTMETHOD CURRENCY STARTDATE ENDDATE SALARYSTATUS DIMENSION EMPLOYEENAME GENERATIONTYPE REFRECID DATAAREAID RECVERSION PARTITION RECID,

and i want to make relationship of this table to a table (HcmpoistionDetail) or any other which have employee designation ,so how it can.

Regards.

Was this reply helpful? Yes No
Faqruddin 1,883 on at

Like (0)

Report

Dear Rehman - Please call the display method in your custom form and write the code for join the two tables. I'm sharing my sample code and replace the code with your tables..

display ItemGroupId itemGroupId()

{

InventItemGroupItem inventItemGroup;

select ItemGroupId from inventItemGroup where inventItemGroup.ItemId == this.ItemId

&& inventItemGroup.ItemDataAreaId == this.dataAreaId;

return inventItemGroup.ItemGroupId;

}

Best Regards,

Faqru Shaik

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

Like (0)

Report

Arbitrary field names don't say much. Please tell us about logical relations of your table to other tables.

Was this reply helpful? Yes No
munsif 1,536 on at

Like (0)

Report

thankx for so much cooperation guidance once agian,, table have relationship with HcmWorker through EmpIoyeeid,i.e customTable.Employeeid==Hcmworker.PersonalNumber

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

One employee can have multiple positions. If you want a single title, you must somehow pick just a single position.

Either you need some extra information in your table (maybe position ID). you have to choose the positions by some business logic (e.g. to take the primary one or a random one if none is primary).

Was this reply helpful? Yes No
munsif 1,536 on at

Like (0)

Report

ok , but if i want to get single primary position for an employee and then want to display his/her desgination, so how it can ,while my custom table have only relation with HcmWorker table,

Regards Dear Martin.

Was this reply helpful? Yes No
Verified answer

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

Like (0)

Report

Please define your criteria exactly. For example, if you look for primary positions only, you may get no results, because no one must be set at primary. Unfortunately I can't tell you what your business requirements are.

Then tell us what problem you have with implementing your requirement. Do you understand how to write queries and use display methods?

Was this reply helpful? Yes No

Community site session details

displaying employee job title on form

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

displaying employee job title on form

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates