When we try to group by any field or using a function... the data disappears from the grid
Support Forum
In the posted example, you're not asking it to show any data.
The columns have to match the data in the records.
Your records have
{
"id": "793f5ea9-cf59-4391-a587-c1ee924d366b",
"schedule_goods_id": "793f5ea9-cf59-4391-a587-c1ee924d366b",
"group_id": null,
"sub_goods_id": 249,
"goods_id": null,
"children": [],
"goods": null,
"group": null,
"subProduct": {
"sub_product_id": 249,
"goods_id": 843,
"name": "Tarif enfant",
"section_id": 1,
"price": 12,
"sell_price": 15,
"vat_rate_id": 1,
"created_at": "2023-01-16T15:03:22.000000Z",
"updated_at": "2023-12-06T15:28:36.000000Z",
"price_ttc": 18,
"unit_id": 1,
"commission_rate": 10,
"quantity_min": 0,
"quantity_max": 0,
"show_in_finance": true,
"fixed_price": false,
"position": 0,
"section_name": "SPECTACLE",
"rate": 20,
"margin_rate": 20,
"unit_name": "Personne(s)",
"unit_shortname": "Pers",
"unit": {
"id": 1,
"name": "Personne(s)",
"position": 3,
"created_at": null,
"updated_at": null,
"shortname": "Pers"
}
},
"quantity": "1.0000000000",
"used_quantity": null,
"is_used": null,
"description_internal": null,
"position": 0,
"type_operation": 1,
"second_qty": "1.0000000000",
"second_unit_id": 3,
"second_unit_shortname": "U",
"used_second_qty": null,
"show_in_finance": 1,
"need_alert": false,
"tags": [],
"document_service": null,
"document": null,
"schedule": {
"id": "138afd69-08af-4c94-9f7c-e9f3b8e33c16",
"name": "dsfdsfdd",
"eventType": null
},
"created_at": null,
"name_exploitation": null,
"date_from_exploitation": null,
"date_to_exploitation": null,
"time_from_exploitation": null,
"time_to_exploitation": null,
"comment_exploitation": null,
"product_id_exploitation": null,
"hall_id_exploitation": null,
"halls_group_id_exploitation": null
},
And your columns are name
, 'airline` etc. Nothing is going to show