Hello fellow Xano enthousiasts,
I am stuck with manipulating results from a database to make it easily usable for my frontend. The current result I am getting is attached as an image below. What I would like is to group all the results by category as a separate array.
So basically an array for 'Time' would contain all the rows from the database where the key 'category' equals 'Time'.
Does anyone have an idea on how to achieve this?
Thanks and have a wonderful day!