E1: GRID: Wildcard Search with QBE Does Not Return All Records When Unicode Set to N
(Doc ID 2505671.1)
Last updated on NOVEMBER 22, 2019
Applies to:JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.
When on Microsoft SQl Server Database, QBE search for Grid Columns will not functioning correctly for (*) wildcard, if Unicode is set to N for the Datasource.
Some but not all available results will be returned.
1. FastPath to a Search Browse Applicaiton Form (e.g. P41280)
2. Enter the following:
a. Item Number = <09999
b. Description = *AF
c. Branch/Plant = * (all)
3. Click Find and observe not all expected records are returned.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document