So I have an RG that is displaying a list of text. Each cell’s text has a different unique ID relating to a corresponding ‘Task’ in my database.
I’ve attached a screenshot to help explain how the text is currently split.
How do I achieve this with my currently RG’s data type, and data content? I can only apply a ‘:sort by’ operator, and not a ‘:group by’…
Referring back to the first screenshot of the element’s - my Group Board Groups #3 element is the element for ‘Website’ or ‘Social’ etc. How can make it so there is only ONE of these Task Group headings per list of Tasks.
try putting the group by after the Messages, so basically remove the each items and split by…but there may be a possibility that you can not use the grouped by operator on text data type and need to do it on a data type
but can you explain about where the Task and Task Group data fields are coming from? Are they in your database, or are they being returned via an API call?
Yeah so Task and Task Group are from my DB. Each Task has a Task Group to which it belongs in. The API is returning each task’s corresponding unique ID, which I’m trying to use to achieve both of my questions by filtering data with it (unsuccessfully).
You need to display in the RG the Task, not text, so set the data type to be of Task.
Then use a constraint for the unique id is in and the API calls response that contains the unique ID of the tasks.
If that doesn’t work, show screen shots of your database data types and fields as well as the API call response fields you are getting from the API call
I’ve created the RG for Board Group’s where the Board Groups are being filtered by Task’s unique = the unique ID in the block of text returned from the API - but its an invalid expression.
I’ve also tried the same approach through Tasks as type of content for the RG, and no luck either. Doesn’t appear like I’m able to filter Tasks with a list of unique IDs?