To get values in Drop down list Dynamically through Data Store Entity

Question

I want drop down list to fill with stored in data store entity values. Made a constant with DDG_Dynamic_ContractType--> In this Type selected Data store entity. Still not getting values. 
 Please guide us.

sahilb346 · Accepted Answer

Hello Sanjana, 
 
You have to use the local variables for queryentity to get the data and use that local values with required column you want to show in "choiceLabels" and "choiceValues" . 
the example of code is below:- 
load( 
 local!select, 
 local!pagingInfo: a!pagingInfo( 
 startIndex: 1, 
 batchSize: - 1 
 
 ), 
 local!datasubset: a!queryEntity( 
 entity: cons!EntityConstant 
 query: a!query( 
 selection: a!querySelection( 
 columns: { 
 a!queryColumn(field: "AAA" ), 
 a!queryColumn(field: "BBB"), 
 a!queryColumn(field: "CCC"), 
 a!queryColumn(field: "DDD" ), 
 a!queryColumn( field: "EEE") 
 } 
 ),

pagingInfo: local!pagingInfo 
 ) 
 ), 
with(

{ 
a!dropdownField( 
 label: "sahil", 
 choiceLabels: local!datasubset.data.BBB, 
 choiceValues:local!datasubset.data.BBB, 
 value: local!select, 
 saveInto: local!select, 
 placeholderLabel: "select" 
 ) 
 
 } 
) 
) 
 
Thanks 
Sahil

Neha Dangi · Answer

Hi, 
 
Following steps can be done 
1) define your layout withing load function 
2)fetch all the values form the constant DDG_Dynamic_ContractTyp and store the value in to on local variable. this local variable should be define within the load function. 
3) Now call this local variable as choice value and choice label 
 
i hope this will help you 
 
Regards, 
Neha Dangi