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 to clear any previous query parameters.

 

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 to clear any previous query parameters.

 

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 to clear any previous query parameters.

 

2. Follow step 2 in Example 1 and step 2 in Example 2.

 

3. Mouse-click