Hi.
I am having difficulty in creating a selector query.
I have three types of pages: pathologies, diagnostics, and diagnostic categories.
Diagnostics are related to pathologies and categories by page field.
Pathologies:
id: 1 | title: one
id: 2 | title: two
id: 3 | title: three
Diagnostic Categories
id: 10 | title: cattle
id: 11 | title: pigs
id: 12 | title: poulty
Diagnostics:
id: 45 | title: one | pathologies: 1,3 | diagnostic_category: 10,
id: 46 | title: two | pathologies: 2,3 | diagnostic_category: 10, 11
id: 47 | title: three | pathologies: 1,2,3 | diagnostic_category: 10, 12
id: 48 | title: four | pathologies: 1,2 | diagnostic_category: 10
I need to list pathologies that related to specific category.
Example:
For pigs (id:11) category it will be pathologies with ids 2, 3.
For poulty (id:12) category pathologies with ids 1, 2, 3.
Is it possible to do with selectors?
Any help would be appreciated