Filter for empty date values

Questions and Answers Strapi Admin
1
System Information
  • Strapi Version: 3.6.1
  • Operating System:
  • Database: mySql
  • Node Version:
  • NPM Version:
  • Yarn Version:

Hello,

I was wondering if there is a way to use the build in filters to look for empty date values. For example:

image
image2309×410 32.7 KB

In this scenario I’d love to be able to search for where the “profile_completed_at” is “empty”.

I can order by empty, which kind of helps but with more data it will make it harder to see exactly where the cut off is.

Is this possible?

Thanks
Bradley

2

Depending on what data type profile_completed_at is you could always say is null or is "" which should be an empty string etc ? Not sure if that would work?

3

Thank you for your reply and suggestion. Unfortunately it’s not possible enter “” or “null” for this field (from the UI as it’s a datetime field. And even adjusting the URL manually causes the filter to render “is Invalid Date”.

After digging a bit more it looks like, from the stack trace, that the filter tries to convert the value to a datetime and cannot handle an empty date.

Unless I am missing something?