Migrate From One to Many Association to Many to Many Association

0
I'm currently working on a project where I need to modify the association between entities from 1-to-* to *-to-*. However, making this change directly results in numerous errors. I'd like to know if anyone else has encountered this issue before and found a solution. Specifically, I'm looking for advice on how to update my domain model to accommodate the new association while ensuring that existing data remains valid. Could you share any relevant experience or insights you may have regarding this challenge?
asked
2 answers
1

To add and not to the discuss the reason why you want to change the reference I would always add a new reference and keep the old one. You could then create a microflow routine that populates the new reference based on the values of the old reference and take into account all of the above.

Regards,

Ronald

 

[EDIT]

And after the migration then in the next release you could delete the old reference. Just to make the process complete.

answered
1

The errors you get will be of the following types

Microflows

  1. The retrieved dataset over association returns now a list instead of a single object. depending on scenario iterate over the list or use list operation Head

Pages

  1. A reference selector cannot acomodate *-*, replace it with a reference set selector or a combo box
  2. Nested dataview cannot deal with a referenced list > show be turned into a list
  3. Search fields depending on type need to be updated/replaced

 

Besides the technical errors, you should first think over the reason why you are changing the 1-* to *-*. In the first place this will answer the questions on how to solve the challenges per given error. To head or to iterate etc...

 

Next to that, in most cases *-* won't do the job, since additional information is required, describing the relation, and thus a entity in between wit 2 1-* associations would be a better solution. This will cause an even bigger change of model.

 

Just one tip; rename the error dock mentally from errors to ToDo-list. Its the same list, just a handy list to work through, fixing the new challenges.

 

In any case; a right click solve errors option does not exist ;-)

 

 

answered