Prompt on empty dates
Summary:
We need to have a prompt where you can not only filter on a date range but also on the empty date fields
Content (required):
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):
Answers
-
Hi Cyrille,
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.?
Regards,
Manu
0 -
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.
0 -
Hi,
Please try to add the filter way shown below:
Where (effective_date is null or effective_date = <Prompt_Value> )
Regards,
Manu
0 -
If you are using OTBI, you can try like following.
Hope this help.
Cheers,
0 -
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
0
