Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to create a report of records that have missing date?
#1
I need to create a report of assets and filter those on a custom date field. The filter criterium is that the field should be empty (it is not mandatory). We want to create a list of assets where that date is missing. But in reports, I can't filter on empty dates since an empty string is not a valid date format. I also tried a dash '-' and '00-00-0000', but without success. How can I filter reports on empty date fields?
Reply
#2
Have you tried a dollar sign?

http://corebos.org/documentation/doku.php?id=en:using_filters#blank_dates
Joe
TSolucio
Reply
#3
The code for that to work is there:

https://github.com/tsolucio/corebos/blob/master/modules/Reports/ReportRun.php#L723

but it doesn't get the results, while I have someone look into that you can use the other accepted format: --$

that string worked for me
Joe
TSolucio
Reply
#4
Thanks! I'll try that. Never occurred to me that this could be in the docs..
Reply
#5
Seems to have done the trick for me. Glad to see I only got 5 results. I included the column that I wanted to check in the report, all dates showed 00-00-0000 (which is SQL for no date if I'm not mistaken).
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)