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

Hi Sanjana,

1. Create a query entity to fetch required data from entity which you have used in constant DDG_Dynamic_ContractType . Refer the below links
docs.appian.com/.../fnc_system_a_queryentity.html
docs.appian.com/.../Query_Recipes.html

2. Use load function in interface and map the required columns in local variable.

3. Use local variable in Choice Labels and Choice Values of the drop down field
docs.appian.com/.../recipe_configure_a_dropdown_field_to_save_a_cdt.html

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

Thanks this worked for me.

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