This discussion is archived
7 Replies Latest reply: Mar 28, 2013 5:52 PM by Timo Hahn RSS

ignorecase in LOV  viewcriteria

989660 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points