7 Replies Latest reply: Mar 28, 2013 7:52 PM by Timo Hahn RSS

    ignorecase in LOV  viewcriteria

    989660
      Hi,
      I'm using Jdev 11.1.2.0
      I have one lov(Input list of values) field of att1 of vo1.
      att2, attr3 of vo2 is added as a list of values on att1.

      created one viewcriteria on vo2 as " attr2 startswith or att3 startwith " .
      attr2 is the keyattribute in vo2.

      search in lov is working fine on the page and search is also fast.

      but when i check the ignorecase in the viewcriteria,
      then search takes more time.

      How to convert the search attribute values to uppercase to make the search fast?

      any suggestion would be appreciated.