---
title: "Full Text Search"
slug: "advanced-portal-search"
description: "This document explains how to activate and utilize the Full-Text Search feature in SQL server, for advanced search optimization in the Decisions Portal. "
tags: ["SQL", "full text search"]
updated: 2024-09-23T18:49:44Z
published: 2024-09-23T18:49:44Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documentation.decisions.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Full Text Search

## Overview

By using the Full-Text Search feature, users are provided the ability to search through items in the Decisions environment by utilizing caveats such as partial phrase searches, description searches, or Short Type Name.

For more information on Full-Text Search, see [Get Started with Full-Text Search.](https://docs.microsoft.com/en-us/sql/relational-databases/search/get-started-with-full-text-search?view=sql-server-ver15) 

---

## Configuration

The following example demonstrates how to configure and utilize Full-Text Search as a means for advanced Portal search in the Studio/Portal.

1. Add the **Full-Text and Semantic Extractions for Search** feature utilizing the **New SQL Server stand-alone installation or add features to an existing installation** option on **SQL Server Installation Center.**For more information on how to install features in SQL Server, see [Add Features to an Instance of SQL Server (Setup)](https://docs.microsoft.com/en-us/sql/database-engine/install-windows/add-features-to-an-instance-of-sql-server-setup?view=sql-server-ver15#:~:text=To%20add%20a%20new%20feature,discovery%20operation%20on%20your%20computer.).

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2021-04-21_10h19_31.png)
2. Open **DecisionsInstaller.exe**then click EDIT SETTINGS. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-08-14_11h29_55.png)
3. Scroll to **FullTextSearch,**change the value to **Enabled**, and then click **Save**. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2021-11-12_15h32_41.png)
4. Click RESTART SERVICE, allow the Service to fully restart then exit the installer.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1635967931863.png)
5. Open the Decisions Studio, right-click the **System**Folder and select **Get** **Full-Text********Search****Status**to verify that the feature is enabled.
6. After verifying that the feature is **Active**, click OK to exit. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-09-23_14h40_17.png)

---

## Advanced Portal Search Options

By default, when the **Search**Bar is utilized, Decisions attempts to locate items by utilizing the entire phrase entered. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-09-23_14h42_14.png)After adding Full-Text Search to the SQL Server Installation, users may use Advanced Portal Search features to conduct more granular searches such as:

- **-or:**Placing "-or" between two phrases in the search bar allows users to locate instances in the Portal that match the first or the second phrase.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-09-23_14h44_08.png)

- **-any**: Placing "-any" between two phrases locates any instances containing one of the phrases. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-09-23_14h45_19.png)
- **search:name**: Placing "search:name" at the end of a search allows the ability to lookup matching instances only by their name. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-09-23_14h46_21.png)

- **search:description**: Placing "search:description" at the end of a search locates instances based on the object's description. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-09-23_14h49_01.png)