Dropdown list - Values from query

[Former Member]

Hi,

I would like to create dropdown list to UI form... I run into error   " Could not expand values for attribute MX_FS_COMPANY_CODE_ID "

I have set up a SQL query for legal values to fetch the SAPcodes for Companies to MX_FS_COMPANY_CODE_ID attribute.

select SAPCODE from process_businessunits

Table resides in MCMC_RT users schema - I can run query successfully in SQL editor.

What I am missing here? - setting the static values work..

BR

Veli-Matti

[Former Member]

Solved !

Didn't allow ; in the end of query