Searching for Data in IMSMANG

Data search can be achieved by running saved searches, using specific item searches or the advanced search.

A specific item search (search land, search activity, search accident, etc.) returns a list of all corresponding items that were entered in IMSMANG. The results list can be sorted out by paring down the filter criteria or by picking other column headings.

The search engine allows for search definitions that correspond to more than one criterion and/or criteria node(s). Search definitions can have linked items (activities linked to a land, victims linked to an accident, etc.). A criterion can be defined by paring down its attributes, operators and values.

Searches defined with the search engine can be saved in the Saved Searches.

How To

Access the Saved Searches Window Filter Search Definitions Displayed Add a Search Definition And Versus Or Search by Map Area Search by Subobject Search by Poly Property View or Change a Search Definition Remove a Search Definition Execute a Search Definition Search Results Window Replace the Icons and Item Records in the Navigation Window Print Search Results View a Report Template from the Saved Searches Window Search Items Search the Data Entry Form Audit Log

Contents

Running Saved Searches

1. Choose Search > Saved Searches.

500px

2. Select a saved search and click File:SfD02.png.

500px

If the Enter Search Prompt Values window displays, enter the search criteria values in the rows marked with a border and click Run.

500px

Using Item Filters

1. Choose Search and then an item filter.

500px

Applying a filter to the list:

500px

Changing the columns that display:

500px

500px

Using the Search Engine

1. Choose Search > Advanced Search...

500px

2. Select a search target.

500px

3. Select a search condition.

500px

OR will retrieve data that correspond to at least one of the defined criterion. AND will retrieve data that exactly correspond to all defined criteria.

4. Define the search criteria.
1. Click .
2. Select an attribute from the drop-down list.

If you select SQL from the attribute drop-down list, you can enter a valid SQL statement in the value field. See Principles for Building Searches for more information.

3. Select an operator from the drop-down list.
4. Enter a value for the attribute.
5. Click Run to retrieve the search results.

500px

Some attributes have buttons or widgets that you can click to select an option from a list of corresponding values. 500px

To add additional search criteria, click . To add a new condition to a criteria node, click OR/AND. To move a search criterion or criteria node, select the criterion or node and click to move it up or to move it down. To delete a search criterion or criteria node, select the criterion or node and click . 500px

Selecting the Prompt checkbox enables you to select other value options when running saved searches.

Saving a Search Definition

1. Enter a name.
2. Enter a description.
3. Click Save.

500px

Printing and Exporting Search Results

Search Results window

500px

• Replacing the item records in the Items pane

500px

On search results, you can also use the filter and the column picker.

Printing

1. Click .

You can also present your search results in a report if you have saved reports. See the Producing Reports Using IMSMANG for more information or contact your IMSMA administrator for help.

Exporting

1. Select the items to export.
2. Click .

500px

3. Select column headings.

500px

4. Open the destination directory on your computer.

500px

5. Give a name to your export file and click Save.

Your file is exported in comma separated value (CSV) format.

6. Close the Export Progress window.
7. Open your exported file in a spreadsheet.

Data Entry Form Audit

Data Entry Form Audit returns a list of every action taken on data entry forms.

500px