C1DataGrid- Advandced Filter behavior

C1DataGrid- Advandced Filter behavior

Posted by: sebastian-jn.k on 25 March 2024, 1:25 am EST

• 

  sebastian-jn.k

  • Post Options:
  • Link
    Copy

  Posted 25 March 2024, 1:25 am EST - Updated 25 March 2024, 1:34 am EST

  hello,

  Szenario:
  
  C1DataGrid.
  
  Advandced Filter behavior activated.
  
  Testdata property ‘SomethingID’ has null values possible.
  
  Testdata property ‘SomethingID’ is DataGridComboboxColum.

  Step I:
  
  -Start sample project attatched
  
  -4 rows visible → OK
  
  

  

  786×442 10.8 KB

  Step II:
  
  -open Filter column ‘Something’
  
  -uncheck ‘B’ and ‘C’
  
  -‘select all’ automatically switches state to ‘undefiend’
  
  -1 row visible (Jerome) → OK
  
  -Picture Example ‘StepII.png’
  
  

  

  790×449 9.19 KB

  Step III:
  
  -open Filter column ‘Something’
  
  -check ‘B’ and ‘C’
  
  -‘select all’ automatically switches state to ‘check’
  
  -2 rows visible (Jerome and John) → Not OK
  
  

  

  786×443 10.2 KB

  The problem is that the user see all checkbox checked
  
  like the picture ‘StepI.png’ but see a different result and may missed relevant informations.
  
  How do we solve this issue?

  Greetings from germany.
  
  Sample Project
  
  C1WpfDatagridFilterCbx.zip

• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 26 March 2024, 12:19 pm EST - Updated 26 March 2024, 12:24 pm EST

  Hi Sebastian,

  Thanks for providing the sample application.

  Initially the DataGrid displays all the four rows because no filter condition is applied on the “Something” column. [Step I]

  When you check for “A” Contains condition and apply the filter [Step II], the row(s) containing “Something” as “A” will get filtered and be displayed. The column header will display the funnel icon to show that the filter has been applied on the column.

  Again, opening the filter dialog and checking all the values will filter the rows that contains either ‘A’, ‘B’ or ‘C’. Since only 1st and 3rd row satisfies the condition, they will get filtered out. [Step III]

  If you clear the filter by clicking the “Clear” button in the filter dialog box, all rows will be displayed as expected.

  Refer the following GIF to see the behavior.

  

  However, we are currently investigating the filtering behavior for conditions other than “Contains” which does not seem to work as expected in your use-case. We will update you soon on this.

  Meanwhile, we kindly request you explain your issue in a bit more detail, if our understanding differs from what you were trying to convey.

  Thanks & Regards,
  
  Aastha

• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 27 March 2024, 1:14 am EST - Updated 27 March 2024, 1:19 am EST

  Hi Sebastian,

  We hope that the information provided earlier seems logical to you. The filtering behavior by filter dialog is as expected.

  Please note that C1DataGrid is an old version control and out of support now. This control is not under development. We request you consider migrating to the flexgrid control in order to get the latest updates and features.

  Documentation Link: https://developer.mescius.com/componentone/docs/wpf/online-flexgrid/overview.html

  JFYI, C1FlexGrid offers (null) as an option for filtering nullable columns. Refer the following image of flexgrid control.
  
  

  You can anytime raise a query if you face any problem during migration.

  Thanks & Regards,
  
  Aastha

• 

  sebastian-jn.k

  • Post Options:
  • Link
    Copy

  Posted 27 March 2024, 11:32 pm EST - Updated 27 March 2024, 11:37 pm EST

  thanks for the answer but it seems that the problem is not clear, so i will to explain.
  
  

  

  1734×482 29.5 KB

  
  
  As you can see in the image, the filter settings are exactly the same, but lead to unexpected results. But I and customers expect the same result.

  If you just select the ‘select all’ filter everything is ok.

  If ‘A’, ‘B’ and ‘C’ are selected individually, which automatically selects the ‘select all’ filter, the zero values ​​are missing, that is not ok.

  So in one case zero values ​​are displayed and in the other not. The view of the filters is the same in both cases. Is there any way to fix this without migrating? Unfortunately no time to migrate.

• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 1 April 2024, 12:18 pm EST

  Hi Sebastian,

  Thanks for the detailed explanation of the issue.

  We could replicate the behavior on our end. We are currently in discussion with the developers regarding this issue. [Internal Tracking ID: C1XAML-35883]

  We will update you on this as soon as we hear back from them.

  Thanks & Regards,
  
  Aastha

• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 1 April 2024, 7:52 pm EST

  Hi Sebastian,

  There are two approaches to proceed further with this issue:

  1. If you want consistent behavior when “Select All” is checked automatically and manually, then it will be considered as bug.

  2. If adding a “null” option to the filter dialog (similar to flexgrid) suits your requirement, then this will be marked as a feature enhancement.

  The developers have asked which option suits you better, so that they can proceed further with this issue accordingly.

  Thanks & Regards,
  
  Aastha

• 

  sebastian-jn.k

  • Post Options:
  • Link
    Copy

  Posted 1 April 2024, 8:10 pm EST

  thanks for the response.
  
  Both options suits well, but which option is achievable with a workaround, so i can update the issue for our customer as fast as possible.
  
  my answer is the fastest and hopefully workaround solution- dev choice.

  greetings from germany