Company: Link Technologies
Case No: L08750. Project: 08.20: LinkSOFT Version 8.2
Logged By: Sanjay (Link Technologies) on 15 Aug 2017 08:18AM
Priority: Medium
Product: Helpdesk
Group: Enhancement
Time Taken: 18.00 (Weight: 18.00)
Version: 8.290.0115
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Sanjay
Resolve By: Friday, 25 August 2017 12:00 AM [2446 days since logged date]
Status: Closed
Subject: Add Full Text Search capability to Helpdesk
Summary:    

Check if FullText Search Is configured on the SQL Server.

Add FullText search on call Header and comments to improve search functions

Audit Notes:
15 Aug 201708:18AM Comment 1 by Sanjay (Link Technologies) Case 8750 added to project 8.17
15 Sep 201709:53AM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 15-09-2017 09:53 AM Time Taken: 16.00

We have added functionality to use full-text search if it is installed o the server.

Full-Text search is highly recommended as the search capabilities are enhanced and a lot more intelligent than simple LIKE operator.

To check if FULL TEXT is enabled on your SQL server, check this server property:

SELECT FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')

You can install full text in all editions of SQL server.


15 Sep 201710:34AM Comment 3 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 15-09-2017 10:34 AM
Refer to this link for documentation:
https://docs.microsoft.com/en-us/sql/t-sql/queries/contains-transact-sql

17 Oct 201710:28AM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 17-10-2017 10:28 AM Time Taken: 2.00
WE have tested this on Link Internal helpdesk and is working as designed.

09 Oct 201908:14AM Comment 5 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019
If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L08750 in the subject line of all emails regarding this issue.

Document size: 1.3 KB
For call complaints, please contact the Managing Director of the company using this form.