How to implement IsNull and IsNotNull in filter?

[ixxvivxxi]

I would like to filter mainly columns something like this:

filter: {
  startDate: {
    isNull: true
  },
  endDate: {
    isNotNull: true
  }
}

Perhaps there is a way to add your own filters, but I haven’t figured out how

[klerick]

@ixxvivxxi
try to use filter operator eq and ne
example:
http://localhost:3000/api/users?filter%5BfirstName%5D[eq]=null&filter%5Blogin%5D[ne]=null
is equal of sql query:

SELECT * FROM "users" "Users" WHERE "Users"."login" <> null AND "Users"."first_name" = null

so you filter should be:

 filter: {
  startDate: {
    eq: true
  },
  endDate: {
    no: true
  }
}

[ixxvivxxi]

@klerick Thank you for your response! But your example doesn't work, there is a message - String should be as date
{code: "custom", message: "String should be as date", path: ["filter", "target", "startDate", "eq"]}
{code: "custom", message: "String should be as date", path: ["filter", "target", "endDate", "ne"]}

[klerick]

@ixxvivxxi
Oooops)
this is bug of validation)
I will try fixed it ASAP

[klerick]

@ixxvivxxi
try to use version json-api-nestjs@7.0.1

[ixxvivxxi]

Thank you! The issue was fixed