(Solved)RG Contraint/Filter

Hey!

Finally reached the level where I ask the forum what I cant understand myself.

I have a database of Projects.
This contains a list of Bookings.
This contains a Assignee.
This is a User.

I’m trying to populate a RG with the Projects where the User is assigned to a Booking.
When I search for all Projects, no problem.
But all my efforts to Constraint or Filter this is been out of luck.

Here is what my logic tells me:

“Search for Projects”
Contraint “Booking contains Search for Bookings(Assignee = Current User)”
But this leaves me with a list of Bookings in the constraint, which faults the data.
If I do :first item or :item# I get it to work with only one Project, but I want to list all the projects.

Anyone has a great plan for how I can achieve this?
Thanks :slight_smile:

And there, I solved it on my own :smiley:
It was a matter of going into an advanced filter…

“This Project’s Booking’s Assignee contains Current User”

Whoa, that was great, been stuck for so long on this stupid thing :smiley:
It was a matter of going into an advanced filter…

“This Project’s Booking’s Assignee contains Current User”

Whoa, that was great, been stuck for so long on this stupid thing :smiley: