Function compareStrings

server/charts/dataFilter.js:260–335

(data, field, condition)

}

function compareStrings(data, field, condition) {
  let newData = data;

  if (!condition.value
    && (condition.operator !== "isNull" && condition.operator !== "isNotNull")) {
    return data;
  }

  // extract value
  const getValue = (obj) => {
    const selectors = field.split(".");
    let value = obj;
    for (let i = 0; i < selectors.length; i++) {
      value = value?.[selectors?.[i]];
    }

    if (!value && (value !== 0 || value !== "0")) {
      return null;
    }

    return value;
  };

  switch (condition.operator) {
    case "is":
      newData = _.filter(newData, (o) => getValue(o) === condition.value);
      break;
    case "isNot":
      newData = _.filter(newData, (o) => getValue(o) !== condition.value);
      break;
    case "contains":
      newData = _.filter(newData, (o) => getValue(o)?.indexOf(condition.value) > -1);
      break;
    case "notContains":
      newData = _.filter(newData, (o) => getValue(o)?.indexOf(condition.value) === -1);
      break;
    case "greaterThan":
      newData = _.filter(newData, (o) => getValue(o) > condition.value);
      break;
    case "greaterOrEqual":
      newData = _.filter(newData, (o) => getValue(o) >= condition.value);
      break;
    case "lessThan":
      newData = _.filter(newData, (o) => getValue(o) < condition.value);
      break;
    case "lessOrEqual":
      newData = _.filter(newData, (o) => getValue(o) <= condition.value);
      break;
    case "isNotNull":
      newData = _.filter(newData, (o) => {
        const val = getValue(o);
        // Handle string "true"/"false" values for isNotNull
        if (typeof condition.value === "string") {
          if (condition.value.toLowerCase() === "true") return val !== null;
          if (condition.value.toLowerCase() === "false") return val === null;
        }
        return val !== null;
      });