Searching for Data in IMSMANG

From IMSMA Wiki
Revision as of 18:57, 28 February 2014 by Dionysia (talk | contribs)
Jump to navigation Jump to 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.


How To

{{#if:Access the Saved Searches Window |

|}}{{#if:Search Results Window |

|}}{{#if:Search Items |

|}}{{#if:Search the Data Entry Form Audit Log |

|}}{{#if:|

  • {{{5}}}|}}{{#if:|
  • {{{6}}}|}}{{#if:|
  • {{{7}}}|}}{{#if:|
  • {{{8}}}|}}{{#if:|
  • {{{9}}}|}}{{#if:|
  • {{{10}}}|}}{{#if:|
  • {{{11}}}|}}{{#if:|
  • {{{12}}}|}}{{#if:|
  • {{{13}}}|}}{{#if:|
  • {{{14}}}|}}{{#if:|
  • {{{15}}}|}}{{#if:|
  • {{{16}}}|}}{{#if:|
  • {{{17}}}|}}{{#if:|
  • {{{18}}}|}}{{#if:|
  • {{{19}}}|}}{{#if:|
  • {{{20}}}|}}{{#if:|
  • {{{21}}}|}}{{#if:|
  • {{{22}}}|}}{{#if:|
  • {{{23}}}|}}{{#if:|
  • {{{24}}}|}}{{#if:|
  • {{{25}}}|}}{{#if:|
  • {{{26}}}|}}{{#if:|
  • {{{27}}}|}}{{#if:|
  • {{{28}}}|}}{{#if:|
  • {{{29}}}|}}{{#if:|
  • {{{30}}}|}}{{#if:|
  • {{{31}}}|}}{{#if:|
  • {{{32}}}|}}{{#if:|
  • {{{33}}}|}}{{#if:|
  • {{{34}}}|}}{{#if:|
  • {{{35}}}|}}{{#if:|
  • {{{36}}}|}}{{#if:|
  • {{{37}}}|}}{{#if:|
  • {{{38}}}|}}{{#if:|
  • {{{39}}}|}}{{#if:|
  • {{{40}}}|}}{{#if:|
  • {{{41}}}|}}{{#if:|
  • {{{42}}}|}}{{#if:|
  • {{{43}}}|}}{{#if:|
  • {{{44}}}|}}{{#if:|
  • {{{45}}}|}}{{#if:|
  • {{{46}}}|}}{{#if:|
  • {{{47}}}|}}{{#if:|
  • {{{48}}}|}}{{#if:|
  • {{{49}}}|}}{{#if:|
  • {{{50}}}|}}

Running Saved Searches

  1. Choose Search > Saved Searches.
File:SfD01.png
  1. Select a saved search and click .
File:SfD03.png
If the Enter Search Prompt Values window displays, enter the search criteria values in the rows marked with a border and click Run.
File:SfD04.png

Using Item Filters

  1. Choose Search and then an item filter.
File:SfD05.png
  1. Applying a filter to the list:
File:SfD06.png
  1. Changing the columns that display:
File:SfD07.png
File:SfD08.png


Using the Search Engine

  1. Choose Search > Advanced Search...
File:SfD10.png
  1. Select a search target.
File:SfD11.png
  1. Select a search condition.
File:SfD12.png
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 .
    2. Select an attribute from the drop-down list.
      3. 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.
    3. Select an operator from the drop-down list.
    4. Enter a value for the attribute.
    5. Click Run to retrieve the search results.
File:SfD13.png
Some attributes have buttons or widgets that you can click to select an option from a list of corresponding values.

File:SfD14.png

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 .

File:SfD15.png

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.
File:SfD16.png


Printing and Exporting Search Results

Search Results window

File:SfD17.png
    • Replacing the item records in the Items pane
File:SfD18.png


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 .
    3. File:SfD20.png
  3. Select column headings.
    4. File:SfD21.png
  4. Open the destination directory on your computer.
    5. File:SfD22.png
  5. Give a name to your export file and click Save.
Your file is exported in comma separated value (CSV) format.
  1. Close the Export Progress window.
    2. File:SfD23.png
  2. 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.

File:SfD09.png


