Function compareNumbers

server/charts/dataFilter.js:156–258

(data, field, condition)

}

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

  if (!condition.value && condition.value !== 0
    && (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;
    }

    if (typeof value === "number") return value;

    // now check if values should be converted to numbers
    if (/^\d+$/.test(value)) {
      return parseInt(value, 10);
    } else if (/^\d+\.\d+$/.test(value)) {
      return parseFloat(value);
    }

    return {
      value,
      isString: true,
    };
  };

  switch (condition.operator) {
    case "is":
      newData = _.filter(newData, (o) => {
        const val = getValue(o);
        if (val?.isString) return `${val.value}` === `${condition.value}`;
        return getValue(o) === parseFloat(condition.value);
      });
      break;
    case "isNot":
      newData = _.filter(newData, (o) => {
        const val = getValue(o);
        if (val?.isString) return `${val.value}` !== `${condition.value}`;
        return getValue(o) !== parseFloat(condition.value);
      });
      break;
    case "contains":
      newData = _.filter(newData, (o) => {
        const val = getValue(o);
        if (val?.isString) return getValue(o)?.indexOf(condition.value) > -1;
        return getValue(o) === parseFloat(condition.value);
      });
      break;
    case "notContains":