March 28, 2008, 04:49 PM
LaRevFilter on Missing Date
PMF Version 2.6
How do I create a filter in PMF on a date that is blank or
in SQL table?
Example- I want to create filter where "review date" is "" which means that a case is still open?
March 28, 2008, 10:39 PM
Bob Jude FerranteRemember you're talking about WebFOCUS. The WebFOCUS documentation has the information you seek.
MISSING is the keyword that searches for missing values. You can test for it.
WHERE [MY_DATE_FIELD] EQ MISSING would be the test. MY_DATE_FIELD is, of course, replaced by the real name of your date field; in the PMF Loader Filters tab, you use the dropdown to select the field of course.
Don't put quotes around MISSING.