How to compare a List of things value (Whole list) with another List of things value (Whole list) and return the matching ones as result. DB design is given below
1 Like
Intersects with …
Will compare two lists of the same type, and return the matches.
Have a look more closely at @NigelG’s screenshot, the “intersect” comes after the list reference (search or an element’s list), and should allow to reference another search or a list from elsewhere.
Example:
Search for Users : intersect with Search for Users
Intersect is with Student table, So Search User (User Assigned sports team) to be intersected with Sports table (Sports team member user)… This is not working, may be im missing something…??
Can you give a more detailed database description?
For example
table name, has
field name, field type, example data
field name, field type, example data
field name, field type, example data
Can you also describe what you are modelling, and what you are trying to show?
It would have been easier if the list fields were list of students, list of sports, instead of list of id texts …
Selected User’s Sports’ Team’s Users
Still doable though:
Search for Users
- Student ID <> Selected User’s Student ID
- Student ID is in Search for Sport’s Team
- - Sport ID is in Selected User’s Sports
1 Like
I changed my DB structure as per the above, Now Student table has one list field with SPORT type & Sports Table has User List also…
Solution found - Search for Users Linked Sport Team Intersect with Search for Sport Team Linked user
1 Like
This topic was automatically closed after 70 days. New replies are no longer allowed.