Hey guys, I need help figuring out how to set a data source that relies on comparing two lists.
Here’s the scenario - I want to display Project Types to Users.
Project types have a list of user groups which are allowed to view it.
Users have a list of user groups that they are a part of.
So, I want to display the project types who’s list of User groups contains any of the current users list of user groups.
The problem is that the contains function i.e. “Project Types User Groups Contains”, wants a single item, not list.
Any idea how I say essentially “Project Types User Groups Contains ANY of Users User Groups”
Hi there, @ian11… if I understand your post correctly, I believe an advanced filter is your only option because of how you have structured your data types. So, something like this…
As you may or may not know, advanced filters happen on the client side, so the search is going to return all of the project types to the browser and then do the filtering there. If that doesn’t work for your app from a performance perspective, you would have to consider restructuring your data types in order to remove the dependency on an advanced filter.
