Struggling with 'Intersect With'

[andmilne]

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?

Cheers.

[mikeloc]

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

Searching using multi dropdown - possible/alternative? Incompatible type

I responded to your response, @mattb, but my “solution” was garbage because I didn’t test it properly. @rico.trevisan’s response set me off down another path (Thanks, Rico!), but I couldn’t get it to work because I don’t see is in as an option in my advanced filter. That being said, I played around with it a bit more and got the advanced filter to work with the following constraint… [multi] Now, I admit that constraint might be a bit hacky, and Rico probably has a much better solution… but it…

Think that might work for you?

Best…
Mike

[andmilne]

Brilliant - Thanks @mikeloc