Report User Guide Problems and Errors

Search Formats

To search for a contact in the Accelerator phone book, enter a value into a search field and click the search button. You can search on any field both (custom and default) in Accelerator. 


Fast Search will limit the number of contacts returned on a query by displaying a maximum of 500 contacts in the search result.  To display more then 500 contacts, turn off Fast Search.


Accelerator provides 3 search modes, and you can switch between these modes by selecting |Preferences|Toggle Advanced Search Mode| from within the phone book.  The following search modes are available.



Searches are not case sensitive.

Searching by 'Create' or 'Last Edit' Date

From the Preferences Menu, select |Customize Search Criteria|.  Change the search criteria to
a field you would like to search on, typically Create Date or Last Edit Date.  Click |Done| to save
your settings. 

 

 

 

 

 

 

 

 

 

 

 


Note, after searching by date, or last edit, you can sort the data by either criteria by
selecting |Results|Sortby| and choosing the appropriate 'sortby' option.


 

To search for contacts created or last edited Jul 11, 2001 7 - 11 - 01

or

07 - 11 - 2001

To search for every match on or before 7/11/2001 use the following format: to 7 - 11 - 01

or


to
07 - 11 - 2001 
To search for every match on or after 7/11/2001 use the following format: 07 - 11 - 01 to

or
 
07 - 11 - 2001 to
To search for every match in the range of dates 7/11/1998 to 8/21/2001 type in either format:
7 - 11 - 98  to  8 - 21 - 01

or

07 - 11 - 1998  to  08 - 21 - 2001
To search for a date with a wild card */*/2007 (all contacts created or edited in 2007 of any day and any month)  or 05/*/* (all contacts created or edited in May of any month and any year)

 

Searching by Time 
Searching by Time applies to custom fields that are set with time attributes.  See Edit Custom Fields for more information on setting time attributes. 
To search for an entry(s) marked with a specific time 10a 
To search for every match on or before a specific time to 2:00:36p
To search for every match on or after a specific time 2:00:36p to
To search for a range of entries in  a time frame. 10:00:35a to 11:00:58p

 

Searching by Date and Time
Searching by date and time applies to custom fields that are set with date and time attributes.  See Edit Custom Fields for more information on setting time attributes. 
Searching in a time and date field 2 - 14 - 01 10:00a
To search for every match on or before a specific date and time.  to 2 - 15 - 01 2:00p
To search for every match on or after a specific date and time. 2 -15 - 01 2:00p to
To search for every match in a specific time and date range 10:52:a 2 - 14 - 01 to 3:00:36p 2 - 15 - 01

 

Searching in Numeric Fields
Searching by numeric fields applies to custom fields that are set with numeric attributes.  See Edit Custom Fields for more information on setting time attributes. 
Number Fields (Floating Point) Must search for exact numeric value
Positive Integer (32 bit) Must search for exact numeric value
Integer (32 bit) Must search for exact numeric value
Currency Must search for exact numeric value

 

Boolean (True/False)
Searching by Boolean applies to custom fields that are set with Boolean (True/False) attributes.  See Edit Custom Fields for more information on setting time attributes. 
Boolean (True/False)  t = true, f = false

 

Searching Text Fields


The Accelerator Advanced Search options provide a much easier method of advanced search and should be used in place of the following text field syntax.   

Any with exact value "Accelerator"
Any NOT with exact value !"Accelerator"
Any ending with rator *"rator"
Any NOT ending with rator !*"rator"
Any starting with Acc "Acc"*
Any NOT starting with Acc !"Acc"*
Any containing celer *"celer"*
Any NOT containing celer !*"celer"*
Any blank field ""
Any NOT blank field  !""