<< Click to Display Table of Contents >> Navigation:  Using Cimera > Searching and Querying > Full Text Query

Menu > Query > Full Text Query or by pressing the Ctrl+F keyboard shortcut

 

 

What is indexed

 

When an item is created or updated the Cimera Index Server indexes every word and number in every field on that item and in every file attached to that item (assuming the Cimera administrator has set up the relevant iFilters on the Cimera Server). There will be a short delay between the save and the index being updated as the indexing is an asynchronous process.

 

When an item is deleted all references to it are removed from the index

 

 

What is matched

 

As with all 'Google' style searching the index stores complete words so there is no concept of the 'contains' or 'end with' string functions.

 

For example

searching for 'cats' will not find any items with text fields/attachments containing 'cat', 'catalogue' or 'bobcats'

 

However adding an '*' to the end performs a 'starts with' comparison.

searching for 'cat*' will find 'cat', 'cats' and 'catalogue'. But still not bobcats.

 

The "*" can only go on the end of the word, it is not possible to specify, say, "*ing" to find all words ending with "ing".

 

Use Query Build or CQL if more complex word matching is required (these search Attributes only, not text in file attachments)

 

 

Full Test Query Syntax

 

The format of a Full Text Query search expression is. Note where spaces are and (just as importantly) are not

 

KEYWORD(value)  KEYWORD(value)  KEYWORD(value) etc

 

The KEYWORD (case insensitive) can be

TYPE                  the value is the ItemType name

BUCKET                the value is the name of the Bucket

STATUS                value is the name of the Status

 

 

If the TYPE keyword is being used specify it first

 

Use OR (in capitals) to search for alternative values

 

 

Field Name Search

 

The <myfieldname> KEYWORD is case insensitive (as with all search terms) and all non A..Z characters are ignored

 

For example

the field "This & is % my 123. description!" can be specified as either Thisismydescription or THISISMYDESCRIPTION
the value is the standard search value, e.g. (fred*)

 

If the myfieldname is omitted then the brackets around the value can also be omitted and all fields are searched

 

If the field is a boolean then the search value is true or false irrespective of the text set up for the field

 

For example

type(Problem)  isaworkaroundavailable(true)

 

 

Important Notes

•no spaces between the KEYWORD and the "("

•When specifying possible values the "OR" must be upper case

•Use double quotes for exact phrases

•do not use single quotes

 

 

 

For example

TYPE(my type name)  BUCKET(my bucket name) STATUS(status value) <myfieldname>(field value)

 

catalogue

to find the complete word in any field or file attachment of any Item Type in any Bucket at any Status

 

cat*

to find words starting with the text in any field or file attachment.

 

title(cat*)

restrict the search to the title field, but on any Item Type

 

TYPE(problem) title(command escape blue) STATUS(open)

find open problems whose title contains all of the words specified

 

TYPE(problem) title("screen turns purple") STATUS(open)

find open problems whose title contains the exact phrase

 

title("genuin*" OR email OR "obj ref")

find all items, of any Item Type, which have a title field containing one of the text values

 

BUCKET(contact management) clientaddress(london OR birmingham) webaddress(www.a* OR www.b*)

 

If a <myfieldname>(field value) is specified then first look in CIs and then in Version fields