Skip to main content
V
Vimal_Rawat14-Alexandrite
14-Alexandrite
September 27, 2022
Solved

Multilevel drill down using drop downs.

  • September 27, 2022
  • 1 reply
  • 1460 views

We have a scenario where we have multiple drop-downs. All the drop-downs are connected with each other in a multi-level hierarchy. All the drop downs are associated with the same Datatable with different fields.

 

For example: we have a Datatable  named DT with 4 fields FD1,FD2,FD3, and FD4. The dropdowns viz DD1, DD2,DD3, and DD4 are binded to the corresponding fields of DT; DD1 binded to FD1, DD2 binded to FD2, and so on..

So when we select a value in DD1 from the list of selections, it should filter the values in DD2 based on Selection of value in DD1. Then data on DD3 should be filtered based on selection in DD2, then data on DD4 should be filtered based on selection made in DD3.

 

is there any way to achieve this in a mashup.

Best answer by Sathishkumar_C
  • Create a 4 different services for each drop-down widget
  • Based on each service's "SelectedRowChanged" event execute the subsequent service with "SelectedValue" as service input

 

Note: We can optimize this further, this is simplest I believe.

1 reply

S
17-Peridot
Sathishkumar_C17-PeridotAnswer
17-Peridot
September 28, 2022
  • Create a 4 different services for each drop-down widget
  • Based on each service's "SelectedRowChanged" event execute the subsequent service with "SelectedValue" as service input

 

Note: We can optimize this further, this is simplest I believe.

    V
    Vimal_Rawat14-AlexandriteAuthor
    14-Alexandrite
    September 29, 2022

    Hi,

    Thanks for your reply.

    As per your comment, I created 4 services inside a helper thing.

    Based on each service 'SelectedRowChanged' event I execute subsequent service with 'selectedvalue' as service input. But I don't get any option to bind the output of the triggered service to the subsequent dropdown(DD2). how the binding is going to be in this case? Please suggest.

    S
    17-Peridot
    Sathishkumar_C17-Peridot
    17-Peridot
    September 30, 2022

    Checkout following articles,

      Terms & ConditionsCookie settingsAccessibility statement