Get Free Trial

Sort Desc on a Column Value && Filtering out 0 values

David Chen asked on May 4, 2016

First Question: I have a column, color, it has values of red, blue, yellow, green. I want to sort the color column by descending.
Second Question: I have a two values, Price & Quantity it has a few 0 values, I want to filter out where Price = 0 or Quantity = 0
jsfiddle example would be nice thanks

4 answers

Iryna Kulchytska Iryna Kulchytska Flexmonster May 4, 2016

Hi David,
First Question: Here is a sample: Just add sortName: “desc to color column in the report object, as follows:

columns: [{uniqueName: "Color", sortName: "desc"}]

Please let me know if it is what you were asking about.
Second Question: There is no option to filter out zero values in the component.
Kind regards,

David Chen May 4, 2016

2nd question: is there a way to filter, where quantity greater 3 for example?

Dmytro Zvazhii Dmytro Zvazhii Flexmonster May 5, 2016

Hello David,
Thank you for your question.
Unfortunately, there is no feature in the component which allows to do that.
Best regards,

Tanya Gryshko Tanya Gryshko Flexmonster December 5, 2016

Hello David and all Flexmonster users,
After the release of version 2.3, we would like to inform you that sortName property was renamed to sort. Please check the updated sample:

Please login or Register to Submit Answer