Struggling with 'Intersect With'

Hi all,

Been Bubbling for a while, and I think I had this a while ago, but I am suffering a massive brain fart this morning, and am wondering if anyone can help me out.

I have a RG of ‘Shares’. In each ‘Share’ is a List of Things called ‘Interest’.

Each user has a profile, and each profile also has a List of ‘Interests’.

I am trying to get the RG to show Shares which contain at least one Interest that the Current User’s Profile contains.

I’m going around in circles trying Intersects, Filtered, Merged etc but I just can’t figure it out.

Anyone able to help?


Hi there, @andmilne… have you tried an intersect between the two lists with the addition of the :count option? Something like this…

Think that might work for you?


1 Like

Brilliant - Thanks @mikeloc

1 Like

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