Creating A Query

A Query is a way to filter ONLY the data the user would like to see by setting parameter examples. Once queried or filtered LandMark organizes the data into an Index temporary or permanent).

Saved Queries DO NOT automatically update as new information is added to LandMark, user must re-query.

An Index is a static list of records from a database made by a Query. Saved Indexes DO NOT automatically update as new information is added to LandMark, user must re-query.

The LandMark system uses Query By Example (QBE).
For more help on QBE CLICK the button in the upper right part of screen while in Query Definition screen.

Check out the List of Current Query Packages with explanation for all modules.

To View/Build/Edit a Query from any of the LandMark Files
CLICK Tools — Query
This box will appear.

From here user can:

1. Create New
   

• CLICK to build new Query
  A form appears as a blank data record (either Assessment, Appraisal File or Sales—depending), allowing the user to set data parameters in any field or multiple fields.
  

• TYPE in data parameters
• CLICK the run button

2. RIGHT-CLICK on the Query Name Line to show other available commands:

• CLICK Execute Existing to run re-query Query string and create a temporary Index
• CLICK Delete to delete saved Query
  

• CLICK Modify Existing to make changes in saved Query parameters
• CLICK View Query String to view current Query parameters

• CLICK Edit Description to make changes to description
• CLICK Create Package to make a package that can be shared with other LandMark counties (If user needs help creating a package, please contact your OSU representative.)