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.

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.
Important
Please note that news wires are excluded from Cinegy Desktop Search. Use Cinegy Newswire Browser to search for wires in Cinegy Archive database.

Press the "Search by tags only" button to perform 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 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.

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

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 AND operator)

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

Operators

OperatorShortcutDescriptionExample

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

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 QuerySearch 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.
Important
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 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.

SearchEx_autocomplete_word

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.

SearchEx_autocomplete

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

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

Advanced_search_window
Important
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:

SearchEx_sort_by

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:

searh_then_by
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:

SearchEx_modification
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:

SearchEx_modification_time

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:

SearchEx_searching_within

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):

SearchEx_search_in

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.

SearchEx_add_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:

SearchEx_metadata_fields

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.

SearchEx_equals

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.

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