Question

How to identify the latest many to many relationship?

0

Hi, I have two objects, customer and discountlevel, with an many to many relationship. I Need create a microflow to identify and delete the latest many to many relationship between a given customer and a Discountlevel. Cannot figure that one out... any suggestions?

asked 2018-02-17

Tim Miller

1 answers

Rom van Arendonk · Accepted Answer · 2018-02-17

You need to store this data somewhere. Either you:

* Introduce an additional association between the Customer and DiscountLevel, pointing to the lastest one. You find the previous one, but you have no order before that.

* Introduce an addition entity between Customer and DiscountLevel on which you save the createdDate of that relationship. You can then find the latest (and the one before that).