Oracle Transactional Business Intelligence
Prompt on empty dates
We need to have a prompt where you can not only filter on a date range but also on the empty date fields
We want to filter in the prompt on empty date fields. Any idea how to do it without creating a new field?
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Can you elaborate what do you mean by 'filter in the prompt on empty date fields'.
Should the filter apply for all date or no date when NULL.?
Hi, at the moment, when the dates are empty, the filter apply for all date (expected behaviour).
I am looking for a way to show the records where the date field is NULL.
Hope this makes more sense.
Please try to add the filter way shown below:
Where (effective_date is null or effective_date = <Prompt_Value> )
If you are using OTBI, you can try like following.
Hope this help.
Let me add a screen shot of where I am trying to get this to work:
- The filter I am trying in the analysis
- The list where you can see the empty value in DATE_MAJ_FINESS
- The prompt filter result