Changes

Jump to: navigation, search

Searching for Data in IMSMANG

3,488 bytes removed, 11:42, 18 March 2019
no edit summary
{{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
|[[Access the Saved Searches WindowSearch Engine]]|Access the [[Filter Lists]]|[[Saved Searches Window]]
|[[Search Results Window]]
|[[Search Items|Search Items]]|[[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]]
}}
There are four different search functionalities in {{note| Selecting the ''Prompt'' checkbox enables you to select other value options when running saved searches.IMSMANG}}:* Search Items* Advanced Search* Saved Searches* Data Entry Form Audit
===Saving a The [[Search Definition===__NOEDITSECTION__#Enter Items]] a name.#Enter k.a description.#Click ''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 '''Saveone'''item.
:The [[Image:sfD16Advanced 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.pngSaved searches are also input to [[Producing Reports Using IMSMANG|500pxreports]].
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__====Search Results window====__NOEDITSECTION__ :It is possible to [[Image:sfD17.pngExport Search Result|500pxexport]] <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> {{noteSearch Results| You can also present your search results in a report if you have saved reports. See the [[Producing Reports Using IMSMANGprint]] for more information or contact your IMSMA administrator for help.}} ====Exporting====__NOEDITSECTION__<ol><li>Select the items to exportsearch result.</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}}
 [[Category:COONAA]]
6,632
edits

Navigation menu