Open clearnz opened 8 years ago
Adon said the current operators map directly to the Mongo query operators so if IN was to be used there would need to be some sort of manipulation of the query string. Danny suggested another approach - to allow users to use AND or OR but not both in the same sequence of filters.
Mark suggested that if multiple filters/conditions are applied to a data set, the use of AND and OR may confuse users as it won't be obvious which operator takes precedence. Mark's experience in his last job showed that users more readily understood the use of AND and IN.
Suggest dropping OR in favour of IN.