I have a dynamic query and i want to fill a chart with  the results from that query, but the result Structure is based on the query made before, i tried to make the result of the query a json how is sugested on the link below.

 https://www.outsystems.com/forums/discussion/53381/generate-a-chart-from-a-dynamic-sql-input/

but did not solve my problem.

What am I missing?


Hi Bruno,

You can define the output of the Advanced Query to be a structure with the exact fields you need to pass to the chart, instead of using directly the entities.

Does this solve your problem? You didn't provide details.