Full text search
Jama Connect uses an index of the database fields for its search function. It also searches in text files, Word files, and PDF files to find the items you're looking for.
You can search item IDs, descriptions, attachments, and field values. Search for an item's unique ID (not global ID) and it opens.
Important considerations
The application doesn't support searches for null values, including checkboxes that haven't been selected.
Files larger than 25 MB aren't indexed, so their content isn't searchable.
These file types are indexable: PDF, DOC, DOCX, PPT, PPTX, TXT, RTF.
These file types are not indexable: XLSX, XLS, XML, HTML, HTM.
Ways you can search
For a simple search you can enter a word or a phrase in the search field. For an advanced search you can use wildcards, Boolean operators, and more.
Single term — Enter a single word to find items. For example,
Test
returns items with the termstest
,pretest
,tests
,tested
, andtester
.Phrase — Enter a group of words surrounded by double quotes. For example, “
primary test
" returns only items that contain the wordsprimary test
.Single character wildcard — Enter a single character wildcard (?) with a single term (not a phrase). For example,
te?t
returns items that containtest
,tent
, andtext
.Multi-character wildcard — Enter a multi-character wildcard (*) with a single term (not a phrase). For example,
syn*ize
returns items containing the termssynchronize
andsynthesize
.Important
To avoid a syntax error when you search, don't begin a search with an open or close parenthesis followed by text or by itself.
Boolean operators — Boolean operators in ALL CAPS to combine phrases or terms.
OR (||) is the default Boolean operator when you enter two terms or phrases. For example,
primary test
ORsample
returns items that contain eitherprimary test
ORsample
.AND returns items where both terms and phrases exist. For example,
primary test AND sample
returns documents that contain bothprimary test
andsample
.+ returns items that must contain the term or phrase immediately following the +. For example,
+primary test
returns items that must containprimary
and might containtest
.NOT (-) excludes items that contain the word or phrase after NOT. The application doesn't allow null searches, so you must enter something before the word NOT to get any results. For example,
primary test
NOT sample
returns items that containprimary test
but notsample
.
Parentheses — Use parentheses to group clauses and form sub-queries. For example,
(tests OR samples) AND maps
returns results that containtests
andmaps OR samples
andmaps
.Prefix — Use the prefix
tag:
to indicate the tag field in your query. For example,tag: requirement management AND tag:security
.Field name — Use field names followed by a colon to search for information in specific fields. If a field name contains spaces, replace the space with an underscore character (_). For example,
user_status:new
returns items with a User status field that containsnew
.
A note about special characters
A few special characters are automatically excluded (escaped) from full text search, so that they can be searched for as plain text.
The auto-escaped characters are: \ ^ [ ] { } ~ /
If you used \ to manually exclude special characters, you can achieve the same results by using double quotations. For example, if you previously searched using \*abc to treat the * character as text, you can now use “*abc” instead.
Note
Special character search only works with newly created items. To use with older items, re-index the items you want to use in the search.