multiple Many-to-many relationships and data loading weirdness / bug

(0) Share

Report

Posted on by Tanguy TOUZARD

113 Most Valuable Professional

Hi team,

One of my PCF controls (for Model Driven app) displays many-to-many relationship available records as checkbox (or toggle).

One user reported issue with data loading when having two many-to-many relationships between the same records.

I reproduced the error. To do so:

Added two subgrids for each relationship on the form
Configured them to use my PCF control
Publish form
Load the form for a record

What we can see is that all linked records for both relationships are ticked in the PCF for the first relationship. The second PCF see no ticked checkboxes (see attached picture)

It seems to me that the PCF control receives data from all many-to-many relationships in the first control, then nothing is send to the second control.

The fact that the name of the relationship is not passed to PCF makes me think the records are retrieved based on all relationships

Any thoughts? @HemantG ?

Thanks

2019-11-21_08-34-...

All responses (2)

Answers (1)

Hemant Gaur on at

Like (0)

Report

Re: multiple Many-to-many relationships and data loading weirdness / bug

Thanks for figuring this out and sharing the solution @TanguyT . I also ran into this once and one of my demo was magical :).

Usually Math.random(); does the trick if there is not a need of something as rigorous as Guid.

I will send a note to doc team to add this to the best practices for upcoming doc updates.

Hemant
Verified answer

Tanguy TOUZARD 113 Most Valuable Professional on at

Like (2)

Report

Re: multiple Many-to-many relationships and data loading weirdness / bug

I was completly wrong, sorry for that.

So it turns out that as multiple instance of the same PCF control reside in the same form, controls must have unique ids. My control was inserting same id multiple time which explains the whole behavior.

Lesson learnt : Be sure to always have unique id, meaning add in the id the name of the attribute or dataset you are playing with so that the id is always unique.