Ken Krugler
01/08/2021, 1:24 AMwhere mvfield in ('a', 'b') group by mvfield
, and mvfield
is a multi-valued field, I get a result with groups for values from mvfield
that aren’t in my where clause. I assume I’m getting groups for every value found in mvfield
from rows where mvfield
contains a match for my filter, but it seems wrong…am I missing something?Mayank
value_in
udf. Let me find an exampleKen Krugler
01/08/2021, 1:33 AMselect VALUEIN(mvfield, 'a', 'b') as groups from table group by groups
Mayank
Ken Krugler
01/08/2021, 1:34 AMMayank
Ken Krugler
01/08/2021, 1:36 AMMayank