7 Replies Latest reply on Mar 29, 2013 12:52 AM by Timo Hahn

    ignorecase in LOV  viewcriteria

      I'm using Jdev
      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.