Search for records
-
Select the Search icon to search your records. A Search workspace with a basic search form is added to the Workspaces bar:
- Select a module from the top drop list:What is a module?
The management of a collection can involve a vast amount of information about collection objects / items, people and organizations, events, administration and more. This information is stored in modules that are specific to the type of information: for instance, the Parties module stores information about people and organizations involved in some way with your collection.
- Enter your search term in the Search field:
Your search term can be as simple as a single word or it can be one or more of a range of search types (phrase, stemming, phonetic, etc.), employing wildcard characters, and case sensitivity for instance.
When building a search term, options include:
- NOT: exclude records where this term appears in the search field.
- Phrases: return records which include an exact phrase in the search field.
- Phonetic: return records that contain terms in the search field that sound like the search term (particularly useful with names).
- Case sensitivity: only return records where the case (upper / lower) of the search term matches the case in the search field.
- Wildcards:
*
(substituting for one or more characters),?
(substituting for a single character), and so on.
These search options can be used alone or in combination.
All of the searches employ special characters such as
*
,?
,"
,@
,!
,~
and=
. Because Axiell Go is Unicode compliant, it is possible to search for these characters, and we must therefore indicate when their special meaning should apply. We do so by escaping these characters with a backslash (\
).Why we escape Special Characters in a search termUnicode is a character set containing the characters of virtually every written language. Axiell Go is Unicode compliant which means that it is possible to represent and therefore search for almost any character, including punctuation and other special characters. We could, for instance, search for a single question mark (
?
) or for the@
character as part of a more complex string (fred@global.com
).Certain characters can have a special meaning when performing a search. A question mark can be used in place of a single character in a search term for instance: if we aren't sure whether an ise or ize spelling has been used (e.g. organise / organize), we could use a
?
in place of the s/z, i.e.organi?e
to search for both words.However, because it is possible to search for a question mark in its own right, we need to tell Axiell Go when we want the special meaning of a character to apply.
Applying the special meaning of a character is done by escaping it, which we do with a backslash
\
.For instance:
- A search for
organi?e
will attempt to locate the eight charactersorgani?e
. - A search for
organi\?e
takes advantage of the question mark wildcard and will locate bothorganise
andorganize
.
The following advanced searches are possible with Axiell Go:
NOTNOT
is specified by placing an exclamation mark!
before a search term. TheNOT
operator excludes records that have the following term in the search field.NOT search Description \!rock
Records that contain the word
rock
in the search field will not be returned by this search.\!rock roll
This search will return records that contain
roll
in the search field but only ifrock
does not also appear in the field. Records withsausage roll
in the search field will be returned; records withrock and roll
in the search field will not be returned.The
NOT
operator can be applied to any of the other search operators.For example:
NOT search Description \!\^Unknown\$
Return records that contain anything apart from the single word
Unknown
(see Pattern Matching).\!\"Not Applicable\"
Return records that do not contain the phrase
Not Applicable
(see Phrase Search).\"\==Sacré \==Cœur\" \!Paris
Return records containing the phrase
Sacré Cœur
with case and diacritic significance but not if the searched field also includes the wordParis
(see Case & Diacritics).Text retrievalThe following text searches can be performed:
A phrase searchA phrase is one or more words adjacent to each other, e.g.
business systems
. In a Phrase search, quotation marks are used to define the phrase.A Phrase search returns records that contain the search terms in the order in which they appear between the quotation marks:
Phrase Search results
\"business systems\"
Records with the phrase
business systems
will be returned.A Phrase search is more precise than a Boolean AND search in which the words can appear anywhere and in any order in the search field. For example, an AND search for
business systems
would return a record containing the sentence "The business has many systems". Our example Phrase search would not return this record.\"sacre-coeur\"
A phrase search is not case or diacritics sensitive. For instance, in the first example, records with
business systems
,Business systems
orBusiness Systems
will be returned. And in this example, records containing the phraseSacré-Cœur
would be returned.Tip: See Case Sensitivity & Diacritics below for details about making a Phrase search case sensitive.
StemmingWith stemming it is possible to find records that contain variations / derivatives of a search term (e.g. plural, adjectival, conjugation, etc.).
Stemming is specified by placing a
~
(tilde) directly before the search term:Stemming Search results
\~system
system, systems, systematic, systematics, systemless, systematically, systematise, systemic, systemise
\~view
view, viewer, viewing, viewable, viewership, viewfinder, viewgraph, viewless, viewpoint
\~bracket
bracket, bracketed, bracketing
Phonetic SearchA Phonetic search returns records that contain terms that sound like the search term. A Phonetic search uses the
@
symbol:Phonetic Search results
\@krystal
crystal, krystal
\@color
colour, color
\@smith
smith, smyth, smythe
Case sensitivity & DiacriticsText searches are not case sensitive by default. A search for
business
will return records with the word business or Business, for instance. To make a text search case sensitive, use an equals sign=
before the search term:Case Sensitive Search results
\=Business
This search will return records which contain
Business
but notbusiness
.\=\"Business system\"
This search combines a case sensitive search with a phrase search and will return
Business system
but notbusiness system
.As text searches are case insensitive by default, there is rarely a need to specify that a search is case insensitive. A situation in which it would be useful is where we specify a case sensitive Phrase search but want a word in the phrase to be case insensitive. We use
\&
to specify case insensitivity:Case Insensitive Search results
\=\"This is about our Business \&Systems\"
This search would locate both
This is about our Business Systems
andThis is about our Business systems
.Case and Diacritics matchingCase AND diacritics matching is specified as
\==
.Search Find \==Sacré \==Cœur
This search will return records with
Sacré
andCœur
exactly as specified, that is matching case and diacritics, but not necessarily next to each other.\"\==Sacré \==Cœur\"
This example combines a Phrase search with case and diacritics matching. It will return records with
Sacré Cœur
exactly as specified, in the same order and matching case and diacritics.Pattern matching: using wildcardsWith Pattern matching it is possible to:
- Substitute one or more wildcard characters for one or more letters in a search term.
- Specify that a term appears at the beginning or end of a field.
Tip: Wildcard characters can be used alone, in combination with each other and with other types of search. See below for some examples of combined searches.
Wildcard Use
Examples
\*
Substitutes zero or more characters at its position in a search term.
Tip: To return all records with something in the search field, that is, all non-empty fields , enter
\*
in the search field.appl\*
will match words starting withappl
, e.g. apple, application, applied, etc.edit\*
will match words starting withedit
, e.g. edit, edits, edited, etc.\?
Substitutes for any single character at its position in a search term.
appl\?
will match apply and apple (but not apples).organi\?e
will match organise and organize.\?\?\?
will match any combination of three graphemes (letters, digits, any character).\^
Place at the beginning of a search term to specify that the term must display at the start of the field.
\^Hospital
will match Hospital for Patriots, and Hospital for Abandoned Animals (but not Patriots Hospital or Chicago Hospital).\^the
will match records with text beginning with the wordthe
.\$
Place at the end of a search term to specify that the term must display at the end of the field.
Organi\?ation\$
will match Funeral Directors Organisation and Funeral Directors Organization (but not Organisation of Funeral Directors).?\$
will match records that have text ending in a question mark.[\
any one of\]
Matches only one of a sequence of characters specified in any one of.
any one of may consist of individual characters or a beginning and end character in a range may be specified separated by a minus sign (e.g.
a-z
).Organi\[sz\]ation
will match Organisation and Organization.\[0-9\]
will match any number between 0 and 9.\{
one or more of\}
Matches one or more of a sequence of characters specified in one or more of.
one or more of may consist of individual characters or a beginning and end character in a range may be specified separated by a minus sign (e.g.
0-9
).Organi\{sz\}ation
will match Organisation, Organization and (in the event of a typo) Organiszation.Some useful wildcard searches
Wildcard
Description
Example
\^term\$
This will only return records that have the single word term in the search field, i.e. term must be the start and end of the value in a field.
\^Life\$
\*term\*
Is useful when you are unsure of the search term's spelling.
\*ose\*
will match Joseph, Yoseph, Josef, Yosef, etc.Examples combining various types of searchVarious types of search can be combined in powerful ways. For example:
Find Search Records with at least one word containing a capital
S
.\=\*S\*
Records where
Fred
occurs case significantly in the same sentence as the phonetic ofSmith
whereFred
appears first.\'\(\=Fred \@Smith\) ordered = 1 sentence\'
Records where the kanji character 豈 appear within 5 characters of the phrase 香港.
\'\(豈 \"香港\"\) <= 5 words\'
Records that contain anything apart from the single word
Unknown
.\!\^Unknown\$
Records that do not contain the phrase
Not Applicable
.\!\"Not Applicable\"
Records containing the phrase
Sacré Cœur
with case and diacritic significance but not if the searched field also includes the wordParis
.\"\==Sacré \==Cœur\" \!Paris
Records containing either an upper case or lower case
é
.\==\*\[éÉ\]\*
Records with text where the first word starts with a lower case Latin letter.
\^\
==\
[a-z\]\*
- Select Search to run the search
-OR-
Press Enter if you have a keyboard.
Which fields are searched?By default, Summary Data is queried for your search term (a record is returned if your search term matches a value in the record's Summary Data).
Every record has a Summary Data field. Summary Data is a combination of key data in a record (taken from one or more fields). Which field or combination of fields in a module is used to make up Summary Data can be specified by each institution (and implemented by Axiell developers).
By default search results are presented in a Grid View (a table): each row in the table is a record, and each column a field (or combination of fields) in the record.
See Viewing Search Results for details.