alirazazaidi: How to get Worker’s Dependent Dynamics Ax 2012 R3

[Blog bot]

Источник: https://www.tech.alirazazaidi.com/ho...cs-ax-2012-r3/
==============

Here is small and quick tip. Couple of Days ago I helped a developer to get Dependent out of worker.

Microsoft provide a View DirPartyRelationshipsUnionView. Here Worker Party Id is saved as “otherParty” and dependent Party id can be found as ” SELFPARTY”.

Quick SQL query is below,

select name from DIRPARTYTABLE where recid in (

select SELFPARTY from DirPartyRelationshipsUnionView where OTHERPARTY =5637146826)



Источник: https://www.tech.alirazazaidi.com/ho...cs-ax-2012-r3/