Setting Up a New Location-limited Borrower Browse Index

First, you need to set up a new location-limited browse index for the borrower.

To set up a new location-limited borrower browse index

1 Download the BorrowerBrowseSearchIndexTemplate.sql SQL text file from the location where you accessed these Update Pages.
2 Open the text file for editing.
3 Search for $ in the file and replace it with an entry code for the new index that you are creating. For example, replace $ with borrM for a main borrower only search.

Note: The entry code that you specify cannot have more than seven alphanumeric characters, but it can have as few as you want.

4 Execute the SQL script using your SQL Query tool.
5 Open the Horizon client and log in.
6 Go to Administration > Table Editor.
7 Select the mq_index table, and then click OK.
8 Select the new mq_index that you specified in step 3, and then click Edit. For example, borrM.
9 In the Location Limit area, add any locations that should appear in the new index.
10 To rebuild the borrower name indexes, open a command prompt and run the following command:

reindex.exe /S /P /U /D /M3 /Aborrower

 


© 1998-2017 Sirsi Corporation