I'm using Jdev 18.104.22.168
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.
thanks your reply,
but here, lov vo is sql query based vo.
when I tried to set the uppercase in the setattribute methods in rowimple, those setattrubute methods are not getting called while doing the search in the lov popup.
Thanks for your reply.
I already created index on the table, and its working fine.
but because of the performance issue, we cant keep more indexes on that table.
So, in the lov popup, when values are entered in the search fields, then can we convert those values into uppercase before search happens?