Search 360

You can use Search 360 to find records that contain the same text as your search words. All records in the database are searched, including records that contain embedded documents and charts.

When you search for exact matches, the following allowances are made:

Variation

Example

Letter case

For example, Peter, peter and PETER are exact matches.

Punctuation and accents

Francoise is an exact match for Françoise

Word order

SMITH, Fred and Fred SMITH are exact matches.

Incidental words

"black pullover red baseball cap" is an exact match for a record with this text "wearing a black v-neck pullover and a red baseball cap"

You can also use Search 360 to find records that contain similar text to your search terms (a fuzzy match). In this type of search, the following allowances are made:

Variation

Example

Typing mistakes

Searching for ROBERTSON might also find ROBETRSON.

Missing spaces between words

Searching for Daniel might also find Danielsmith.

Spelling mistakes or sounds likes

Searching for PETERSON might also find PEDERSON.

Name variants

Searching for MIKE might also find MICHAEL.

Abbreviations

Searching for road might also find rd.

Note: The Search 360 file limit is 100Mb. Files larger than 100Mb are not indexed, and no search results are returned. You can compress large files to use with Search 360 and improve performance. Contact i2 Group Support if you need to increase the limit.

Searching for linked entities (related items)

You can also find information that is held in records that are directly connected to each other by a single link.

Searching for numbers, dates and time

You can search for numbers, dates, and times if the information was entered as text. The only recognized date and time separators are / (for example 2009/10/23) and : (for example, 15:43).

However, to take account of possible variations in number, date, and time formats you might need to search for spelling variations. For example,:

  • An exact search for 10,000 does not find records where the number was entered as 10000.

  • An exact search for 24.50 does not find records where the number was entered as 24.5.

  • An exact search for the date 04/11/89 does not find records where the date was entered as 04/11/1989.

What you cannot search for

There are a few limitations on what you can search for:

  • Values entered in number fields, date fields, or time fields

  • If you are using spelling variations, words with fewer than 4 letters

  • Common words, such as "the", "and" or any words in the stop list

  • Punctuation

Note: Search 360 is only available in SQL Server databases that have been indexed. The date of the last index update is shown in the upper right area of the Search 360 pane.

Although the default setting for Search 360 indexing includes all available fields, your administrator might choose to reduce the scope of the index. Fields that are not added to the indexing process are be returned as part of the search results.