C1TrueDBGrid FilterMultiSelect Not working

C1TrueDBGrid FilterMultiSelect Not working

Posted by: svageesan on 28 May 2018, 9:52 pm EST

• 

  svageesan

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 28 May 2018, 9:52 pm EST

  I was using C1TrueDBGrid (version 2.0.20102.61197) before and set FilterMultiSelect = True, FilterSeparator = , (comma char), FilterEscape = empty for each column of a bound grid. When data is shown, I was able to type “*er” in the filter bar for a field, and it would show all matches for ‘er’ even if found in the start/middle/end of the string. (like ervin, aster, master, merit et…). This was working good.
  
  I migrated to C1TrubeDBGrid (version 2.0.20172.271) and with the same source code, this feature is not working. It wouldn’t show all matches for ‘er’ even with above settings correct. What is to be done to make it work? Please update me.

• 

  meenakshi.singh

  

  • Post Options:
  • Link
    Copy

  Posted 29 May 2018, 9:56 pm EST

  Hi!

  Thanks for reporting this issue. I am escalating this to the team, and we’ll inform you once it is fixed [Internal ID : 324671].
  
  Meanwhile, you can avoid this issue by setting FilterOperator like this :

     c1TrueDBGrid1.Columns[2].FilterOperator = "%LIKE%";
  
  

  Best regards,
  
  Meenakshi

• 

  meenakshi.singh

  

  • Post Options:
  • Link
    Copy

  Posted 30 May 2018, 9:11 pm EST

  Please be informed, this is not a bug. This is due to change in the default value of FilterOperator property to ‘IN’ when FilterMultiSelect is true.
  
  As suggested above, you’ll need to set FilterOperator as “Like”.

  • Meenakshi
• 

  svageesan

  • Post Options:
  • Link
    Copy

  Posted 25 December 2019, 3:11 am EST

  It works in English localization language. If we change the form to Turkish localization and run it gives following error:;

  C1TrueDBGrid:
  
  Syntax Error: Missing operand before ‘Like’ Operator.

  How to fix this in localization??

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 25 December 2019, 5:40 pm EST

  Hello,

  We can observe the issue at our end too with your mentioned locale thus forwarding this to the developers and will let you know soon.
  
  Internal Tracking Id : 324671

  Regards,
  
  Prabhat Sharma.

• 

  svageesan

  • Post Options:
  • Link
    Copy

  Posted 25 December 2019, 10:06 pm EST

  I changed to TrueDBGrid.4 and tried the same. Still the problem is reported in localized Turkish language. Please see the screen shot. Send me an updated control for V4 as I have updated my project to V4.
  
  

• 

  svageesan

  • Post Options:
  • Link
    Copy

  Posted 25 December 2019, 10:07 pm EST

  FYI, this was working well in C1TrueDBGrid (version 2.0.20102.61197).

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 26 December 2019, 5:31 pm EST

  Hello,

  Thank you for additional information.

  As per our knowledge your license is valid through 2017V2 builds only and we can observe the issue with the latest builds i.e. 2019V3 also so we asking the developers to get it fixes ASAP.

  Fixes are made in the future builds only and as your build is too old that many changes have been made in the internal structure of the control so I would suggest you to upgrade to the latest build once it get fixed.

  We will let you know once we get any updates on this from the developer.

  Regards,
  
  Prabhat Sharma.

• 

  svageesan

  • Post Options:
  • Link
    Copy

  Posted 29 December 2019, 6:48 pm EST

  Hi,

  I purchased new C1 Ultimate license today and will be upgrading the project. Please send me the fix once ready.

  Regards,
  
  Siva | CEO | AmbalSoft

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 29 December 2019, 8:50 pm EST

  Hello,

  Thank you for upgrading.
  
  We will let you know soon once we get the information from the developers.

  Regards,
  
  Prabhat Sharma.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 18 March 2020, 11:05 pm EST

  Hello,

  I am glad to tell you that your issue fixed in the latest build. You can download the same from the following link:
  
  http://prerelease.componentone.com/dotnet452/c1winform/2020-t1/C1WinForms-452_4.5.20201.416.zip
  
  http://prerelease.componentone.com/dotnet40/c1winforms/2020-t1/C1WinForms.4_4.0.20201.416.zip
  
  http://prerelease.componentone.com/dotnet20/c1winforms/2020-t1/C1WinForms.2_2.0.20201.416.zip

  Thanks,
  
  Mohit