ssossossosso

Forums

Covering OroCRM topics, including community updates and company announcements.  Subscribe

This topic contains 1 reply, has 2 voices, and was last updated by Yevhen Shyshkin Yevhen Shyshkin 1 year, 6 months ago.

  • Creator
    Topic
  • #16698

    easy-dev
    Participant

    Hey,
    Is there is any way of making string type filtering case insensitive ?

    Thank you
    Matt

Viewing 1 replies (of 1 total)
  • Author
    Replies
  • #16700
    Yevhen Shyshkin
    Yevhen Shyshkin
    Oro Core

    Hello.

    By default string filters use LIKE operation for “contains” filter type, and LIKE works differently on different DBMSes – for Mysql it is case insensitive, for PostgreSQL – case sensitive.

    I can assume that you are using PostgreSQL. In this case you can either override default filter behaviour and apply mb_strtolower to value and LOWER DQL function to DB query – in this case all filters become case insensitive, or you can add option to this filter and make case insensitive only required filters.

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.