Menu
Download Free Trial

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

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

Public
Iryna Kulchytska Flexmonster May 4, 2016

Hi David,
 
First Question: Here is a sample: https://jsfiddle.net/irynakulchytska/344nu248/. 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,
Iryna

Public
David Chen May 4, 2016

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

Public
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,
Dmytro.

Public
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: https://jsfiddle.net/flexmonster/Lj7xL98e/
Regards,
Tanya

Please login or Register to Submit Answer