Last updated on JUNE 25, 2016
Applies to:Siebel Tools - Version 7.5.3  and later
z*OBSOLETE: Microsoft Windows 2000
Database: Oracle 22.214.171.124
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 ""
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).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms