My app is for property management. We allow users to create tasks for properties. Within the tasks page I’m providing a list of contractors/tradespeople. I want to filter that list so it only includes a list suitable to the task type set on the current pages task.
contractors exist as an organisation with type = contractor and another field for a list of contractor types based on an option set.
tasks are a thing with a field for type (single selection only) based on a foreign key to task types (so the user can set their own types and configure which contractor types would be most suitable for those task types. Which means task types also has a link to the contractor type option set.
When on the task page, I search for organisations where type = contractor, which works fine. But I can’t figure out the logic to filter for contractor types that match those in the current pages task, task types contractor types.
I’ve been trying the attached screenshot, but it seems to be indicating my result should return a single item, not a list. I’ve also included a screenshot of my organisation model to demonstrate that the contractor type is a list.
