Group by logic and missing data after groupping


I have a problem understanding the logic of Group By to do something quite simple, or there is another logic that escapes me…

Let’s imagine I have this type of list in a JSON object:
[{“artist”:“Madonna”,“Title”:“Like a virgin”}
{“artist”:“Lady Gaga”,“Title”:“Bloody Mary”}…]

My goal is to list one title per distinct artist. In SQL I would have done a “Group By” looking like ‘SELECT artist, title from tbl_songs GROUPY BY artist’ and I would get what I like. But with Bubble it’s a nightmare because the group by then only returns the grouped by value, artist in this case, so where is my title ?!?

If you have an idea, thank you for your valuable help.

This topic was automatically closed after 70 days. New replies are no longer allowed.