versaSRS Knowledge Base

 

 


Enable Full-Text Searching in versaSRS

Article ID: Q731137

Category: FAQ - Knowledge Base

The information in this article applies to:

  • versaSRS
  • Full-Text Searching
  • Version 7 to 7.1.0
Enable Full-Text Searching
  NOTE: Full-Text Searching is default enabled from version 7.1.1 onwards

SQL Configuration
  NOTE: VersaDev takes no responsibility for any data corruption or loss incurred, be sure to take extra care not to remove or change any data by mistake when operating directly on the database, we recommend performing a backup and implementing on a test environment before performing on production. 

1. In SQL Management Studio locate the versaSRS database table tbl_CallAudit

2. Right-click on the table and select Full-Text Index Table then Define Full-Text Indexing on a Table... to display the Full-Text Indexing Wizard. 

3. Click Next and select the default Unique index PK_tbl_CallAudit then click Next. 

4. Check the available columns then click Next. 

5. Select how to track updates and view changes (Automatically is default) and click Next. 

6. Click on the 'Create a new catalog' box, set the Name to Call Search, click Next, then Finish to complete the setup. -Remember to change Call to the appropriate name for each table, refer to image for recommended names.

7. Repeat above steps for the following tables - tbl_ActionAudit, tbl_ChangeRequestAudit, tbl_ProblemAudit

The below image is what should be reflected in your database



VersaSRS Configuration 

1. As an Administrator click the cog icon in the top right corner of versaSRS.

2. Select Global Settings

3. Locate the Global Setting SearchModule and select the option Full Text Search from the drop-down selection. Can also select the Both Search Module (Standard and Full Text) option.


4. Click Apply to commit the change to the system.

5. Reload the Global Settings by clicking the Reload icon  next to the Application Property header above the settings list.

Did the information in this article help answer your question?

Yes
No
Did not apply


Last Reviewed: 27/05/2022
Powered By VersaDev Pty Ltd Copyright 2022
Last Reviewed 27/05/2022

Print this page  Print this page
Click link to send to a friend  Send to a friend
Add to Favorites  Add to Favorites

Provided by
VersaDev Support Services