Good evening,
I have been building an app where users can find people to help them depending on goals they selected during their onboarding process.
Goals are an option set, and jobs too.
I have a list of jobs that match users goals. For example for goal n°1 matches job n°2 and job n°3.
In goals option set i have an attribute called MatchingJobs, where i put matching jobs for each goals. Same for jobs => goals.
Jobs is a list of jobs coming from the option set in the User table. During their onboarding, they can select several jobs.
What I am trying to achieve is when the users logs in, the list of matching people is displayed in a repeating groups.
The problem I have been facing is for displaying data. I have been trying to do a search for. But this returns only exact matches. If i select Goal n°1 (that should match job n°2 and job n°3) and i have a user that only has job n°2 in his profile, it is not returned.
I would like to know if there is a way to do partial match or to check in a query if jobs contains only some of the goals…
Is using a list:filteredBy a good solution ?
So far i have been checking every single item of the matching goals in the job field but it returns only exacts match. Plus, i only get 4 filtering options in the request as you can see on the picture below :
It looks like Do a search for is like AND condition and there is no way to have partial match.
Thank you
Have a nice evening