I have a few different indices, each of which have a different data type that they represent. Each of these data types are related.
Audit Trail Index.
Each with a single data type . (Issue, Tag, Audit Entry)
Each of these data types has a case_id field, and a number of other fields related to that data type.
I would like to have a Dashboard where I can do something like the below.
Filter on Tag by a field that only exists in the Tag index (Tagger for example).
Select All Case_ID by that filter.
Filter Issues by those case ids.
Is this possible? This would be similar to what in SQL would look like
SELECT * FROM issues WHERE case_id in (SELECT case_id FROM tags WHERE tagger = 'jon smith');