My Oracle Support Banner

Uwq Quick Filter List Is Not Recognizing Select Distinct in the Query and Shows All Records (Doc ID 2652992.1)

Last updated on JULY 14, 2020

Applies to:

Oracle Universal Work Queue - Version 12.2.6 and later
Information in this document applies to any platform.


On : 12.2.6 version, Other - General

Custom Quick filter LOV is showing records that are not in query.

The issue can be reproduced at will with the following steps:

When opening the Quick Filter LOV it is showing items that are no longer available in the DB view that the filter is drawing from.
A custom quick filter has been created.
The SQL for the quick filter is SELECT DISTINCT assignee, 'ASSIGNED_TO = ' || assigned_to FROM iex_cu_str_uwq_v.
When the List is opened in the quick filter UWQ form, it displays all records and is not recognizing the DISTINCT statement




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

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