Prompt with default values required another click to list LOV values

[Former Member]

Hi,

I have created a prompt with default value but the LOV is not getting displayed with out a click in refresh button. I have tried to get it done using two different ways

1. Removing the default value and providing optional in @ prompt function, but it was not successful.

2. Creating a business filter using optional universe parameter in IDT which was successful in listing out the values but the issue facing is the ordering of parameter display.ie, I need to give filter name like 1. Program Type, 2. Title

Can any one suggest different soultion to get it done.

Thanks,

Sathish

[Former Member]

Hi Sathish,

Please set LOV settings as in the following Snapshot,

Ambreen

[Former Member]

Hi Ambreen,

I have provided these settings, but if am  i passing default value in @prompt function the LOV is not getting listed without a second click in refresh button.

Thanks

Sathish

[Former Member]

Hi Sathish,

Try with below sql code,

@Prompt('Please Enter Year','A','Time period\Year',Mono,)

                                                 OR

(@Prompt('Please Enter Year','C',{'2004',2005'},,))

On First refresh it will give you the list of values, on second refresh it is not giving you the list of values as it is keeping last value selected.

Ambreen