Finance | Project Operations, Human Resources, ...

What is the proper way to add a left outer join relation in a data entity data-source?

(0) Share

Report

Posted on by itlabnarmi_ivoruk

135

Data entity have only two options to join data sources (inner and outer join). and other two ( exist and not exist) need to firstly convert data source to data entity view and apply these join. How can I use left outer join in data entity ?

All responses (2)

Answers (0)

Suggested answer

Mohit Rampal 12,558 Moderator on at

Like (0)

Report

RE: What is the proper way to add a left outer join relation in a data entity data-source?

Hi, In SQL we have concept of Left outer join and Right outer join as specified below. However, in Ax we don't have Right Outer Join, its only Outer join which is left outer join.

Left Outer Join: Returns all the rows from the LEFT table and matching records between both the tables.

Right Outer Join: Returns all the rows from the RIGHT table and matching records between both the tables.

community.dynamics.com/.../left-outer-join-in-ax-2012
Suggested answer

GirishS 27,825 Moderator on at

Like (0)

Report

RE: What is the proper way to add a left outer join relation in a data entity data-source?

Hi,

There is no left outer join in dynamics Ax - You can use Outer join for the data entities which works similar.

Thanks,

Girish S.