My Oracle Support Banner

Search Functionality Using Query By Example Not Working On Worklist Columns like SENT And Status (Doc ID 2891351.1)

Last updated on AUGUST 23, 2023

Applies to:

Oracle Workflow - Version 12.2.10 and later
Information in this document applies to any platform.


After enabling search on SENT and STATUS columns of worklist, when user tries to search on existing value, the following message shows and no values are returned:

‘There are no notifications in this view’

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

1. Refer to section 3.10 (Query By Example for Tables) in Note 2692990.1
2. Use ‘Personalize Notification List’ and enable search on SENT and STATUS columns.
3. Search on existing value for SENT or STATUS and see above message


 Enabled Search functionality for Worklist columns


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.