Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

I would like to apply a filter to match ONLY blank dates

Resolved
Charles Felish asked on September 30, 2020

Hello,
We have been searching for a way to match ONLY blank date fields. We have a report that has a date column with some values and some blanks. We have not found any combination of “filter: { query : { } }” options that produces a result that excludes dates and includes blanks.
Any help is greatly appreciated. Thank you!

1 answer

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster October 7, 2020

Hello, Charles,
 
Thank you for contacting us.
 
We want to explain that all invalid and blank dates are grouped under the “Invalid Date” member.
Therefore, the following filter can be used to filter out all members but blank and invalid dates:

"filter": {
  "members": [
    "delivered date time.[invalid date]"
  ]
}

 
Please see an example we have prepared to illustrate the described approach.
 
Our team hopes it works for you.
 
Kind regards,
Illia

Please login or Register to Submit Answer