All Mode Sort and Search Functionality (Doc ID 523522.1)

Last updated on JUNE 25, 2016

Applies to:

Siebel Tools - Version 7.5.3 [16131] and later
z*OBSOLETE: Microsoft Windows 2000
Database: Oracle 8.1.7.4
Application Server OS: Microsoft Windows 2000 Advanced Server SP 4
Database Server OS: Sun Solaris 7

This document was previously published as Siebel SR 38-1280895011.

"" Checked for Relevance 28-JUN-2010 ""
"" Checked for Relevance 05-JAN-2015 ""
"" Checked for Relevance 25-Jun-2016 ""

Symptoms

This is regarding the Search Functionality in Siebel.

The Resultset returned from the Search functionality is not alphabetically sorted.
For example,if a user has access to My Team's Accounts and he performs a query on Account field (using binocular Search), the  result set is not sorted on Account Name.

We have done the initial analysis and found out that 'All Mode Sort' BC User Proerty which is set to FALSE at the Account BC level causes the sort feature to be removed from Account field in My Team's,All and All Across Organization Views.

And since the Search Feature looks at the highest visible views for a given user, in case of a user having All or All Across or My Team's views, the data returned will not be sorted.

Please suggest on how we can work around this problem so that the resultant Data in case where a user has access to My Team's All or All Across Views gets sorted alphabetically.

Also as we can see from the attached Analysis, strangely, in spite of 'All Mode Sort' being missing from the Opportunity and Contact BC User Properties, in My Team's Contacts and My Team's Opportunities data is not getting sorted by Last Name and First Name(In case of Contacts) or by Name(In case of Opportunities).



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms