Search Modes

Reading time ~8 minutes

The Cinegy Desktop search tool can operate in simple and advanced modes.

Simple Search

To start searching, enter your request in the "Search" field and hit Enter or press the search_from_button button.

SearchEx_simple_search

Simple "Search" window

cancel_button

If the searching operation takes too long or it is necessary to correct/change the request, press the "Cancel" button to stop the searching process.

Note	The Cinegy Desktop search function looks for different object types that contain the search word in the name or in the metadata.

Note	Please note that news items are excluded from Cinegy Desktop Search. Use Cinegy Newswire Browser to search for news items in the Cinegy Archive database.

Press the "Search by tags only" button to perform a search only by the data entered in the "Tags" metadata field.

Note	If there are problems with the search query, the corresponding errors will be added to the System Log.

Search Request Syntax

You can use multiple words for the search. In this case, they are connected with the logical AND. You can also use the AND, OR, and NOT operators, as well as brackets. If you enter several words separated by a space, the operator AND is assumed.

The wildcard * is also allowed.

By default, the words in the search query that are shorter than 3 characters are not searchable. If such a word is part of a disjunction, the whole phrase is not searchable too.

Important

The minimal search query length can be changed via Cinegy Archive Manager. Refer to the Search paragraph in the Cinegy Archive Manager Manual for details.

The following tables explain the search request syntax.

Expressions

Note

Please note that SQL Server Full-Text Search considers punctuation and non-alphanumeric characters as separators; therefore, they are processed by SQL Server Search Engine as logical OR in query operations. For example, a search on black&white (either black.white or black;white, etc.) will be processed by Search Engine as separate words presenting the same search results as for the black OR white query.

Expression

Description

any word

All the forms of that word

Note	In the language used for full-text indexing.

"string"

The exact string

Any string of zero or more characters/words according to the defined narrowing parameters

Any single character

[^] Wildcard - Character(s) Not to Match

Matches any single character that is not within the range or set specified between the square brackets

Note	[^.] example query shows the specific usage of [^], where a dot is a not matching character meaning any string that does not contain a period (.)

"%exact phrase%"

The exact word combination or phrase

[] Wildcard - Character(s) to Match

Matches any single character within the specified range or set that is specified between brackets [ ]

Note	[.] example query matches any string with a period (.) and any string with a period (.) in a fixed position.

a word expression with a space (where space is equivalent to the AND operator)

Any strings that contain all occurrences of the query terms grouped by AND

Note	If the "?" symbol is placed at the beginning or the end of the word, it is processed as the "*" wildcard, i.e., "?" will be substituted by one or more characters.

Operators

Operator	Shortcut	Description	Example
AND	& or space	Logical AND	red monkey Joe & Willy black AND white
OR	\| or period	Logical OR	Joe \| Willy purse OR life black.white
NOT	~	Logical NOT	Joe NOT Willy ~fish & ~meat
( )		Logical grouping	(~red monkey) \| (John Smith)
LIKE, NOT LIKE	LK, NL	Matching a specified pattern	LIKE *land

Operator

Shortcut

Description

Example

AND

& or space

Logical AND

red monkey
Joe & Willy
black AND white

| or period

Logical OR

Joe | Willy
purse OR life
black.white

NOT

Logical NOT

Joe NOT Willy ~fish & ~meat

( )

Logical grouping

(~red monkey) | (John Smith)

LIKE, NOT LIKE

LK, NL

Matching a specified pattern

LIKE *land

Note	Please note, when using a NOT operator in your search query the search process may take a long time, especially in large databases. It is recommended to avoid using the NOT operator, wherever possible.

The table below shows possible search results when querying specific examples.

Note	The following given objects were used in search queries: Entire New Placeholder MOGs (Master Clip), Clip Description = "myseq007", itismyseq,My.New.Placeholder MOGs, myseq, myseq, myseq001, New.ClipBin, New ClipBin, new.seq003, new.seq006, Old;ClipBin, Old.ClipBin.

Example Query

Search Results

man

man and men

"*myseq*"

*myseq*

man*

man, many, manuscript, manner, manual control, man of the year, and so on.

?ean

Dean, Sean, and so on.

[C-P]arsen

Carsen, Larsen, Karsen, and so on.

*[.]clipbin

New.Clipbin, Old.Clipbin

new clipbin

New.Clipbin, New Clipbin, New;ClipBin

"%folder #1%"

folder #1

new[.]seq*

new.seq003 ( but not "new;s.eq006," not "ne.w.seq006" etc.)

new.clipbin

Entire New Placeholder MOGs, New.ClipBin, New ClipBin, new.seq003, Old;ClipBin, Old.ClipBin

