OroPlatform Forums

Covering OroPlatform topics, including community updates and company announcements.

Forums Forums OroPlatform OroPlatform – How do I? Questions Case insensitive grid filtering.

This topic contains 1 reply, has 2 voices, and was last updated by  Yevhen Shyshkin 8 years, 1 month ago.

Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.

  • Creator
    Topic
  • #36207

    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
  • #36208

    Yevhen Shyshkin
    Participant

    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)

The forum ‘OroPlatform – How do I? Questions’ is closed to new topics and replies.

Back to top