Prompt on empty dates

Cyrille Saulnier-Oracle

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):

Manu R-Oracle

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

Cyrille Saulnier-Oracle

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.

Manu R-Oracle

Hi,

Please try to add the filter way shown below:

Where (effective_date is null or effective_date = <Prompt_Value> )

Regards,

Manu

Bhaskar Konar

Hi @Cyrille Saulnier-Oracle ,

If you are using OTBI, you can try like following.

Hope this help.

Cheers,

Cyrille Saulnier-Oracle

Let me add a screen shot of where I am trying to get this to work:

1. The filter I am trying in the analysis
2. The list where you can see the empty value in DATE_MAJ_FINESS
3. The prompt filter result

Filter.png

List.png

Filter prompt.png