Wildmatch in Select in Field Trigger

[riyazasma1009]

Hi,

I have a field 'Test' which contains values such as below:

Test

Test is- A

abcd

Test is - B

Test is- C

Test is- D

No Test

Test is- E

Test is- F

Test is- G

Test is- H

Test is- I

dfghk

fghhjuy

uioyy

hjkjh

iuyt

asdf

On the dashboard, I always want that the values starting with Test is -* should be selected.

Can someone please help me on this.

Thanks,

Asma

[sunny_talwar · Accepted solution]

May be try Select in field action like this

Field

Test

Search String

='("' & Concat(DISTINCT {<Test = {'Test is -*'}>} Test, '"|"') & '")'

or

='("' & Concat(DISTINCT {<Test = {'Test is*'}>} Test, '"|"') & '")'

[riyazasma1009]

Hi Sunny,

Thanks for the quick reply. Adding the above expression in the search string for Select in Field Trigger works fine. But the values which do not fall under this criteria are not shown in the list box. I want that the non matching values should be greyed out.

[sunny_talwar]

Are you using a calculated expression for your list box? If you are, then what is the expression?

[riyazasma1009]

No, it is just a simple list box containing the field Test

[sunny_talwar]

I don't see any problem....

[riyazasma1009]

Thanks Sunny for the reply! The expression is working as expected. There was something wrong at my end