What is the full-text search?
The full-text search is a google-like search that permits to look for multiple words across all the tables (e.g. assets, seasons, segments, genres, etc) used by Etere for storing assets information, thus allowing users to search across a set of asset data for whole words (e.g. motorcycle) or part of words (e.g. moto).
All SQL Servers are shipped with “Full-text search” capabilities that supports full-text queries against character-based data in SQL database, this feature must be installed during the SQL installation to facilitate the full-text search function.
The full-text search will be operational only if the system database has been indexed for supporting it, by performing a System Maintenance operation which includes the "full text search" maintenance task.
Detailed information
Please refer to chapter: "How to use Full-Text Search" for detailed information on the Full-text Search (e.g. how to enable it, view supported languages, disable stopwords, etc.).
Search in tables
The full-text search allows specifying the exact asset-related tables across which the search will be performed. Supported tables include:
Indexed tables
Assets - Search across the asset's title (e.g. wonderwall, breaking news, alien);
Season Manager - Search across the episodes' title (e.g. the simpons, peanuts);
SMPTE metadata - Search across the asset's custom SMPTE metadata (e.g. loudness, status);
Segment - Search across the segment's descriptions, both, manually (e.g. girl, flower) and automatically inserted (e.g. freeze, fault, change);
Artist Manager - Search across the asset's associated artists (e.g. Santana, Sting, Pink);
Genres - Search across the asset's associated genres (e.g. rock, flamenco, jazz);
Roles - Search across the asset's associated artist roles (e.g. singer, director, guitarist, actor);
Rundown Date - Search across the schedule of Nunzio;
Subtitles - Search across all the subtitles produced for assets (e.g. subtitles, captions, metadata);
Virtual documents - Search across the asset's linked Do.Ma. documents (e.g. pdf, doc, xls, jpg);
WARNING: Searching on portable documents (pdf) and microsoft documents (docx, xls, etc) requires the PDF IFilter and MS Filter Pack indexing tools to be installed in the database server respectively.
Keys/keyboards (asset) - Search across the keyboards (e.g. accidents, competitions) and Keys (e.g. airplane, train, car) assigned to the asset from the keyboards tab.
Keys/keyboards (segments) - Search across the keyboards (e.g. accidents, competitions) and Keys (e.g. airplane, train, car) assigned to the segment from the Etere MAM module.
Tapes - Enter a tape code (e.g. 194567) and enable this option to search for tape code associated with the segment.
All - Search across ALL the above mentioned fields (enabled by default).
Search options
The full-text search allows specifying some options regarding how assets will be displayed in list of results:
Order by relevance - If enabled, the list of results will be sorted according to the search ranking;
Highlight search - If enabled, the exact fields matching the full-text search will be pointed out in the list of results.
Tool buttons
The following buttons are provided to improve full-text and synonyms search:
Supported wildcards
Advanced search - Open a search wizard that allows building a search keyword based on wildcards:
contain the following phrase
" "
contain all following words
AND
contain any of the following words
OR
contain the two phases nearby
NEAR
contain the first phrase and not the second
AND NOT
whole words
Return complete matches (e.g. airplane), not partial (e.g. plane).
Control syntax - Check the correctness of the text entered in the search box (e.g. incorrect if only an asterisk (*) is entered);
Catalogue status - Checks the status of the "full-text catalogue" in the database (Idle, Full population, In progress, Paused, Throttled, Recovering, Shutdown, Incremental Population in progress, Building index, Paused due to disk full, Change tracking).
Please note that wildcards can be directly used in the search box; supported boolean operators include:
Supported Full-Text Searches
Contain... - whole words
Keyword: apple
Description : Find assets that contain the whole word apple in any of the selected fields;
WARNING: For multiple whole words (e.g. apple banana) refer to apple AND banana.
Results: the apple scruffs apple banana juice the apple and banana diet
Contain... - any of the following words
Keyword: apple OR banana
Description: Find assets that contain at least one between the words apple and banana.
Results: the apple scruffs apple banana juice the apple and banana diet peel the banana
Contain... - all following words
Keyword: apple AND banana
Description: Find assets that contain both words, apple and banana;
WARNING: In case two words are entered without operators (e.g. apple banana), the full-text search will consider the AND operator as present (e.g. apple AND banana).
Results: apple banana juice the apple and banana diet
Contain... - the first phrase and not the second
Keyword : apple AND NOT banana
Description: Find assets that contain the word apple but not banana.
Results: the apple scruffs
Contain... - the following phrase
Keyword: "apple banana"
Description: Find assets that contain the exact phrase apple banana.
WARNING: In case the "whole words" option is enabled (by default), the searched phrase (e.g. apple banana) will be considered as enclosed with quotes (e.g. "apple banana").
Results: apple banana juice;
Contain... - the two phases nearby
Keyword: apple NEAR banana
Description: Find assets that contain both words, apple and banana, rating the result higher lower if the distance between the two words is lower;
Results : apple banana juice the apple and banana diet
Contain... - words starting with
Keyword : "apple*"
Description : Find assets that contain words starting with apple;
WARNING: The asterisk character (*) must be preceded by at least one character (e.g. a).
Results : the apple scruffs apple banana juice the apple and banana diet Return to the applesauce Planet of the apples.
Ignored words
By default, SQL Server's full-text searches performed without quotation marks ignores the following kind of words:
➢ Short words: Words/characters of less than 3 characters (e.g. i, -, u, do, me, etc.);
➢ StopList words: Words in the system's StopList (e.g. another, each, into, some, under, your, etc.).
If you want to include StopList words in your not-quoted searches just disable them as explained in chapter "How to use Full-Text Search".
Short words and StopList words (unless disabled) must be avoided in not-quoted searches as they prevent results to be correctly displayed.
Example of use
In case an asset's field (e.g. title) is How I met your mother - Ep.42, said asset can be returned through the following correct searches:
➢ "How I met your mother - Ep.42" (exact phrase with quotation marks)
➢ "How I met your mother" (exact phrase with quotation marks)
➢ mother how met (whole words)
➢ your mother (whole words)
➢ your AND mother (whole words)
➢ mother (whole word)
➢ "moth*" (exact phrase with quotation marks and * wildcard)
➢ "Ep.42" (exact phrase with quotation marks)
Instead, if performing a wrong search, the asset won't be successfully returned:
➢ How I met your mother - Ep. 42 (wrong because "I" and "-" are short words)
➢ How I met your mother (wrong because "I" is a short word)
➢ - Ep. 42 (wrong because "-" is a short word)
Search thesaurus synonyms
In case the "Synonyms" option is enabled, there will be retrieved all assets with at least one field matching either the given keyword or its thesaurus synonyms. For instance, if you run a full-text query for "car", full-text search will return search results partially/completely matching it and its synonymous (e.g. "car", "automobile", "truck" and "van"):
Synonyms
Note:
For detailed information on how to configure synonyms please refer to the How to configure Thesaurus Synonyms chapter.