Searching for Data in IMSMANG

Revision as of 13:47, 5 February 2014 by Dionysia (talk | contribs)
Data search can be achieved by running saved searches, using specific item searches or the advanced search.

An item filter (land, activity, 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.


Contents

Running Saved Searches

  1. Choose Search > Saved Searches.
500px
  1. Select a saved search and click File:SfD02.png.
500px
Note.jpg 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
  1. Select a search target.
500px
  1. Select a search condition.
500px
Note.jpg 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.

  1. Define the search criteria.
    1. Click FieldTemplateIcon.png.
    2. Select an attribute from the drop-down list.
    3. Note.jpg 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.
    4. Select an operator from the drop-down list.
    5. Enter a value for the attribute.
    6. Click Run to retrieve the search results.
500px
Note.jpg Some attributes have buttons or widgets that you can click to select an option from a list of corresponding values.

500px

Note.jpg

To add additional search criteria, click FieldTemplateIcon.png. 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 UpBlueArrow.png to move it up or DownBlueArrow.png to move it down.

To delete a search criterion or criteria node, select the criterion or node and click EcksButton.png.

500px

Note.jpg 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


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

    Printing

    1. Click Print.png.
    Note.jpg 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 FieldReportExportIcon.png.
    3. 500px

    4. Select column headings.
    5. 500px

    6. Open the destination directory on your computer.
    7. 500px

    8. Give a name to your export file and click Save.
    Note.jpg Your file is exported in comma separated value (CSV) format.
    1. Close the Export Progress window.
    2. File:SfD23.png

    3. 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