Flexgrid column sort on Japanese character

Flexgrid column sort on Japanese character

Posted by: nguyen on 5 May 2022, 6:54 pm EST

• 

  nguyen

  • Post Options:
  • Link
    Copy

  Posted 5 May 2022, 6:54 pm EST

  I have worked on FlexGrid,
  
  when perform sort on a column in Japanese, sort ordered data not same with Sql query result in datatable.
  
  Is sort default suppored for japanese character?

  For example in fiddle bellow click on Country column.
  
  http://jsfiddle.net/kzgypbta/
  
  Thanks!

• 

  dushyant.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 8 May 2022, 11:06 pm EST

  Hello,

  We could not detect any difference in the behavior of sorting in FlexGrid and using SQL order by command.

  We have used the following SQL query to sort the country name:

  
  -- create a table
  CREATE TABLE countries(
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL
  );
  -- insert some values
  INSERT INTO countries VALUES (3,'鹿児島県');
  INSERT INTO countries VALUES (1, '三重県');
  INSERT INTO countries VALUES (2,'京東府');
  
  -- fetch sorted values
  SELECT * FROM countries order by name ;
  
  

  Could you please provide us with the information on the sorting behavior which is returned at your end using SQL, so that we compare the results and reply accordingly?

  Regards
  
  Dushyant Sharma

• 

  nguyen

  • Post Options:
  • Link
    Copy

  Posted 9 May 2022, 11:19 am EST - Updated 3 October 2022, 3:01 am EST

  Dear Dushyant Sharma,
  
  Thanks for your answer, for your information i left the evident image below.

  By another way, i have resolved my own issue by disable client sort by custom sortComparer like:
  
  $scope.flexgridData = new wijmo.collections.CollectionView(responseData,{
  
  sortComparer : function alphanum(a, b) {
  
  return 0;
  
  }
  
  }
  
  );

  

  1253×422 31.5 KB

• 

  dushyant.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 9 May 2022, 10:57 pm EST

  Hello,

  We are glad to know that your issue is resolved. However, if you wish to disable sorting behavior in complete FlexGrid you can use the allowSorting property and set it to “None” or if you wish to prevent the same in any given column, you can set the alowSorting property in the given flexgrid column to false.

  For more information on the same, please refer to the below link
  
  https://www.grapecity.com/wijmo/api/classes/wijmo_grid.flexgrid.html#allowsorting
  
  https://www.grapecity.com/wijmo/api/classes/wijmo_grid.column.html#allowsorting

  Regards
  
  Dushyant Sharma