Use the Search Database feature to perform a search based on text within a field.
NOTE: Entering in a client's name into the Search Database feature DOES NOT return all workorders where this client was selected. That is NOT the function of the Search Database feature.
If you wanted to view all workorders for a specific client, you would open the Service Workorders grid and filter by the Client name column to show all workorders where that client was selected.
Or right-click on the client's name in any main grid, and select List All Workorders.
Whereas if you wished to display all records that have the text “error message”, use the Search Database feature.
The Search Database feature allows wildcard searches and multiple word searches.
Wildcard search
You can use the asterisk wildcard character at the start or end of a word to find all records that partially match your search word.
For example “cab*” would match the word cable or the word cabinet.
Wildcard is asterisk character * and can be used at the start or end of any term in the search phrase: “*sun*” would match “Samsung”, you can also do it more than once so “*sun* not*” would match “Notes about Samsung”
Multiple words searches
You can enter multiple words and AyaNova v4 will return search results with the words in the exact order, as well as within the same text field but not necessarily in that exact order.
AyaNova v4 will display rank indicating whether the words are found close to each other.
Combination of both
You can enter search terms that include the wildcard character, as well as multiple words.
For example, you may enter in “install* software” to return any records that have both the text install and software, whether install is part of the word installation or not, etc.
Common words such as “the”, “same”, “not” etc are common words that are excluded from searches. AyaNova v4 uses a standard built in list of 117 English stop words.
If your organization will be entering CJK text (Chinese, Japanese, or Korean) language characters, it is recommended that you set this within Global Settings to True 
Do not set Use CJK Index to True if you are utilizing any other language other than Chinese, Japanese, or Korean as it will affect the speed of indexing.
Columns of the Search Database grid:
Rank
This identifies the internal ranking of the search term
Source
This column identifies the object where the search result was found.
For example, if it displays Workorder, than the search result was found in a Workorder header (which may be a service workorder, quote or pm). It if displays Unit Model, than the search result was found in a Unit Model entry screen.
NOTE: Click on the field under Source column to open the object where the search result if found
Description
This column provides a brief description of the source.
For example, if the source is a workorder, this column will state the whether a Preventive maintenance, quote or service workorder, the number, and the client for whom the workorder is for.
Extract
This column “extracts” or displays the contents of the field from where the search term was found.
If you place your mouse over this column field, a popup will display the entire extraction
Record Created
The date and time the object was created
Record Created By
The AyaNova user that created the object
Record Modified
The date and time the object was last modified
Record Modified By
The AyaNova user that last modified the object