Search tips

  Work in Jama > Work in projects > Search and filter > Use search >

Search tips

Previous pageNext page Print this topic! Mail us feedback on this topic!

Search Query Tips

A query is broken up into terms and operators. There are two types of terms: Single Terms and Phrases.

A Single Term is a single word such as "test" or "hello".
A Phrase is a group of words surrounded by double quotes such as "hello dolly".

Multiple terms can be combined together with Boolean operators to form a more complex query (see below).

Search supports single and multiple character wildcard searches within single terms (not within phrase queries).

To perform a single character wildcard search use the "?" symbol.
To perform a multiple character wildcard search use the "*" symbol.

The single character wildcard search looks for terms that match that with the single character replaced. For example, to search for "text" or "test" you can use the search:

te?t

 

You can also use the wildcard searches in the middle of a term.

te*t

 

Note: Jama will automatically return wildcard searches at the beginning and the end of the search term. For example, if the search was for test, tests and tester will also be returned.

AND, OR & NOT

Boolean operators allow terms to be combined through logic operators. Search supports AND, "+", OR, NOT and "-" as Boolean operators (Note: Boolean operators must be ALL CAPS).

OR - The OR operator is the default conjunction operator. This means that if there is no Boolean operator between two terms, the OR operator is used. The OR operator links two terms and finds a matching document if either of the terms exist in a document. This is equivalent to a union using sets. The symbol || can be used in place of the word OR.

 To search for documents that contain either "jakarta apache" or just "jakarta" use the query:

         "jakarta apache" Jakarta

         or

         "jakarta apache" OR jakarta

 

AND - The AND operator matches documents where both terms exist anywhere in the text of a single document. This is equivalent to an intersection using sets. The symbol && can be used in place of the word AND.

 To search for documents that contain "jakarta apache" and "Apache Lucene" use the query:

         "jakarta apache" AND "Apache Lucene"

 

+ The "+" or required operator requires that the term after the "+" symbol exist somewhere in the field of a single document.

 To search for documents that must contain "jakarta" and may contain "lucene" use the query:

         +jakarta lucene

 

NOT - The NOT operator excludes documents that contain the term after NOT. This is equivalent to a difference using sets. The symbol ! can be used in place of the word NOT.

 To search for documents that contain "jakarta apache" but not "Apache Lucene" use the query:

         "jakarta apache" NOT "Apache Lucene"

 

Note: The NOT operator cannot be used with just one term. For example, the following search will return no results:

         NOT "jakarta apache"

 

- The "-" or prohibit operator excludes documents that contain the term after the "-" symbol.

 To search for documents that contain "jakarta apache" but not "Apache Lucene" use the query:

         "jakarta apache" -"Apache Lucene"

 

Grouping

Parentheses can be used to group clauses to form sub queries. For example, searching for (America OR Europe) AND maps will return all items with the words "America and maps", "Europe and maps" as well as those with all three words.

Searching Specific Fields

Search supports the ability to narrow the search to specific fields. For example to search only within the name field use the field name followed by ":" (no spaces).

 To search for items where the status pick list has the value of new.

         status:new

         priority:urgent

 

Note: Currently, Jama does not support searching on "null" values. This is important if you are searching for items with check boxes. Check boxes that have not been checked will have a value of null and will not appear in a search for a blank value.