How to fetch table data and show in a a!dropDown control of interface.

Question

Created below table in appian DB 
 
 Create a CDT and a DataSet. Now I got struck while creating expression rule.

Can someone help here. 
 
 I want to bring id, Name from language table and show the data in a dropdownlist. 
 choiceLabel with "Name" column data 
 choiceValues with "id" column data.

Mike Schmitt · Answer

Per what the error message says: in a!localVariables you can't just define a local variable and then nothing else. You need some code to actually be executed after all local variable definitions are complete. If you want to test out what the value of the local variable will be, you can simply put your local variable in as the "code to execute" section of the a!localVariables() call, and the value will be displayed. 
 Also: there's really no need to cast() the query results to the specified type (though you can if you really want to). Usually it's not really worth the extra hassle, in my experience.

Richard Michaelis · Answer

you have an error message at the left side ;) the paginginfo is missing at your a!query function. -> won't work without

How to fetch table data and show in a a!dropDown control of interface.

Top Replies