I have a requirement to group multiple properties and display them as dropdown values.
For ex: we have a table which holds Continent, Country, States information, and the requirement is to display in a dropdown values grouped by Continent -> Country -> State.
OOTB dropdown control provides an option to "Group by" results based on single property (as per my understanding) which will not be of help here as the requirement needs two level of Group By to be performed i.e., on Continent & Country.
Can you please suggest any other options to achieve "Group by" using multiple property values?
Is your requirement to show them in a single dropdown or multiple dropdown for Country, State and City. If multiple drop down , then I don't see a problem as based on the selection of one you may populate the next one using parameter. But if it is on the same drop down, you might use the below approach. But I am a little confused about the requirement itself. Please validate and let me know if my understanding is correct.
- Load the drop down from a Data Page.
-The source of the data page should be an activity.
- The above activity may call a connect-sql to get the data from the table using