Sort RG by cell value of another RG - please help!

[brendan.a.ford]

Hi all,

I’m trying to build a daily to do calendar. Each task in the calendar has an assigned time for when its due.

To do this, I have two RGs:

1. The first to display the times from my db (in increments of 30mins, where the :30 time isn’t visible in the RG)
2. The second RG to display the tasks.

I want the task to appear in its correct corresponding duetime’s value.
Although here is what I have so far:

I thought of trying to use the Orchestra plugin to capture RG#1’s time value, then filter RG#2 by that value, but that doesn’t work…

Does anyone have any idea how I can achieve this?

[Newed]

I don’t think you need plugins for this. From what I understand, you want to sort the second RG based on the values ​​of each row of the first RG.

So all you need is to sort the second one in the search itself by date/time and filter it using the time on the each row of the first one.

Can you share any image of your current settings for both RGs?