Skip to Content
0
Former Member
Jul 31, 2008 at 10:00 PM

How to add a default value in a prompt list?

22 Views

I have a prompt list that I'm getting from the database, I want to add a deafult value in the top of the list. Ei "ALL", my current list is:

"AMERICAS"

"EMEA"

"ASIA"

I want a list like:

"ALL"

"AMERICAS"

"EMEA"

"ASIA"

This is the code I have:

@Select(Country Region\Regionname)IN @Prompt('Enter the region','A',{'All'}distinct 'Country Region\Regionname',Multi,Constrained)

It is displaying only "All". Does someone know how to merge text with a database list in a promp variable?

Thank you!

Marcela