Loading Profile...
How do I report empty date fields?
I've created a report that shows a Closing Date prior to today - {date-filter:data:CloseDate|maxValue=0d|format=MMM d, yyyy|order=descending}
Now I want to create a report that shows Closing Dates today or later as well as items with blank closing dates. How do I report a blank (date) field and what is the best way to combine that with items that have a Closing date of today or later?
Now I want to create a report that shows Closing Dates today or later as well as items with blank closing dates. How do I report a blank (date) field and what is the best way to combine that with items that have a Closing date of today or later?
I’m frustratred
1
person has this question
I have this question, too!
Tell me when someone answers.
The more people who ask this question, the more it gets noticed.
The more people who ask this question, the more it gets noticed.
-
Inappropriate?Hmm. Testing for blanks isn't something I've had to do before and I'm not sure it's actually possible at the moment. Could you create a feature request and I'll schedule it for investigation in the next version.
The other question is how to create an 'or' filter. If you are only filtering by those dates, you can set 'matchAll' to false in the reporter. However, it there are other filters, you can (ab)use the {collection-filter} to get what you're after. Something like this:
{collection-filter:@self|matchFilters=any}
{a-filter:...}
{b-filter:...}
{collection-filter}
-
Inappropriate?Thanks David but I can't seem to get the collection-filter to work with Date-filters. I'm trying to show items with a Closing Date (CloseDate) of today or later as well as items that don't have a set Closing Date yet (this is why I asked about showing blanks). Instead, I've defaulted the Closing Date for Jan 1 2009.
The first date filter with a minValue of 0d works fine by itself to filter Closing Dates equal to today or later. I haven't gotten the maxValue to work despite trying many different permutations of minValue and MaxValue so that it finds Jan 1 2009 yet but the real problem is that neither filter works by itself or in combination within the collection filter.
{local-reporter:content:children|type=page}
{date-sort:content:modification date|order=descending}
{collection-filter:@self|matchFilters=any}
{date-filter:data:CloseDate|minValue=0d |format=MMM d, yyyy}
{date-filter:data:CloseDate|maxValue=-10m |format=MMM d, yyyy}
{local-reporter}
Thanks again for your help. Btw, this is a great plugin!
I’m stymied
-
Inappropriate?Try changing your second date-filter to "Jan 1, 2009" instead of "-10m". Also, you need a closing {collection-filter} tag to surround the date-filters. So, something like this:
{local-reporter:content:children}
{date-sort:content:modification date|order=descending}
{collection-filter:@self|matchFilters=any}
{date-filter:data:CloseDate|minValue=0d |format=MMM d, yyyy}
{date-filter:data:CloseDate|maxValue=Jan 1, 2009|format=MMM d, yyyy}
{collection-filter}
{local-reporter}
EMPLOYEE
