Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
10 replies
Subscribers
7 subscribers
Views
5242 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Populate values in drop downs based on previous user selections
komalc3
A Score Level 1
over 7 years ago
Hi
I am working on version 16.2.
I have the below requirement to be fulfilled.
1st user selects a country from a drop down (whose values are being populated from a constant).
Now based on user's country selection, a list of regions should be fetched from backend and this should be displayed in a new drop down called "Regions" under the "Country" drop down.
Next when user selects a region, then based on the combination of country and region selected in above drop downs, a list of products should be fetched from the backend and this should be displayed in a new drop down called "Products".
Here I am desriing only 3 drop downs, actually there are more than 10 such drop downs, wherein based on selection of one or more drop downs the values in the next drop down is populated.
The traditional way is using expresssion or query rules but it will adve...
OriginalPostID-235725
Discussion posts and replies are publicly visible
Parents
0
Rama Thummala
Certified Lead Developer
over 7 years ago
@komalc - As considering the performance, we can have the all the datasets required for the dropdowns during initial loading by keeping in local variables and based on the each dropdown selection we can take the subset of data from the datasets (local variables). i.e.no need to have do call for each interaction.Here one time data fetching from database.
Alternatively we can have database call for each selection to get the particular set of data based on selected value.Here for each interaction it will take some time to fetch the data from database.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Rama Thummala
Certified Lead Developer
over 7 years ago
@komalc - As considering the performance, we can have the all the datasets required for the dropdowns during initial loading by keeping in local variables and based on the each dropdown selection we can take the subset of data from the datasets (local variables). i.e.no need to have do call for each interaction.Here one time data fetching from database.
Alternatively we can have database call for each selection to get the particular set of data based on selected value.Here for each interaction it will take some time to fetch the data from database.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data