List Of Value in Custom Prompt?

[Former Member]

  Hi All,

I am using  custom prompt below in derived table in universe. 

DTL.PAYDATE <= @prompt('Paid Through Date:','D',,Mono,free,Not_Persistent)

the object DTL.PAy DATE  have a default list of value.   so how can i show default list of value in this prompt.

i tried adding it like this but its not working

DTL.PAYDATE <= @prompt('Paid Through Date:','D','DTL\PAYDATE',Mono,free,Not_Persistent)

any suggestion?

Thank You

[Former Member]

Hi Malik,

What is the error?

The sequence and format of the @prompt() seems correct. Please check the following:

- Make sure that DTL\PAYDATE is the correct Class_Name\Object_Name

- DTL\PAYDATE is a Date-type object and its format is as expected by DTL.PAYDATE field

- In case, you are conveting the date format or using function like Trunc() then the @prompt needs to be  wrapped inside to_date()

Here is a sample working @Prompt() based on Oracle database:

Here is the object definition:

Thanks,

Prathamesh