*clipbin

New.ClipBin, New ClipBin, Old;ClipBin, Old.ClipBin

*[.]*

My.New.Placeholder MOGs, New.ClipBin, new.seq003, new.seq006, Old.ClipBin

Note	Will find all objects inside containing . in searchable fields.

new[^.]clip*

New ClipBin, New;ClipBin

my[.]*lde*

New.ClipBin, My.New.Placeholder MOGs, My.New.Placeholder MOGs 00:00:00:00 (master clip)

Note	Will find all objects inside containing "my." and "lde" in searchable fields.

new[.]seq00?

new.seq003, new.seq006

*myseq*

itismyseq, myseq, *myseq*, myseq001

Caution

The latest Cinegy DB Wizard patch should be applied to ensure proper search results.

Note	The search results can differ depending on Microsoft SQL Server editions and languages due to particular implementations.

Note

When using the expression with a range of symbols (written in square brackets) and performing a search within some text rather than searching for a single word, add the "*" symbol at the beginning and the end of the search expression. For example, if you are searching within some text for the words starting with any symbol of the [b-t] range and the second part of which is "end", use the following search expression: *[b-t]end*.

Note	When using the "%exact phrase%" expression, please note that the search process may take a long time, especially in large databases.

Auto-Complete Functionality

During a session, the system will remember the words you have entered into the search window. These will be added to the drop-down list. So, if you would like to repeat a specific search, you can select the word(s) from the drop-down list.

The search interface also supports the auto-complete functionality. So, when you start typing a new search request, the system checks the previous search request and if it recognizes the word, it will suggest this word to you.

If there are several words that match, the system will open the drop-down list with all the matching words. Now you can simply select the right word from the list or continue typing in the new word if the results do not correspond with what you wanted to search for.

Fuzzy Search

The search functionality suggests an alternative result when any word of the phrase entered in the "Search" field is misspelled:

Note	The "Did you mean" link is displayed only when Cinegy Search finds at least one misspelling in the search phrase.

The suggested phrase is displayed in the "Search" dialog box as a link. When a user clicks it, a new search session is started using the corrected query as a new search request.

Advanced Search

Advanced search allows more sophisticated search requests regarding clip names and metadata fields.

Press the SearchEx_advanced_button button next to the search field to show/hide the advanced search options in the "Search" dialog box.

Note	Cinegy Newswire Service is excluded from the Advanced search by default. Cinegy Newswire Service has its own dedicated Cinegy Newswire Browser that provides a convenient interface for search.

Advanced Parameters

Enter your search request in the "Searching for the terms" field.

Important

Wildcards "" and "?" are allowed for the advanced search. When a wildcard is used, the search operation is more time-consuming. Refer to the *Auto-Complete Functionality and Search Request Syntax paragraphs to learn about using the syntax properly.

Sorting the Search Results

The search functionality supports the ability to define sorting criteria for your search results. To set the primary sorting criterion, select the desired option for the "Sort by" list:

Select the "descending" checkbox to arrange your search results in descending order or leave this option not selected to use ascending order.

To enable the secondary sorting criterion, select "Then by" and choose the desired option from the drop-down list:

Note	The defined primary sorting criterion value will not appear in the "Then by" drop-down list.

For the second criterion, you can also define descending/ascending order by selecting the "descending" checkbox or leaving it empty.

Narrowing Search Results

The search functionality provides the ability to narrow the search by the time of creation or modification. To narrow your search, select whether the assets were created or modified at the specified time:

Note	When using only wildcard "*" as a search query, it is necessary to define the narrowing parameters; nothing will be found otherwise.

Then select the time scale:

You can also define the search location in the "Searching within" field. Press the "…" button and define the search location using the "Searching within" dialog:

By default, the search is performed in all node types. To search only for specific node types, press the "…" button next to the "Consisting of these items" field and select the desired asset type(s):

Conditions on Metadata Fields

You can make additional limitations to your search. This can be done by adding conditions to the metadata fields. To do this, add a row in the bottom part of the advanced parameters configuration group by pressing the SearchEx_add_field_button button.

Note	You can add as many rows to limit your search request as you need.

To select the metadata property field, choose the desired one from the pull-down menu on the left:

If, for example, you would like to search for the assets with the specific ingest location, select the "Ingest site" field from the list.

Note	The list of metadata fields available for your selection depends on your database settings.

You can also state if the property should contain or not contain the value you will be entering next.

Depending on the selected metadata property field, you can either enter the value field via the keyboard or select the corresponding option from the drop-down list.

Note	The drop-down list options depend on your database settings and can vary from those shown in the example above.

To remove the condition field(s), press the SearchEx_remove_field_button button.