IB - Developer Center    Forums  Hop To Forum Categories  Performance Management Framework (PMF)    Filter on Missing Date
Go
New
Search
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Member
Posted
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?
 
Posts: 16 | Registered: November 15, 2005Reply With QuoteEdit or Delete MessageReport This Post
Platinum Member
Posted Hide Post
Remember 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.


Bob Jude Ferrante
Technical Director
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105
 
Posts: 228 | Registered: March 26, 2003Reply With QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 

IB - Developer Center    Forums  Hop To Forum Categories  Performance Management Framework (PMF)    Filter on Missing Date

Copyright © 1996-2008 Information Builders, leaders in enterprise business intelligence.