How to convert the list returned from SQL query into object as return type in microflow?

0
Because in Data View only the object gets accepted as return type in microflow, and here is my flow diagram
asked
3 answers
0

Heey Krishna,

 

A dataview only accepts a single object as an input parameter. Instead of using a data view on your page you can use a data grid. A data grid accepts a list as an input parameter. With that you can use the Climate_List as the return of the microflow and show it to the user.

 

Hope this helps.

Kind regards,

Edo

answered
0

Hi Edo Ekkel, 
I needed the data’s obtained from query to get processed in charts, so is it possible in Data Grid.

answered
0

Hi Krishna,

you can convert the list to json and map it to an attibute in that entity and can be displayed in your chart as shown below

 

You can use export with mapping to convert the values to JSON .

https://docs.mendix.com/refguide/export-mappings/

Hope it helps!!!

answered