Im new to elasticsearch and i really need some help to get a thing done.
Every user has it own unique ID, ex; 111112,111113,111114.
Every user is connected to a user type, Ex; AA, AB,AC,AD
And every user type has one or more colors, Ex; Blue, Red, Black.
What im trying to achieve is a list of those Uniqie IDs in User type AA that does not have the color red.
(List UniqueID=* UserType=AA Missing=Red)
Is this possible? I know some basic querys, but listing IDs that miss something was a bit hard me and my knowledge.
Its easy in SQL with "Except", but i cant find out how to do it in elasticsearch.