Greater than based on value from another field

[Dave_Clissold]

That is an idea, simple enough to build a simple string or array with an order and then just additionally match that at query time.

Do you think something similar to this would be efficient?

Matching by array elements

There isn't an efficient way to do this but I can think of two OK ways to do it and I'm not sure which one is best: Index the documents with the string array just like that and search using a bool query (bool filter in 1.x) with each term in the OR clause, probably wrapped in a constant_score query. Then you use a script to recheck all the found documents for your restriction. Index the documents with an extra field that smooshes together the string array. So it'd be {"stringArray": ["A",…

Where I use the principal of the 'smooshed_arrays' to create com1_com2. the reality of my searches are likely to be 2 or 3 objects to work with, so can easily build these on the way in for example, A_B and A_B_C / A_C_B (when 3 items to query)