Query design: Default Value List Filter Prompt to None

[Former Member]

I am building a query with several filter prompts which are of data type Value List

The problem is that the list defaults to the first value in the Value List, and I would like to default it to None. The reason of course is so users don't have to switch all the dropdowns to None manually.

I am wondering, what is the default value that can default the list to None? I have tried "0", "None", "null" all to no avail. My current hack is to add another value to the value list called "Any" and make it the first choice in the list.

[Former Member]

You can have None default in the VLV filter by putting in the default value of:

<Value List Internal Id>:616:null

The value list internal id is the numeric value found on the definition of the value list.

Hope this helps.

Rob

[Former Member]

Would suggest to try changing localized resource lable name of 'none' to the another value which is considered to be default value.

Good Luck

[Former Member]

Hi Kamalakar,

None is a system added value in Value List Value. I do not have option to remove or Edit it.

[Former Member]

Unfortunately I tried that and it didn't work.

The values of my filter prompt are as follows.

Parameter Name: AGREEMENT_TYPE

Prompt Message Resource: Agreement Type

Default Value: null:616:null

Data Type: Value List

String Matching:Exact Match

Value List Type: Agreement Type

Prefill value from cache:

Optional:

Hidden:

Locked:

[Former Member]

Hi,

I am also having the same issue. Did you got any solution for the same.

I treid "None" , "null:616:null" also null.

[martin_schffler]

You have to use null:616:null as the default value.