Filtering on Set-Key

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

Multiple character wildcard searches looks for 0 or more characters. For example, to search for test, tests or tester, you can use the search:

test*

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

te*t

Note: You cannot use a * or ? symbol as the first character of a search.

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"

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:  Jama currently expects the backend field name used to configure the Item Type such as description or lookup1.  If you need to search on specific fields contact your Administrator for a mapping of the backend field names to those that you see in the Item detail under Item Types (pictured below).