Welcome to Orbus Software

Welcome to the Learning Ecosystem

Monday, 19 February

{{currentUserFullName}}

{{currentUserFullName}}

Sign Out

Full-Text Search in iServer


Please Note: This article is for iServer 2015

The purpose of Full-Text Search is to allow iServer users to search for specific text within Microsoft Office documents when performing a search. The steps outline the actions that need to be performed on the iServer database within SQL Server Management Studio (SSMS), and on the file system of the machine where iServer is installed.

In order to perform full text searching on a table you need to do the following:

  • Ensure that the relevant Full-Text service is running on your SQL Server instance
  • Install the Microsoft Office 2010 Filter Packs
  • Run the SQL script provided by Orbus Software

Ensure that the relevant Full-Text service is running on your SQL Server instance

In order to implement Full-Text Search in iServer, you must have the relevant service installed and running:

  • SQL Full-text Filter Daemon Launcher

Install the Microsoft Office 2010 Filter Packs

The Microsoft Office 2010 Filter Packs should be installed on the SQL Server. The installer can be downloaded here:

Run the SQL script provided by Orbus Software

Download the Enable Document Contents Search.sql script at the foot of this article.

  1. Ensure that the steps above have been completed first
  2. Execute the script against the iServer database
  3. The following will display on completion: Warning: Table or indexed view 'dbo.Version' has full-text indexed columns that are of type image, text, or ntext. Full-text change tracking cannot track WRITETEXT or UPDATETEXT operations performed on these columns.
  4. After the script has finished running, reboot your SQL Server

Performing a Full Text Search in iServer

When creating a View in iServer, you will now have the option to filter by "Document Text":

In Portal, when using the main search bar it will automatically search document contents. You can use the "Search file contents" checkbox in Advanced search to toggle this setting:

Disabling Full-Text Search

To disable Full Text Search, execute this attached script against the iServer database:

  • Disable Document Contents Search.sql

Support

For technical support around this functionality please submit a support request.


Back to KB

Was this article helpful?

Yes No

Thank You! We appreciate your feedback

You and {{helpful}} people {{helpful}} person found this helpful