OR relation in AOT View in ax 2012

Dynamics 365 for Finance and Operations/AX Developer Forum
1

Hi all,

I want to fetch all the Duties of both security Roles and security subroles of all users in one column in aot view, Can anyone please suggest me a solution to combine duties of roles and its subroles both in one column named SubroleNames . Please help me with an solution.(Note: The View contains tables in datasources like userinfo, securityuserrole, securityrole, securitysubrole, securityrole, securityroletaskgrant, securitytask in the view which is mentioned)

Thanks in advance,

Gopinath. M

2

Hi all,
while building a aot query can the same be achieved like how to give an or relation in aot query or relation between two parent tables(SecurityRole and SecuritySubRole) from the same child table securityRoleTaskGrant. Please suggest an answer ifpossible

3

Hi all,
To apply a union operation like OR condition in view, first the union query should be created with set of two sub queries and with this query the union operation can be achieved in view. Solution is achieved