Filter a table based on multiple dropdown

[lewisam.org.an]

Hi all,

I can’t tell if I’m being a moron, or if something is broken. Both options end up with me being a moron I guess!

I have a list of Engineers that have a variety of accreditations. I am trying to filter a table of Users based on the Accreditations a user has selected using the mutli dropdown plugin. But I can’t seem to get it to work?

Any help greatly appreciated

[cha_james]

yeah it’s because you’re trying to filter a list against a list. It would work in this way if it was a single-select dropdown but ofc that’s not what we’re going for here.

I actually don’t know what ‘accepted’ best practice is for this but I tend to apply a :filtered, then [when current users accreditations:intersect with multidropdown A’s value:first item is not empty] on the end, under the condition that the ‘accreditations’ multidropdown is not empty. Off the top of my head that’s an advanced filter though which I prefer to avoid.

Would be keen to hear what others do for this though as I’ve not had to filter a list against a list for a while…

[lewisam.org.an]

Thanks for your reply! I’ll give that option a go, see how I get one