Searching for Data in IMSMANG

From IMSMA Wiki
Revision as of 18:57, 28 February 2014 by Dionysia (talk | contribs)
Jump to: navigation, search
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 advanced search 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 advanced search can be saved in the Saved Searches.


Running Saved Searches

  1. Choose Search > Saved Searches.
500px
  1. Select a saved search and click ChartIcon.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
  1. Applying a filter to the list:
500px
  1. 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 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