Add Comment '--' In List Of Value SQL To Last Row Prevents A Partial Match Search. (Doc ID 3050965.1)

Last updated on OCTOBER 08, 2024

Applies to:

Symptoms

On : 11.13.24.07.0 version, Custom Reports and Analytics

Adding the comment '--' to the SQL of the LOV in the data model to the last row prevents a partial match search.

[Step by Step for reproduce.]

1.Click the List of Values for the data model to create one
2.Create a new list of values
3.Insert '--' comment on last line as follows
     select user_id
     from per_users
     --
4. Go to Data tab of the data model
5. Click the triangle of the displayed parameter
6. Click 'Search' at the bottom of the list
7. Search by the first two characters of any of the displayed values
     Example: 1000345
     Start with [10]
8. Does not appear in search results

Changes

 N/A

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.