1. Home
  2. Forum
  3. jQuery
  4. Grid Filter: Sort Results in Filter Widget

Grid Filter: Sort Results in Filter Widget

Hi,

I am using syncfusion Javascript control JS1. 

Under the grid settings I have the filter type set to excel. 

filterSettings : {

filterType : "excel"

},


Is there way to sort the filter values displayed when when selected. For example, assume a column contains values, 1, 2, 11. When selecting the filter option, the filter options displayed are 1, 11, 2. How do I change it to default to ascending order i.e 1, 2, 11?






Attachment: filter_36c57fc3.7z

3 Replies
PS Pon Selva Jeganathan Syncfusion Team January 28, 2022 01:08 PM UTC

Hi Seenivasan,   
 
Thanks for contacting syncfusion forum. 
 
Query: Is there way to sort the filter values displayed when selected. How do I change it to default to ascending order i.e 1, 2, 11? 
 
We were unable to reproduce the issue(Is there way to sort the filter option values displayed when selected) at our end while preparing a sample based on your query. 
 
Please refer to the below screenshot, 
 
 
 
Please refer to the below sample, 

https://jsplayground.syncfusion.com/g3icymso

After following the above reference, still faced issue please share us the following details.

  1. Share the complete grid code example
  2. Share video demo or screenshot of the issue
  3. If possible, reproduce the issue in the attached sample or share the issue reproducible sample.
  4. Share the product detail version.
 
The provided information will be helpful to provide you response as early as possible.   
     
Regards,   
Pon selva   


JA Jhon Albert February 3, 2022 12:18 PM UTC

The Data Grid widget is empty when added to a dashboard and must be configured to show report results. The editor for this widget allows the user to select a report, and then use the columns from the report to configure the widget appearance. The columns that are displayed and their order are controlled by the widget properties.


PS Pon Selva Jeganathan Syncfusion Team February 4, 2022 03:13 PM UTC

Hi Seenivasan,   
 
Thanks for the update. 
 
Before we start proceeding with your query, we request you to share with us the details below to provide you with the solution as early as possible.  
 
  1. Share the detailed explanation of your requirements.
  2. Share the video demo/Screenshot of the requirement.
  3. Share the complete code example of your requirement
  4. If possible, kindly share the simple sample of your issue
  5. Share the product detail version.
  
Kindly get back to us for further assistance. 
     
Regards,   
Pon selva   


Loader.
Up arrow icon