How to configure dropdown widget in the given table

[Rayon_11]

Hi everyone,

My question is suppose we have an Infotable like the below one.

Now what I want is filter these data based on Gender and School 

Requirement:

Like we have two dropdown in the mashup UI  one for Gender and another for School now if user Select any of the dropdown data should be filtered in the grid according to selection in the dropdown

please let me know how can I configure it in Thingworx 8.5 version

If Possible please share the exact solution 

please share binding as well

Best Regards,

Rayon.

[Rocko · Accepted solution]

You have a service that populates the grid with its result.

This service will need two additional inputs, for gender and for school. In the service you implement the filtering to get the proper data.

The two dropdown fields will have their selected value bound to the input of the service. The selectionChanged event of both widget are bound to the service execution.

This way, everytime a value is selected in the dropdowns, the service is executed with the current values of gender and school for filtering, return the result to be displayed on the grid.

[Yedukrishnan]

Hi @Rayon_11 ,

This should be handled in both Mashup and Service end.

Service end - Two inputs to be created and query the list based on the inputs from dropdown. By default you could keep "All" to get full list. 

Mashup end - Map the selectedRows from both the dropdowns as the two inputs to the service. And, run the service at selectedRowsChanged event of both the dropdowns. 

With regards

Yedukrishnan