I have 3 tables:
Each entity can have multiple snippets of text, and each snippet has a type
I need to show a list of the entities, and for each one show each of their snippets w/ types.
My query returns as many rows for an entity as it has snippets… but I only want the data from Entity to show once, and all of the snippet/snippet type data for that entity to be shown in its row.
I can think of 2 ways to do this and can’t figure out how to do either of them in Appsmith:
Option 1) Split the query into 2 separate queries. Show a list of entities with one query, and in each row show snippet data from a second query based on entity id.
Option 2) Take the combined data from the query I’ve been working with and transform the data somehow that Appsmith can then display the way I need.