Cannot query fields by NULL

[joelalejandro]

The current implementation of filtersToKnex apparently converts null to 0, which isn't accurate. This prevents to lookup records by absent values.

    Object.keys(filters).forEach(key => {
      let value = filters[key];
      const operator = getOperator(filters[key]) || "=";

      if (value.substring(value.indexOf(":") + 1)) {
        value = value.substring(value.indexOf(":") + 1);
      }

      value = value !== "null" ? value : 0;

      processedFilters.push({
        value,
        operator,
        column: camelize(key)
      });