Some general notes on querying:
Ø The File Number should be formatted as 9999-99999 where the first (9999) is the year followed by a “-“ then the file sequence number with the leading zeros. (i.e. 1998-01234).
Ø The wild card character % will allow you to query for word(s) anywhere within a column
Ø The Town, County, Application Type and Status columns are drop down list columns allowing you to select a specific Town, County, Permit Type and/or Status.
Ø If the owner name contains NO wild card characters (%), then one will automatically be placed at the beginning and the end of the name.
Ø The Status Date From and Status Date To MUST be used together.
1. If the Status Date From is missing or invalid, it will be replaced with 01/01/1900.
2. If the Status To Date is missing or invalid it will be replaced with the current date.
Ø
Any combination of columns may be used to formulate
your query.
Ø
It is RECOMMENDED that a
town always be used when locating one or more sites.
A query can be built in many ways and some examples follow:
|
1. |
A user wishes to locate all sites in a specific town such as CONCORD. 1. Mouse-click
2. EITHER locate the Town box and press the letter C key for the first town beginning with the letter “C” then press the letter C key repeatedly until CONCORD appears in the town box OR mouse-click the down arrow to the right of the town box for a list of towns, use the scroll bar and scroll until you locate CONCORD and then mouse-click CONCORD to select it for querying. 3. Mouse-click
|
|
2. |
A user wishes to locate all sites in any town with an owner name containing the word JONES appearing anywhere in the name. 1. Mouse-click
2. Locate the Name box and key %JONES% 3. Mouse-click
|
|
3. |
A user wishes to locate all sites in CONCORD with a owner name containing the word JONES appearing anywhere in the name. 1. Mouse-click
2. Follow step 2 in Example 1 and step 2 in Example 2. 3. Mouse-click
|
