I am using jqxgrid in my application and currently facing one issue regarding sorting and filtering of column which has alphanumeric data.
The details are given below.
I have a column ‘Size’ in my Grid and displaying data like below.
and I am applying Sorting and Filtering on ‘Size’ column. I have taken data type as ‘number’. Initially I am taking binary data in ‘number’ and I am using ‘cellsrenderer: bytesRenderer’ method for rendering data like above i.e. 5.43 KB ( against binary data – 5693767.68).
Sorting is working fine but facing issue with filtering as it contains alphanumeric data. And it is considering numbers only and but not MB,KB,GB while filtering.
Hence, filtering is not working as per our requirement.
I request you to provide me any solution to solve this issue as i am unable to solve.