How to sort a filtered a list

F Faye shared this question 5 years ago
Answered

I have many rows in a data master. I would like to filter the rows based on some criteria, then sort based on one column, then display the result on the data grid on the UI. I got them to work separate. But when added together (set value with filter + set value with sort) action, the result is not filtered, and sorted only for the second half of the rows.

Comments (8)

photo
1

First you need to do the filter over the data master and put the result in the data grid. Below that interaction, you have to add the sorting but using the data grid this time.

photo
1

I am trying your suggestion, but I cannot find the right way to specify the column in the data grid that I need to put the sort on. I looked around, and see an example, where data grid Computer_Grid has a column of Price, and the sort syntax is sort (ascendant) (Computer_Grid, Price). I am able to specify the data grid use the calculator UI, but cannot seem to specify Price. I try to drag and drop the header cell and the program won't let me do it. I tried to type in the literal Price, and the program treated as a text. What am I doing wrong?

photo
1

This tutorial explains how to use the Sort function http://www.justinmind.com/usernote/te...


It might be of some help.

photo
1

Victor,


Thanks. I understand the logic of it. My problem is the mechanics of working with the UI. In trying to build the sort function, I am able to drag the data grid into the data grid box in the sort function, and I can not figure out how to drag the attribute to the second box. Using the example you provided on the link, I cannot figure out how to mechanically specify the "Name" column in the attribute box.


I tried the following:


> I tried to highlight the column header cell of the column I need sort, but the system does not give the little hand icon to drag it.


> I tried to type the label in the column header, but it is interpreted by the system as a string,


> I tried to drag the first row of a column to the function box, but I cannot.


...


I hope you can picture my struggle here. Can you please just explain this? Many thanks.

photo
1

You need to select the Data master tab, then expand the data master you want and drag the data master attribute to the box.

photo
1

But in your first response you said "you have to add the sorting but using the data grid this time." I am trying to sort on filtered results, not a simple sort of data master data.

photo
1

I think someone answered quite well in coursera's discussion forum.

photo
1

Hi -- I have the same issue here... trying to sort filtered results. I can Filter the data.. I can Sort the data.. but I can't figure out how to do one then the other. I do not feel a proper solution was given here. Has any additional information been found solve this question?