Difference between revisions of "Searching for Data in IMSMANG"

From IMSMA Wiki
Jump to: navigation, search
 
(29 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{Reference guide header|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''.
 
}}
 
 
__FORCETOC__
 
{{TOC right}}
 
 
 
{{HowTo's
 
{{HowTo's
|[[Access the Saved Searches Window|Access the Saved Searches Window]]
+
| [[Search Engine]]
 +
|[[Filter Lists]]
 +
|[[Saved Searches Window]]
 
|[[Search Results Window]]
 
|[[Search Results Window]]
|[[Search Items|Search Items]]
+
|[[Search the Data Entry Form Audit Log| Data Entry Form Audit Log]]
|[[Search the Data Entry Form Audit Log|Search the Data Entry Form Audit Log]]
 
}}
 
 
 
===Running Saved Searches===__NOEDITSECTION__
 
<ol>
 
<li>Choose '''Search''' > '''Saved Searches'''.</li>
 
</ol>
 
:[[Image:sfD01.png|500px]]
 
 
 
<ol start="2">
 
<li>Select a saved search and click [[Image:sfD02.png]].</li>
 
</ol>
 
 
 
:[[Image:sfD03.png|500px]]
 
 
 
{{note| If the Enter Search Prompt Values window displays, enter the search criteria values in the rows marked with a border and click '''Run'''.}}
 
 
 
:[[Image:sfD04.png|500px]]
 
 
 
===Using Item Filters===__NOEDITSECTION__
 
<ol>
 
<li>Choose '''Search''' and then an item filter.</li>
 
</ol>
 
 
 
:[[Image:sfD05.png|500px]]
 
 
 
<ol start="2">
 
<li>Applying a filter to the list:</li>
 
</ol>
 
 
 
:[[Image:sfD06.png|500px]]
 
 
 
<ol start="3">
 
<li>Changing the columns that display:</li>
 
</ol>
 
 
 
:[[Image:sfD07.png|500px]]
 
 
 
:[[Image:sfD08.png|500px]]
 
 
 
 
 
===Using the Search Engine===__NOEDITSECTION__
 
 
 
<ol>
 
<li>Choose '''Search''' > '''Advanced Search'''...</li>
 
</ol>
 
 
 
:[[Image:sfD10.png|500px]]
 
 
 
<ol start="2">
 
<li>Select a search target.</li>
 
</ol>
 
 
 
:[[Image:sfD11.png|500px]]
 
 
 
<ol start="3">
 
<li>Select a search condition.</li>
 
</ol>
 
 
 
:[[Image:sfD12.png||500px]]
 
 
 
{{note| 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.}}
 
 
 
<ol start="4">
 
<li>Define the search criteria.</li>
 
<ol type="a">
 
<li>Click [[Image:FieldTemplateIcon.png]].</li>
 
<li>Select an attribute from the drop-down list.</li>
 
{{note| If you select SQL from the attribute drop-down list, you can enter a valid SQL statement in the value field. See [[Building Searches#SQL criteria|Building Searches]] for more information.}}
 
<li>Select an operator from the drop-down list.</li>
 
<li>Enter a value for the attribute.</li>
 
<li>Click '''Run''' to retrieve the search results.</li>
 
</ol>
 
</ol>
 
 
 
:[[Image:sfD13.png|500px]]
 
 
 
{{note| Some attributes have ''buttons'' or ''widgets'' that you can click to select an option from a list of corresponding values.
 
 
 
[[Image:sfD14.png|500px]]
 
}}
 
 
 
{{note|
 
To add additional search criteria, click [[Image: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 [[Image:UpBlueArrow.png]] to move it up or [[Image:DownBlueArrow.png]] to move it down.
 
 
 
To delete a search criterion or criteria node, select the criterion or node and click [[Image:EcksButton.png]].
 
 
 
[[Image:sfD15.png|500px]]
 
 
}}
 
}}
  
{{note| Selecting the ''Prompt'' checkbox enables you to select other value options when running saved searches.}}
+
There are four different search functionalities in {{IMSMANG}}:
 +
* Search Items
 +
* Advanced Search
 +
* Saved Searches
 +
* Data Entry Form Audit
  
===Saving a Search Definition===__NOEDITSECTION__
+
The [[Search Items]] a.k.a. ''Simple search'' are found in the ''Search'' menu and as indicated by its nick-name with this search functionality it is only possible to use '''one''' criterion and '''one''' item.
#Enter a name.
 
#Enter a description.
 
#Click '''Save'''.
 
  
:[[Image:sfD16.png|500px]]
+
The [[Advanced Search]] functionality allows for search definitions that are built with more than one criterion, AND/OR and linked items. The criteria may also be grouped into advanced AND/OR groups. It is also possible to use SQL statement, geographical search and subobjects (e.g. which Ordnance was reported).
 +
 +
[[Saved Searches Window|Saved Searches]] are defined with the ''Advanced search'' functionality and are saved in the database for later use. This enables users to create search definitions which may used by all users. Saved searches are also input to [[Producing Reports Using IMSMANG|reports]].
  
 +
The [[Search the Data Entry Form Audit Log|Data Entry Form Audit]] is a dedicated search functionality for Data entry form where it is possible to search by action, date, Id and template.
 +
[[Image:Search menu.png|500px|center]]
  
===Printing and Exporting Search Results===__NOEDITSECTION__
+
It is possible to [[Export Search Result|export]] and [[Print Search Results|print]] the search result.
====Search Results window====__NOEDITSECTION__
 
 
 
:[[Image:sfD17.png|500px]]
 
 
 
<ol>
 
*Replacing the item records in the Items pane
 
</ol>
 
 
 
:[[Image:sfD18.png|500px]]
 
 
 
 
 
{{note| On search results, you can also use the filter and the column picker.}}
 
 
 
====Printing====__NOEDITSECTION__
 
<ol>
 
<li>Click [[Image:Print.png]].</li>
 
</ol>
 
 
 
{{note| 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====__NOEDITSECTION__
 
<ol>
 
<li>Select the items to export.</li>
 
<li>Click [[Image:FieldReportExportIcon.png]].</li>
 
 
 
[[Image:sfD20.png|500px]]
 
 
 
<li>Select column headings.</li>
 
 
 
[[Image:sfD21.png|500px]]
 
 
 
<li>Open the destination directory on your computer.</li>
 
 
 
[[Image:sfD22.png|500px]]
 
 
 
<li>Give a name to your export file and click '''Save'''.</li>
 
</ol>
 
 
 
{{note| Your file is exported in comma separated value (CSV) format.}}
 
 
 
<ol start="6">
 
<li>Close the Export Progress window.</li>
 
[[Image:sfD23.png]]
 
<li>Open your exported file in a spreadsheet.</li>
 
</ol>
 
 
 
====Data Entry Form Audit====__NOEDITSECTION__
 
 
 
Data Entry Form Audit returns a list of every action taken on data entry forms.
 
 
 
[[Image:sfD09.png|500px]]
 
 
 
  
 +
{{New_6.0 | In V6.0 43 data quality ''Saved searches'' are included with the installation. See [[Saved Searches 6.0]] for a short description of the searches.}}
 
{{NavBox Working with IMSMA}}
 
{{NavBox Working with IMSMA}}
 
+
[[Category:NAA]]
[[Category:COO]]
 

Latest revision as of 10:42, 18 March 2019

There are four different search functionalities in IMSMANG:

  • Search Items
  • Advanced Search
  • Saved Searches
  • Data Entry Form Audit

The Search Items a.k.a. Simple search are found in the Search menu and as indicated by its nick-name with this search functionality it is only possible to use one criterion and one item.

The Advanced Search functionality allows for search definitions that are built with more than one criterion, AND/OR and linked items. The criteria may also be grouped into advanced AND/OR groups. It is also possible to use SQL statement, geographical search and subobjects (e.g. which Ordnance was reported).

Saved Searches are defined with the Advanced search functionality and are saved in the database for later use. This enables users to create search definitions which may used by all users. Saved searches are also input to reports.

The Data Entry Form Audit is a dedicated search functionality for Data entry form where it is possible to search by action, date, Id and template.

Search menu.png

It is possible to export and print the search result.

New 6.0.png In V6.0 43 data quality Saved searches are included with the installation. See Saved Searches 6.0 for a short description of the searches.