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
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.


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