Difference between revisions of "Searching for Data in IMSMANG"
From IMSMA Wiki
| Line 44: | Line 44: | ||
{| style="border:2px solid lightgray; float:center; margin:10px;" | {| style="border:2px solid lightgray; float:center; margin:10px;" | ||
| − | |align="left" style="padding: 5px 10px 5px 10px"|[[Image:bulb2.png|25px|Represents a tip or note for using IMSMA | + | |align="left" style="padding: 5px 10px 5px 10px"|[[Image:bulb2.png|25px|Represents a tip or note for using IMSMA.]] |
|align="left" style="padding: 5px 10px 5px 10px"| If the Enter Search Prompt Values window displays, enter the search criteria values in the rows marked with a border and click '''Run'''. | |align="left" style="padding: 5px 10px 5px 10px"| If the Enter Search Prompt Values window displays, enter the search criteria values in the rows marked with a border and click '''Run'''. | ||
|} | |} | ||
| Line 68: | Line 68: | ||
{| style="border:2px solid lightgray; float:center; margin:10px;" | {| style="border:2px solid lightgray; float:center; margin:10px;" | ||
| − | |align="left" style="padding: 5px 10px 5px 10px"|[[Image:bulb2.png|25px|Represents a tip or note for using IMSMA | + | |align="left" style="padding: 5px 10px 5px 10px"|[[Image:bulb2.png|25px|Represents a tip or note for using IMSMA.]] |
|align="left" style="padding: 5px 10px 5px 10px"| Field Report Audit returns a list of every action taken on data entry forms. | |align="left" style="padding: 5px 10px 5px 10px"| Field Report Audit returns a list of every action taken on data entry forms. | ||
|- | |- | ||
| Line 96: | Line 96: | ||
{| style="border:2px solid lightgray; float:center; margin:10px;" | {| style="border:2px solid lightgray; float:center; margin:10px;" | ||
| − | |align="left" style="padding: 5px 10px 5px 10px"|[[Image:bulb2.png|25px|Represents a tip or note for using IMSMA | + | |align="left" style="padding: 5px 10px 5px 10px"|[[Image:bulb2.png|25px|Represents a tip or note for using IMSMA.]] |
|align="left" style="padding: 5px 10px 5px 10px"| ANY will retrieve data that correspond to at least one of the defined criterion. | |align="left" style="padding: 5px 10px 5px 10px"| ANY will retrieve data that correspond to at least one of the defined criterion. | ||
| Line 116: | Line 116: | ||
{| style="border:2px solid lightgray; float:center; margin:10px;" | {| style="border:2px solid lightgray; float:center; margin:10px;" | ||
| − | |align="left" style="padding: 5px 10px 5px 10px"|[[Image:bulb2.png|25px|Represents a tip or note for using IMSMA | + | |align="left" style="padding: 5px 10px 5px 10px"|[[Image:bulb2.png|25px|Represents a tip or note for using IMSMA.]] |
|align="left" style="padding: 5px 10px 5px 10px"| Some attributes have ''buttons'' or ''widgets'' that you can click to select an option from a list of corresponding values. | |align="left" style="padding: 5px 10px 5px 10px"| Some attributes have ''buttons'' or ''widgets'' that you can click to select an option from a list of corresponding values. | ||
|- | |- | ||
| Line 123: | Line 123: | ||
{| style="border:2px solid lightgray; float:center; margin:10px;" | {| style="border:2px solid lightgray; float:center; margin:10px;" | ||
| − | |align="left" style="padding: 5px 10px 5px 10px"|[[Image:bulb2.png|25px|Represents a tip or note for using IMSMA | + | |align="left" style="padding: 5px 10px 5px 10px"|[[Image:bulb2.png|25px|Represents a tip or note for using IMSMA.]] |
|align="left" style="padding: 5px 10px 5px 10px"| To add additional search criteria, | |align="left" style="padding: 5px 10px 5px 10px"| To add additional search criteria, | ||
#Click [[Image:FieldTemplateIcon.png]]. | #Click [[Image:FieldTemplateIcon.png]]. | ||
| Line 149: | Line 149: | ||
{| style="border:2px solid lightgray; float:center; margin:10px;" | {| style="border:2px solid lightgray; float:center; margin:10px;" | ||
| − | |align="left" style="padding: 5px 10px 5px 10px"|[[Image:bulb2.png|25px|Represents a tip or note for using IMSMA | + | |align="left" style="padding: 5px 10px 5px 10px"|[[Image:bulb2.png|25px|Represents a tip or note for using IMSMA.]] |
|align="left" style="padding: 5px 10px 5px 10px"| Selecting the ''Prompt'' checkbox enables you to select other value options when running saved searches. | |align="left" style="padding: 5px 10px 5px 10px"| Selecting the ''Prompt'' checkbox enables you to select other value options when running saved searches. | ||
|} | |} | ||
| Line 171: | Line 171: | ||
{| style="border:2px solid lightgray; float:center; margin:10px;" | {| style="border:2px solid lightgray; float:center; margin:10px;" | ||
| − | |align="left" style="padding: 5px 10px 5px 10px"|[[Image:bulb2.png|25px|Represents a tip or note for using IMSMA | + | |align="left" style="padding: 5px 10px 5px 10px"|[[Image:bulb2.png|25px|Represents a tip or note for using IMSMA.]] |
|align="left" style="padding: 5px 10px 5px 10px"| On search results, you can also use the filter and the column picker. | |align="left" style="padding: 5px 10px 5px 10px"| On search results, you can also use the filter and the column picker. | ||
|} | |} | ||
| Line 181: | Line 181: | ||
{| style="border:2px solid lightgray; float:center; margin:10px;" | {| style="border:2px solid lightgray; float:center; margin:10px;" | ||
| − | |align="left" style="padding: 5px 10px 5px 10px"|[[Image:bulb2.png|25px|Represents a tip or note for using IMSMA | + | |align="left" style="padding: 5px 10px 5px 10px"|[[Image:bulb2.png|25px|Represents a tip or note for using IMSMA.]] |
|align="left" style="padding: 5px 10px 5px 10px"| You can also present your search results in a report if you have saved reports. See the ''Producing Reports Quick Reference Guide'' for more information or contact your local system administrator for help. | |align="left" style="padding: 5px 10px 5px 10px"| You can also present your search results in a report if you have saved reports. See the ''Producing Reports Quick Reference Guide'' for more information or contact your local system administrator for help. | ||
|} | |} | ||
| Line 204: | Line 204: | ||
{| style="border:2px solid lightgray; float:center; margin:10px;" | {| style="border:2px solid lightgray; float:center; margin:10px;" | ||
| − | |align="left" style="padding: 5px 10px 5px 10px"|[[Image:bulb2.png|25px|Represents a tip or note for using IMSMA | + | |align="left" style="padding: 5px 10px 5px 10px"|[[Image:bulb2.png|25px|Represents a tip or note for using IMSMA.]] |
|align="left" style="padding: 5px 10px 5px 10px"| Your file is exported in comma separated value (CSV) format. | |align="left" style="padding: 5px 10px 5px 10px"| Your file is exported in comma separated value (CSV) format. | ||
|} | |} | ||
Revision as of 15:23, 21 March 2013
Data search can be achieved by running saved searches, using item filters or the search engine.
An item filter (hazard, hazard reduction, 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 (hazard reductions linked to a hazard, 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 search manager.
Running Saved Searches
- Choose Search > Search Manager.
- Select a saved search and click File:SfD02.png.
| Represents a tip or note for using IMSMA. | If the Enter Search Prompt Values window displays, enter the search criteria values in the rows marked with a border and click Run. |
Using Item Filters
- Choose Search and then an item filter.
Applying a filter to the list
Changing the columns that display
| Represents a tip or note for using IMSMA. | Field Report Audit returns a list of every action taken on data entry forms. |
| 500px | |
Using the Search Engine
- Choose Search > Search...
- Select a search target.
- Select a search condition.
| Represents a tip or note for using IMSMA. | ANY will retrieve data that correspond to at least one of the defined criterion.
ALL will retrieve data that exactly correspond to all defined criteria. |
- Define the search criteria.
- Click
. - Select an attribute from the drop-down list.
- Select an operator from the drop-down list.
- Enter a value for the attribute.
- Click Run to retrieve the search results.
| Represents a tip or note for using IMSMA. | Some attributes have buttons or widgets that you can click to select an option from a list of corresponding values. |
| 500px | |
| Represents a tip or note for using IMSMA. | To add additional search criteria,
To add a new condition to a criteria node,
To move a search criterion or criteria node,
To delete a search criterion or criteria node,
|
| 500px | |
Saving a Search Definition
- Enter a name.
- Enter a description.
- Click Save.
| Represents a tip or note for using IMSMA. | Selecting the Prompt checkbox enables you to select other value options when running saved searches. |
Printing and Exporting Search Results
Search Results window
- Replacing the item records in the Items pane
- Adding the item records to the Items pane
| Represents a tip or note for using IMSMA. | On search results, you can also use the filter and the column picker. |
Printing
- Click
.
| Represents a tip or note for using IMSMA. | You can also present your search results in a report if you have saved reports. See the Producing Reports Quick Reference Guide for more information or contact your local system administrator for help. |
Exporting
- Select the items to export.
- Click File:ExportReportIcon.png.
- Select column headings.
- Open the destination directory on your computer.
- Give a name to your export file and click Open.
| Represents a tip or note for using IMSMA. | Your file is exported in comma separated value (CSV) format. |
- Close the Export Progress window.
- Open your exported file in a spreadsheet.
