How to store query result DatabaseConnector in persistent entities?

0
I get a list of objects through a microflow of a non-persistent entity through a query with the DatabaseConnector. But how can I store that result in a persistent entity or entities?  
asked
7 answers
2

You can create a new persistent entity in the system and then handle the data that you get by your database retrieve and save them then into your presistent entity as you want to have them.

answered
1

Sounds like you need to implement a microflow and a logic  to retrieve the data and then create or update your persistent entities. The complexity is dependend on your use case. If you are not sure about how to handle microflwos, please take a look for the academy section, there are some very helpful learning paths.

answered
0
  • Create a persistent entity in your domain model
  • loop through the Gestiones_2 list
  • create a persistent object for every object in Gestiones_2, while copying all relevant attribute values to the new object.

I hope this helps.

answered
0

How do I do it?

What I would like is to get all the data from my external database and store it in entities to insert and update and save in my external mysql database.

This is my domain model:

 

Gestiones_2 is just a test ... I want to load all the entities. Please.

answered
0

Hi Michiel!

I have tried this, but it does not work, it does not load data in the Gestiones entity:

What am I doing wrong?

answered
0

You need to commit and refresh in the create gestiones action.

answered
0

Ok, yes I have put commit and refresh but the data is not shown in the templateGrid. The row counter is correct, but they are not displayed on the screen.

 

answered