V9: Creating drop down lists with options from multiple sources?

Paul_York

Hi All,

 

When assigning list options to a drop down we used to be able to create lists using a combination of static options and data selected from a database using code similar to:

 

 

BLANK FORM%CHR(9)%EMPTY()
%SelectSQL("SELECT eStageName FROM eStage WHERE eMapName = '%ProcessName'")

 

This would append the "Blank Form" option to the available stages.

 

Is this still possible as it not  immediately clear?

 

Thanks,

 

Paul.

 

Neil_Hudspeth

Paul,

 

Try this in the List Options property

 

"Other"

where you have selected "From an expression which returns a list of values"

, SelectSql(new MetastormDefault(),"SELECT DISTINCT(Listname) FROM CTSListOptions")