Question

Matching objects from different entities - Microflow?

1

Hi everyone! The idea is simple: I’m uploading data with one template created and map it into a grid.Then, I want to match one of the variables that I uploaded with one already existing and then being able to have a reference selector filtering by the one already there… An example could be: I’m uploading a shop list (product1, product2, product3, etc...) but I’ve already my ‘product stock” uploaded in mendix… Using a microflow how should I match that “product1” (new file) = “product1” (already there) and be able to have a reference selector filtering accordingly… Thanks in advance….

asked 2019-08-09

Bernardo Cerveira

1 answers

Ridvan Oksuz · Answer 1 · 2022-06-22

Hi Bernardo ,

To understand that an object repeats twice, you must first select an attribute as a key within that entity. For your example I want to explain here, each object in the product entity can have an EAN number. When we think that this will be unique, we can detect that it has been registered via this number before.

Let's also assume that we are importing this information using excel importer . It also allows you to specify a data type as a key of the items in the list to be imported when using the Excel importer module. Thus , it prevents you from saving an item to the database twice .
My suggestion for you to do this in microflow is:
Retrieve all the products from the database. Iterate the products you want to add database to in a loop. In the loop , detect products with conflicting Ean numbers by using the list filter .
I hope this helps for you ,

Regards

Ridvan