Good afternoon everyone, I am new to the OutSystems platform and therefore I am stuck in a process where I had to show the records consulted in a Reactivate DataGrid; the query I perform returns this structure
According to my requirements: the date column should not be displayed at the bottom of its values, but on the right as a column each date value, as shown in the image below:
How can I achieve to do that; Beforehand thank you very much.
Hello there Ronaldo,
Hope you're doing well.
First of all, welcome to OutSystems!
Please consider that the main language used in the forums is English. Therefore, I suggest that you write your communications in English, so more people can help you.
Kind regards,
Rui Barradas
OK very kind @Rui Barradas
Hello Ronaldo.
You have to handle the data accordingly. Check the documentation.
If you want to learn more about DataGrid, there is an event in a couple of days.
https://usergroups.outsystems.com/events/details/outsystems-inc-bangalore-presents-working-with-data-grid-in-outsystems/
Thank you very much for the help @Nuno Reis
Hi Ronaldo,
I think you´ d have to look at having the grid auto generate columns, and fetch your data with an sql widget making use of the pivot operator and the for json auto clause.
Both are sql constructs, not outsystems. Pivot is harder to learn, but can be googled.
Dorine
Thank you very much for the help @Dorine Boudry