OAF - Dynamic Where clause in VO - executequery() not executing
Oracle EBS 12.1.3
Jdeveloper 10.1.3.3.0
This is a custom application, where the contents of an advanced table is based on a VO. the requirement is to restrict the records by a search string on field "item".
so I created a search text field, and a button to execute the search. Captured the event in the controller which in turn calls a method in the AM.
// Search items within project lines
public void srchLineItems(String headerID, String itemSrch)
{
System.out.println("inside AM : Method srchLineItems In + "); if ( itemSrch == null || "null".equals(itemSrch) || itemSrch == "" )
{
throw new OAException("Please enter part of the item to search.", OAException.WARNING);