Hello
I have the result of a request which gives me this jsonb result
{"date": "29/08/23",
"fields":{
"event": {
"units": "",
"value": "session",
"def_num": 0,
"raw_value": 8
},
"sport": {
"units": "",
"value": "swimming",
"def_num": 5,
"raw_value": 5
},
"num_laps": {
"units": "",
"value": 5,
"def_num": 26,
"raw_value": 5
},
"avg_speed": {
"units": "km/h",
"value": 3.9663999999999997,
"def_num": 14,
"raw_value": 824
}
}
I need to transpose the result in a dashboard as a table
date num_laps avg_speed
"29/08/23" 5 3.9663999999999997
I need to select dynamically all keys which has a value = int or float + some manual values like date
each result can give me other properties linked to the sport type
is it possible to pass some dynamic values in the select clause or do I need to create new tables?