Relation in data entity

(0) Share

Report

Posted on by alinawaz

209

Hi Community Fellows,

I have added a new Field in HcmPositionDetail Table called "ARParentDepartment" and created a new relation with "OMOperatingUnit" table as well.

Now I want to add this field in "HcmPositionDetailEntity" as well but I want to expose it as a Parent department number field instead of a Parent department RecId so that we can use that column for data update/insertion through excel Add-in.

I have created an extension of "HcmPositionDetailEntity" and added the "ARParentDepartment" recid in its fields but I am stuck on transforming it into a department number field.
I have an existent Department Rec Id and Department Number field in the "HcmPositionDetailEntity" already.

I have tried creating a same relation in the "HcmPositionDetailEntity" but the entity is showing the same data in ARParent department number column as of the existent department number column.

The requirement is to have a column of Parent department number which displays department numbers based on the Recids present in the ARParentDepartment field of data entity.

Looking forward to usual helpful responses.

I have the same question (0)

All responses (11)

Answers (1)

Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

RE: Relation in data entity D365FO

Hi Ali,

The best example for this will be to look at CaseDetailBaseEntity. As in this entity, you will need to join OMOperatingUnit as a read-only datasource to HcmPositionDetail based on the new field you created.

The field ARParentDepartment in your case should be added to the entity with "Access modifier" property set to Private, as is the case with Department field.

You will need to add OMOperatingUnitNumber from OMOperatingUnit into the data entity fields.

Finally, the data entity relation will be based on the field created above with OMOperatingUnitEntity.

This should take care of your requirement to show the Department number and also update the Department number.

Was this reply helpful? Yes No
alinawaz 209 on at

Like (0)

Report

RE: Relation in data entity D365FO

Hi Gunjan Bhattachayya

I have followed your instructions but the data in SQL is still the same after build and sync.

I added the "ARParentDepartment" RecId in the entity and marked the access modifier private.

Then I added a new Mapped field named as "ARParentDeptNumber" in the data entity fields

After this I have added a new foreign key relation

In the relation properties I was unable to the "OMOperatingNumber" column so I have typed it manually.

After doing all these steps, I am still seeing the same data in ARParentDeptNumber and Department number column in SQL.

Maybe I am doing something wrong here ?

P.S: There's one Department number column already present in entity and it has the same relation with OMDepartmentEntity, I tried replicating the same relation but its also returning same data in SQL in both columns (ARParentDepartment Number & Department Number ).

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

RE: Relation in data entity D365FO

Hi Ali,

I didn't check the entity that you are extending. In your case, since OMOperatingUnit is already included in the data source, you will need to add another data source with a different name (OMOperatingUnit_Parent for an example). This data source will be linked based on the ARParentDepartment field - HcmPositionDetail.ARParentDepartment == OMOperatingUnit_Parent.RecId.

From the screenshots you have shared, I can see that you are using the existing data source OMOperatingUnit, which is linked based on the field Department from HcmPositionDetail table.

Was this reply helpful? Yes No
alinawaz 209 on at

Like (0)

Report

RE: Relation in data entity D365FO

Thanks a bunch Gunjan Bhattachayya

It worked :)

You are a real life saver.

Best Regards.

Was this reply helpful? Yes No
alinawaz 209 on at

Like (0)

Report

RE: Relation in data entity

Hi Gunjan Bhattachayya

I am facing an issue while performing a full DB sync.

When I perform Sync from the project there are no issues, this error only appears on full DB sync.

Any idea where shall I look for the solution of this ?

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

RE: Relation in data entity

Hi Ali,

Could you try a full build of your Dev model and if there are no errors, do the DB synchronize?

Was this reply helpful? Yes No
alinawaz 209 on at

Like (0)

Report

RE: Relation in data entity

Yes I have build the model and it has no errors

But still getting the error in full sync

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

RE: Relation in data entity

Could you share screenshot(s) of the changes you have made in the entity extension? I will try to replicate them at my end and see if I get the same error while synchronizing.

Was this reply helpful? Yes No
alinawaz 209 on at

Like (0)

Report

RE: Relation in data entity

1 - Created extension of HcmPositionDetail Entity And added ARParentDepartment field in the data entity fields

2 - Added a new data source OMOperatingUnit to create a Parent department number field.

3- Added a new relation in the newly created data source OMOperatingUnit

4- Then added a new Mapped field inside the fields node of data entities, ARParentDeptNumber

5- Then I have also added a relation in the relation node of Data entity.

I have my suspicion on this step, when I was creating the relation no column name was appearing in the RelatedField property. But I wrote the column name manually there to complete the relation. I was looking at the existent Department relation and choose all same properties in the relation I created.

After all of these changes in Data entity, I created an extension of HcmPositionDetailStaging Table and added the ARParentDepartment field in it too.

These are all the steps I have performed. And If I build and sync the project there are no errors. The error only occurs in full DB sync

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

RE: Relation in data entity

Hi Ali,

I tried the same changes and didn't face any issues with DB synchronization. I also didn't get the drop down for fields for OMOperatingUnitEntity. One thing you can try changing is the Role property in the "parentDept" relation.

Role name "PostionDetails" already exists for the Department relation. If this doesn't solve the issue, you can try a full build of the application and see if that helps.

Was this reply helpful? Yes No