My Oracle Support Banner

All Mode Sort and Search Functionality (Doc ID 523522.1)

Last updated on AUGUST 19, 2022

Applies to:

Siebel Tools - Version 7.5.3 [16131] and later
z*OBSOLETE: Microsoft Windows 2000
Database: Oracle
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 25-Jun-2016 ""


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).


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.