Adding a Custom Database Index to SpeedSearch

[#1]

Included with each Sage SalesLogix purchase, customers can take advantage of SpeedSearch, which enables users to search for information stored in your Sage SalesLogix database as well as external documents on your network. Users can automatically insert SpeedSearch results into an active ticket or defect. If your company uses Web Customer Portal, your customers can also search for information that is publicly available.

To extend and customize SpeedSearch, you can add  the Advanced SpeedSearch license, which allows your company to  perform these additional tasks:

• Add or edit a file system index
• Add or edit a database index
• Delete an index
• Restore the standard indexes
• Secure an index

Why would you want to add a custom database index? For most Sage SalesLogix implementations, the default indexes are sufficient for users to search for and find information in the Sage SalesLogix database. However, you may want to add a database index if you need to search for information in a system table that was not included in the default—or from a custom table that you’ve added to extend the Sage SalesLogix product. Before you add a database index, determine what tables and fields contain the data that you want to make accessible through SpeedSearch. How you configure the index determines some of the options and information available to SpeedSearch users, as shown in this example.

Note: If you create a new index for a table that has never been indexed, the Open Results button in the Windows and Web Clients will not be available until you do some modifications in the Architect (Windows Client) and Application Architect (Web Client). See the “Adding or Editing a Database Index” in the Administrator Help.