BuyLog In
Ticket Q310741
Visible to All Users

How to use the "Contains" filter operator in the Auto Filter Row

created 14 years ago

Hi,
When I set the ShowAutoFilterRow to true and type something in a string column autofilter box it shows the records "starting with" the inputed text and to see the "contains" I have to type the '%' symbol. Is there any way to make the contain behavior default?
Thanks,
Edilson.

Sign in to comment on this post

Answers approved by DevExpress Support

created 14 years ago (modified 11 years ago)

Hi Edilson,
Thank you for your message.
Yes, it is possible. Just set the GridColumn.OptionsFilter.AutoFilterCondition property to Contains.
We hope that you find this information helpful.
Thanks,
Svetlana

    Show previous comments (2)
    NV NV
    Nirav Vyas 9 years ago

      Hi Svetlana,

      I am using "contains" in my gridview  for one column but I have an issue where it does not work.

      When I type in “cheese cream”… nothing gets found… then I type cheese phil   if finds a record as the exact description in the grid is Cheese Philadelphia Cream. So can I do something with filter that will allow me to search on %Cheese%Cream%

      I hope I am clear . Please let me know if you need any further information

      Thanks
      Nirav

      NV NV
      Nirav Vyas 9 years ago

        Hi

        Just found that I have posted it in Winforms question, I am having this issue in ASPxGridview. Just FYI.

        Thanks
        Nirav

        DevExpress Support Team 9 years ago

          Hello Nirav,

          In order not to mix WinForms and ASP controls within one thread, I've created a separate ticket on your behalf (Contains AutoFilterCondition - how to process search requests like "%Cheese%Cream%"). It has been placed in our processing queue and will be answered shortly.

          Sign in to comment on this post

          Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

          Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.