Hi!
How can I remove columns from the Outsystems DataGrid component? Or from the aggregate that is the source of the Grid?
I don't want to show all columns from my tables to the users...
Thanks!
Hello @Diogo Barbosa
If you are using JSON data directly as grid source you might have to use javascript to hide columns.
Other way is:
1) create a structure with required columns as mentioned by @Dorine Boudry
2) Bound the aggregate output to your variable list (structure)
3) Then call the ArrangeData with the same variable (structure) list
4) Get the JSON output with required column and bound to Grid source
5) Add the columns to Grid manually and bind the headers
Attached is the OML for your reference
Regards,
Vinod
Wonderful example man!
Thank you!!
Hi,Please go through this link and let me know if its workshttps://www.outsystems.com/forums/discussion/66919/outsystems-data-grid-data-grid-reactive-hide-or-delete-colums/Thanks
Hi @Diogo Barbosa ,
do you mean when you are using auto generated columns ? I guess, make a structure representing the data you want in the grid, move the result of your aggregate to a variable of list of that structure, and then use that variable as the source for your grid.
Dorine