Optimizing Advanced Search Performance

To optimize advanced search performance, you can define the processing sequence of cross-object search parameters.

Features

The time required to retrieve advanced search results for queries containing cross-object search parameters can be optimized by assigning a higher priority to the business object search parameters that yield the fewest results. The following cross-object search parameters are available:

Advanced Search of	Search Parameter	Combined Search Parameters
Cases, Leads, Activities, Incidents, Persons and Organizations, Objects, and Locations	Incident	Relationship, Incident Type, Description, Category, Start Date, End Date, and Main Legal Reference
Cases, Leads, Activities, Incidents, Persons and Organizations, Objects, and Locations	Activity	Relationship, Activity Type, Description, Category, Start Date, End Date, Completion Date, Status, and Main Legal Reference
Cases, Leads, Activities, Incidents, Persons and Organizations, Objects, and Locations	Leads	Relationship, Lead Type, Lead Description, Status, Category, Phase, Start Date, and End Date
Cases, Leads, Activities, Incidents, Persons and Organizations, Objects, and Locations	Cases	Relationship, Case Type, Case Description, Status, Category, Phase, Start of Case, End of Case, Start of Crimes, and End of Crimes
Cases, Leads, Activities, and Incidents	Parties Involved	Relationship, ID, First Name, Name, Postal Code, City, Street, and Country
Persons and Organizations, Objects, and Locations	Parties Involved	Relationship, Valid From, Valid To, ID, First Name, Name, Postal Code, City, Street, and Country
Cases, Leads, Activities, Incidents, Objects and Locations	Staff and Units	Relationship and ID
Persons and Organizations	Staff	Relationship and ID
Cases, Leads, Activities, and Incidents	Objects	Relationship, ID, Description, Category ID, and Category Description
Persons and Organizations, Objects, and Locations	Objects	Relationship, Valid From, Valid To, ID, Description, Category ID, and Category Description
Cases, Leads, Activities, and Incidents	Locations	Relationship, Name, Category ID, Category Description, Street, House Number, Postal Code, City, Region, and Country
Persons and Organizations, Objects, and Locations	Locations	Relationship, Valid From, Valid To, Name, Category ID, Category Description, Street, Street Number, Postal Code, City, Region, and Country

You can define the processing sequence of cross-object search parameters in Customizing for Customer Relationship Management under Start of the navigation path Industry-Specific Solutions Next navigation step Public Sector Investigative Case Management General Settings Define Sequence of Cross-Object Search Parameters End of the navigation path .

Example

You submit a search for cases involving crimes that occurred in Italy and have a suspect from New York with the last name Wilson.

The query contains the location of the crime (relationship, city) and parties involved (relationship, name, and city) as cross-object search parameters. Realistically there are far more cases that occur in Italy than there are cases that may have a suspect named Wilson from New York. Therefore, if your searches typically reflect the parameters submitted in the example, you can optimize advanced search by assigning parties involved a higher processing sequence than locations.