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

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


Simple "Search" window


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.

The Cinegy Desktop search function looks for different object types that contain the search word in the name or in the metadata.
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 search only by the data entered in the "Tags" metadata field.

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 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 search query that are shorter than 3 characters are not searchable. If such a word is a part of a disjunction, the whole phrase is not searchable too.

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.


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 black OR white query.
Expression Description

any word

All the forms of that word

In the language used for full-text indexing.


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

[^.] 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 [ ]

[.] 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 AND operator)

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

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.


Operator Shortcut Description Example


& or space

Logical AND

red monkey
Joe & Willy
black AND white


| or period

Logical OR

Joe | Willy
purse OR life



Logical NOT

Joe NOT Willy ~fish & ~meat

( )

Logical grouping

(~red monkey) | (John Smith)



Matching a specified pattern

LIKE *land

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.

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 and men




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


Dean, Sean and so on.


Carsen, Larsen, Karsen and so on.


New.Clipbin, Old.Clipbin

new clipbin

New.Clipbin, New Clipbin, New;ClipBin

"%folder #1%"

folder #1


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


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


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


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

Will find all objects inside containing . in searchable fields.


New ClipBin, New;ClipBin


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

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


new.seq003, new.seq006


itismyseq, myseq, *myseq*, myseq001

The latest Cinegy DB Wizard patch should be applied to ensure proper search results.
The search results can differ depending on Microsoft SQL Server editions and languages due to particular implementations.
When using the expression with a range of symbols (written in square brackets) and performing 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*.
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.


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

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 user clicks it, a new search session is started using the corrected query as a new search request.

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.

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.

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:

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:

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.

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.

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.

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_buttonbutton.