Group RG list by text value and display value inside RG

Hello!

This is a bit of a tricky one to explain…

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.

With each ‘Task’ having a ‘Task Group’ data field, what I want to do is:

  1. Group the displayed texts/Tasks by their ‘Task Group’.

ie: Instead of Website, Website, Social, Social, Website. (See screenshot below)
I’d like Website, Website, Website, Social, Social.


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’…

  1. 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.

ie:
Website

  • Task 1
  • Task 2

Social

  • Task 1

Why can you not apply a Group by Operator?

I’m not sure… Not even there when I remove the :split by operator.

Any ideas?

Screenshot 2024-04-15 at 6.44.22 PM

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?

Unfortunately still no :group by operator.

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 see - in that case, how do I display my API call text (which is split by: )?

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.

Any ideas?

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?

Does anyone have any ideas?

Any advice is appreciated - Thanks!

that is because the expression you created is a list of something, and not a single value, but the unique id is expecting and requiring a single value

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