Hi Alexander,

The easiest way to do is to create a structure with the selected column for your data grid

Then use the dataAction, to map the aggregate result to the structure.

After that, convert that into json, and use it in your grid.

Hope this help.

Hello Alexander,

You can create new structure into data tab including only attributes you want to display and make output data type of your data fetch action using this structure you created.

Otherwise you can drag and drop only columns you want to display to grid.

the same procedure with multiple entities 

then I must also give the Id ? 

Hi @Alexander Eder,

By looking at your screenshot , i guess you are using DataGrid. Correct me if i am wrong.
You might have used Columns in page to display the records, and probably bind the attribute  to display in page.
If you do not want to display the ID attribute information, you can remove the column where the ID attribute is bound. 
In the example below, I am showing the ID, FirstName, and Lastname in the screen. If I do not want to show the ID, I can delete the column where the ID attribute is bound. 
Hope it helps!
Regards

N_G

Hi @Alexander Eder 

I have created a Sample for you where I am fetching data from an aggregate where we have  join between two entities,

You can refer to that for the Use case

Sample - https://personal-ejuytnht.outsystemscloud.com/Sample_OS/Grid 

Best Regards
Tousif Khan

thank you @Tousif Khan, @N_G G, @Mostafa Othman and @ Kay Lun for all the help ;)

@Kay Lun ,

if at all possible, the ArrangeData action should be used from OutsystemsDatagrid module, rather than a generic JSONSerialize.

Dorine