C1TrueDBGrid FilterMultiSelect Not working

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

  • 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.
  • Replied 29 May 2018, 9:56 pm EST


    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,
  • Marked as Answer

    Replied 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
  • Replied 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:;

    Syntax Error: Missing operand before 'Like' Operator.

    How to fix this in localization??
  • Replied 25 December 2019, 5:40 pm EST


    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

    Prabhat Sharma.
  • Replied 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.
  • Replied 25 December 2019, 10:07 pm EST

    FYI, this was working well in C1TrueDBGrid (version 2.0.20102.61197).
  • Replied 26 December 2019, 5:31 pm EST


    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.

    Prabhat Sharma.
  • Replied 29 December 2019, 6:48 pm EST


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

    Siva | CEO | AmbalSoft
  • Replied 29 December 2019, 8:50 pm EST


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

    Prabhat Sharma.
  • Replied 18 March 2020, 11:05 pm EST


    I am glad to tell you that your issue fixed in the latest build. You can download the same from the following link:


Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels