Setting Up a New Location-limited Borrower Keyword Index
Next, you need to set up a new location-limited keyword index for the borrower.
To set up a new location-limited borrower keyword index
|
1
|
Download the BorrowerKeywordSearchIndexTemplate.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 borrKwM for a main borrower keyword 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, borrKwM. |
|
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