Add In Operator for text type

[anushapalivela]

Add In Operator for text type.

Is there any solution. Now i see it is only for field type select with predefined field values

[ukrbublik]

Added new issue for this so you can track the progress: #751

[DrFaelSan]

const operators: Operators = {
...InitialConfig.operators,
text_in:{
label: "Contido",
labelForFormat: "IN",
sqlOp: "IN",
formatOp: (field ,values, value, valueSrc) => {
if (valueSrc === "value")
return ${field} IN (${values.toString().split(",").join(", ")});
else
return ${field} IN (${values});
},
sqlFormatOp: (field, op, values, valueSrc, valueType, opDef, operatorOptions, fieldDef) => {
if (valueSrc === "value") {
return ${field} IN (${values.toString().split(",").join("', '")});
} else
return "";
},
spelOp: "$contains", // tip: $ means first arg is object
reversedOp: "not_in",
jsonLogic: "in",
elasticSearchQueryType: "term",
},
text_not_in:{
label: "Não Contido",
labelForFormat: "NOT IN",
sqlOp: "NOT IN",
formatOp: (field, op, values, valueSrc, valueType, opDef, operatorOptions, fieldDef) => {
if (valueSrc === "value")
return ${field} NOT IN (${values.toString().split(",").join(", ")});
else
return ${field} NOT IN (${values});
},
sqlFormatOp: (field, op, values, valueSrc, valueType, opDef, operatorOptions, fieldDef) => {
if (valueSrc === "value") {
return ${field} NOT IN (${values.toString().split(",").join("', '")});
} else
return "";
},
spelOp: "$contains", // tip: $ means first arg is object
reversedOp: "not_in",
jsonLogic: "in",
elasticSearchQueryType: "term",
}
};