{{#switch:|subgroup|child=|none=|#default=

{{#if:|<th scope="col" style="border-left:2px solid #fdfdfd;width:100%;|}}{{#if:|{{#if:Using IMSMANG|}}}}{{#if: Starting and Stopping IMSMANG · Viewing and Browsing in IMSMANG · Searching for Data in IMSMANG · Using Data Entry Forms · Reconciling and Approving Data in IMSMANG · Importing and Exporting Data with IMSMANG · Using the Tasking Tool in IMSMANG · Producing Reports Using IMSMANG · Printing the Map in IMSMANG · Using the Impact Scoring Tool in IMSMANG · Using the IMSMANG Help Menu · Setting User Preferences · Get started with IMSMA · Getting IMSMA systems Installation Package |{{#if:Using IMSMANG|}}{{#if:|}}{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|}}}}{{#if:|{{#if:Using IMSMANG Starting and Stopping IMSMANG · Viewing and Browsing in IMSMANG · Searching for Data in IMSMANG · Using Data Entry Forms · Reconciling and Approving Data in IMSMANG · Importing and Exporting Data with IMSMANG · Using the Tasking Tool in IMSMANG · Producing Reports Using IMSMANG · Printing the Map in IMSMANG · Using the Impact Scoring Tool in IMSMANG · Using the IMSMANG Help Menu · Setting User Preferences · Get started with IMSMA · Getting IMSMA systems Installation Package |}}{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:Using IMSMANG Starting and Stopping IMSMANG · Viewing and Browsing in IMSMANG · Searching for Data in IMSMANG · Using Data Entry Forms · Reconciling and Approving Data in IMSMANG · Importing and Exporting Data with IMSMANG · Using the Tasking Tool in IMSMANG · Producing Reports Using IMSMANG · Printing the Map in IMSMANG · Using the Impact Scoring Tool in IMSMANG · Using the IMSMANG Help Menu · Setting User Preferences · Get started with IMSMA · Getting IMSMA systems Installation Package |}}{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:Using IMSMANG Starting and Stopping IMSMANG · Viewing and Browsing in IMSMANG · Searching for Data in IMSMANG · Using Data Entry Forms · Reconciling and Approving Data in IMSMANG · Importing and Exporting Data with IMSMANG · Using the Tasking Tool in IMSMANG · Producing Reports Using IMSMANG · Printing the Map in IMSMANG · Using the Impact Scoring Tool in IMSMANG · Using the IMSMANG Help Menu · Setting User Preferences · Get started with IMSMA · Getting IMSMA systems Installation Package |}}}}
}}<table cellspacing="0" class="nowraplinks hlist {{#if:Using IMSMANG|{{#switch:autocollapse|plain|off=|#default=collapsible {{#if:autocollapse|autocollapse|autocollapse}}}}}} {{#switch:|subgroup|child|none=navbox-subgroup" style="border-spacing:0;;|#default=navbox-inner" style="border-spacing:0;background:transparent;color:inherit}};;">{{#if:Using IMSMANG|
{{{above}}}
{{{imageleft}}}
{{{group1}}}
{{{image}}}
{{{group2}}}
{{{list2}}}
{{{group3}}}
{{{list3}}}
{{{group4}}}
{{{list4}}}
{{{group5}}}
{{{list5}}}
{{{group6}}}
{{{list6}}}
{{{group7}}}
{{{list7}}}
{{{group8}}}
{{{list8}}}
{{{group9}}}
{{{list9}}}
{{{group10}}}
{{{list10}}}
{{{group11}}}
{{{list11}}}
{{{group12}}}
{{{list12}}}
{{{group13}}}
{{{list13}}}
{{{group14}}}
{{{list14}}}
{{{group15}}}
{{{list15}}}
{{{group16}}}
{{{list16}}}
{{{group17}}}
{{{list17}}}
{{{group18}}}
{{{list18}}}
{{{group19}}}
{{{list19}}}
{{{group20}}}
{{{list20}}}
{{{below}}}

{{#switch:|subgroup|child=

|none=|#default=}}{{#ifeq:|Template|{{#ifeq:|child||{{#ifeq:|subgroup||{{#switch:searching for data in imsmang 
|doc
|sandbox
|testcases =
|#default = {{#switch:hlist
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}

Retrieved from "http://mwiki.gichd.org/IM/index.php?title=Searching_for_Data_in_IMSMANG&oldid=14454"