Hi,
One of the records in vendor table:
VendorNo: 1234
VendorName: "Test Vendor" (with two spaces in between)
There is an af:inputListOfValues on the ADF page with VendorNumber and VendorName search criteria.
1. When user is searching for this vendor with vendorNo or VendorName as above, it shows the record on LOV result section but with One space in between for VendorName.
2. When user searches with vendor name as above, it shows the result in LOV result section but the vendor name is displayed with One space in between.
3. When user trid to search the record with VendorName (with One space in between), it does not show the record.
There is no trim logic return. Where can the issue be, any inputs?
Thank you in advance.