Skip to main content
A
alenaromi1-Visitor
1-Visitor
May 22, 2020
Solved

Filter Data and Remove repeated display of data in dropdown list.

  • May 22, 2020
  • 1 reply
  • 1883 views

Hi ,

So I have a list which I want to act as a filter such that based on my selection the grid displays on those data.For eg.I select company ABC ,only those rows of company ABC are displayed on the screen and when selection is removed it goes back to displaying the full list.

 

Now I have two Things that share the same company name ABC,and as it is a dropdown it show "ABC" twice in the list.As I have a filtering purpose the name being displayed once is more than enough,so is there a way I can make it display only once so as to reduce extra list rows and improve the UI.

 

Please refer image for better understanding,also I have bound the dropdown lists and the grid to a thing template which is the base for all the things.

 

Best answer by vinakumar

Hi ,

 

Data which you are binding to list widget  first needs to be filtered for getting the distinct records. You may write down One service to get the distinct records in similar way as shown below. Output of this service then can be bind to list widget.

 

var params = {
t: undefined /* INFOTABLE */,
columns: undefined /* STRING */
};

// result: INFOTABLE
var result = Resources["InfoTableFunctions"].Distinct(params);

1 reply

V
vinakumar12-AmethystAnswer
12-Amethyst
May 22, 2020

Hi ,

 

Data which you are binding to list widget  first needs to be filtered for getting the distinct records. You may write down One service to get the distinct records in similar way as shown below. Output of this service then can be bind to list widget.

 

var params = {
t: undefined /* INFOTABLE */,
columns: undefined /* STRING */
};

// result: INFOTABLE
var result = Resources["InfoTableFunctions"].Distinct(params);

A
alenaromi1-VisitorAuthor
1-Visitor
May 25, 2020

Hey!
I wrote a service like you said for each of my fields separately i.e (one for city name,one for state name etc) and it seems to be working fine.
Thanks a lot.

    Terms & ConditionsCookie settingsAccessibility statement