My Oracle Support Banner

Performance Issue: Search On All Columns Instead Of Selected (Doc ID 2374595.1)

Last updated on AUGUST 22, 2018

Applies to:

Siebel CRM - Version 16.13 [IP2016] and later
Information in this document applies to any platform.

Symptoms

On : 16.13 [IP2016] version, Client Functionality

ACTUAL BEHAVIOR
---------------
Performance issue (depending on amount of records) search on all columns instead of selected

Find functionality searches on all fields instead of which is selected in QueryComboBox.


EXPECTED BEHAVIOR
-----------------------
Find functionality should search only on fields  selected in QueryComboBox.


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

1. Go to All Activites
2. Clear all predifined quries
3. Choose QueryComboBox: Description
4. Choose QuerySrchSpec: mult1
5. Press search icon (arrow) - no performance issue results returned immediately
6. Change record status to: Active
5. Press search icon (arrow) - performance issue (depending on amount of records):  search is done on all columns instead of selected

Cause

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
Symptoms
Cause
Solution
References


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