Changes

Jump to: navigation, search

Building Searches

2,785 bytes removed, 15:22, 29 May 2017
no edit summary
{{TOC right}}
__NOEDITSECTION__
The mine action information collected and stored in IMSMA<sup>NG</sup> {{IMSMANG}} is useless without the ability to find it and use it to make operational decisions. That’s why IMSMA<sup>NG</sup> {{IMSMANG}} includes a robust data search mechanism that provides an easy-to-use, multilevel interface for building and running searches. As with other parts of IMSMA<sup>NG</sup>, the search functionality is divided into a customisation mode, where information managers can prepare simple or complex searches, and an execution mode where data entry personnel can run prebuilt searches. This simplifies the user experience and ensures consistency of use by sharing identical searches with all users. The IMSMA<sup>NG</sup> {{IMSMANG}} search function has three primary purposes:
*to navigate to data
*to prepare data for reports and analysis
Information managers can customise IMSMA<sup>NG</sup> The navigation and map display searches for each of these purposes are typically designed to meet the specific needs find a single record or a set of the programmerecords. Particularly, customizing These searches are generally simpler than the search functionality other kinds of searches and are designed to facilitate access return records that users can browse through to programme find the necessary data and reporting is a key component of implementing and managing a programme’s information workflow.
<center>{| class="wikitable" width="750"|-| align="center" colspan="4" | '''Table 14. Options for Using Searches'''|-| width="245pt" | '''Option''' | width="155pt" | '''Use or purpose'''| width="245pt" | '''Example criteria'''| width="155pt" | '''Example parameters'''|-| align="left" | '''Navigation and map display''' || align="left" | Search for items by a specific ID | align="left" | Find all hazards with a local ID that includes = “MF-001” | align="left" | Set the local ID as a parameter to be supplied when the search is run|-| align="left" rowspan="2" | These The reporting searches are typically designed more complicated than navigation searches since they are intended to find a single record or return a set of recordsto populate a report directly without any additional user interaction. These searches are generally simpler than the other kinds can also be saved and run independently of searches reports and are designed to return records that users can browse through to find the necessary used for browsing data. || align="left" | Search for items by type| align="left" | Find all hazards with a mine action are type = “Minefield”| align="left" | Mine Action Area Type|-| align="left" | Search for items by date| align="left" | Find all hazard reductions between January 1 and February 1| align="left" | The date range|-| align="left" rowspan="4" | '''Reporting and data quality analysis'''
Reporting searches are typically more complicated than navigation searches since they are intended to return a set of records to populate a report directly without any additional user interaction. These searches can also be saved and run independently of reports and used for browsing data. Data quality analysis searches help identify possible data problems and ensure that mine action programme-specific workflow steps are being followed. These searches can be used to help protect data integrity.| align="left" | Report on clearance efforts | align="left" | Find all hazard reductions where the type = “Progress Report” and the status = “Completed” and the dates are between January 1 and February 1| align="left" | The date range|-| align="left" | Report on hazards cleared by an organisation| align="left" | Find all hazards that are linked to hazard reductions whose type = “Clearance” and the organisation = “XYZ Org”| align="left" | Mine Action Area Type|-| align="left" | Search for all hazards with AP mines| align="left" colspan="2" | Find all active hazards with antipersonnel mines or that have clearances linked to them that have found antipersonnel mines|-| align="left" | Data quality checks| align="left" colspan="2" | Find all hazards whose status is “Worked On” with no active hazard reductions
Find In {{IMSMANG}} we refer to different types of functionality in the Search menu:*'''simple''' as in only one filter option may be used*'''advanced''' as in more than one filter option may be used and complex critera using AND / OR is possible to define*'''saved''' searches which are prepared by information managers for usage by all clearances that are not linked to a hazardusers.
Find Saved searches simplifies the user experience and ensures consistency of use by sharing identical searches with all users. Of course all victims with no link users have the ability to save searches which is a convenient way to accident|}</center>re-use favourite searches.
Particularly, creating saved searches facilitates access to programme data. Reporting is a key component of implementing and managing a mine action programme’s information workflow. The {{IMSMANG}} version 6.0 database is pre-populated with saved searches developed by GICHD that may be customised to meet the specific needs of the mine action programme. ==Building Simple Searches==__NOEDITSECTION__Building searches The simple search options in IMSMA<sup>NG</sup> is a simple three-step process the Search menu function exactly as all other filters in which information managers determine:{{IMSMANG}}, see [[Search Items]].
#==Advanced Searches==__NOEDITSECTION__The item to different types of search for#criteria (e.g. subobject and geo area) are described in [[Search by Subobject]] and [[Search by Map Area]], respectively. The attributes of the item possibility to use in AND / OR and to specify the search#Whether all of parts makes the criteria must be met (AND) or any of the criteria must be met (OR)Advanced searches very flexible.
Following these three steps==Using Prompt==__NOEDITSECTION__When the prompt function is used in Advanced searches the re-usability and user-friendliness are greatly increased. For example, users can build searches as simple or as complex as if a user wants to find all progress reports submitted by the "XYZ" organisation and another user wants to have the same search but for the examples below:"ABC organisation, it is better to save one search and prompt on Organisation.
*find hazards with an ID of “MF-101”==SQL criteria==__NOEDITSECTION__*find victims who are children and were injured in 2010*find progress reports about work done by XYZ organization While the {{IMSMANG}} search functionality is extremely flexible allowing searches on hazards in Province ABC between 2008 CDFs, customised option list values and 2010*find all clearances completed on hazards with antipersonnel mineslinks among items, there are cases where users may want to run more complex searches that cannot be built using the Advanced search interface. For these cases, {{IMSMANG}} includes a special SQL search criteria that allows information managers to use a SQL query as filter criteria.
When a search is designed, it can be given a name and description and then saved for later use. Saving a search saves the Creating searches using SQL criteria of the search rather than the search results. This means that searches are automatically updated when additional data is added to the system, ensuring that searches return the most up-to-date data. For example, an information manager can build requires a search called “Open Hazards” that finds 25 hazards with a status detailed understanding of “Open.” If 10 additional hazards are entered into PostgreSQL's SQL syntax and the system with a status of “Open,” the search would find 35 records when it is run again. In this way, searches are dynamically updated as data is added to the system, allowing information managers to assess {{IMSMANG}} data trends over time using consistent search criteriamodel. Your [[Information managers can also use an existing search as a template to create other searches by using Management Team | GICHD IM Advisor]] may support you in developing the “Save as” functionalitySQL.
==Using Search Parameters==Search parameters allow users to change one or more search To use SQL criteria when running a search. For example, if a user wants to find all progress reports submitted by “XYZ” organisation, they can build simply provide a search for “XYZ progress reports.” If another user wants to search for progress reports submitted by “ABC” organisation, they can build another search for “ABC Progress Reports.” Alternatively, an information manager can build one search with a parameter for “Organisation” that allows users to provide different values for the organisation when running the search. This makes one search, for example, “Progress Reports by Organisation,” available for multiple purposes. The ability to build dynamic searches allows information managers to customise search capabilities to meet valid SQL statement in the needs of various stakeholders within their programmes.following format:
{{note|Searches can include geospatial data as a parameter which allows users to define a geospatial extent to search withinSELECT [item_guid] FROM [item_table] WHERE... For the purposes of searching, records without geospatial data are defined as “outside” the geospatial extent}}
==Building Complex Searches==While the IMSMA<sup>NG</sup> search functionality is extremely robust—allowing searches on CDFs, customised option list values The SQL query may be complex with left joins and links among items— there are some cases where users subqueries but may want to run more complex searches that cannot only have '''one''' output column which should be built using the standard search interfaceitem_guid of the Search target i. For these cases, IMSMA<sup>NG</sup> includes a special Structured Query Language (SQL) e if your search functionality that allows information managers to provide SQL syntax for executing searches. Creating searches using SQL criteria requires a detailed understanding of relational databases, SQL and the IMSMA<sup>NG</sup> data model and target is Land then only output column should only be undertaken by advanced usershazard_guid.
To use {{note| We strongly recommended to develop and test the SQL query with a SQL tool before pasting it into the SQL criteria, simply since {{IMSMANG}} does not provide SQL debugging support. }} ==Saved Searches==__NOEDITSECTION__Saving a valid SQL statement in search saves the criteria of the search rather than the search results. This means that searches are automatically updated when additional data is added to the system, ensuring that searches are returning results using the following format:updated data.
SELECT [item_guid] FROM [item_table] WHERE==Inspiration Saved Searches==__NOEDITSECTION__{{IMSMANG}} version 6.0 database is pre-populated with 40 different data quality Saved searches of different kinds:* suspected duplicates** e.g "Victim Duplicate Name & Date Of Birth"* items without any geographical data** e.g. "Accident Without Geodata"* items that do not have any links to other items** e.g. "Assistance Without Links To Victim"* items which are assigned to different locations** e.g."Land & Activity Not Same Location"* task as Search target** e.g."Land Included In More Than One Task"* possible mine action process quality issuesFor example, SELECT hazreduc_guid FROM hazreduc WHERE hazreduc_localID =’ÇL-001’** e.g. "Status Open with links to Activity or QM"
Using SQL criteria, information managers can design complicated {{note | These Saved searches that can then should be saved seen as '''inspiration''' and run by users with no understanding of SQL. In this way, IMSMA<sup>NG</sup> unleashes the full power of SQL criteria, joins and subqueries in an easy-should be adapted to-run interfaceeach mine action programme's processes.}}
{{note|* It is recommended that information managers test their SQL in an external SQL editor prior to using it within NavBox IMSMA<sup>NG</sup> since IMSMA<sup>NG</sup> does not provide SQL debugging support.* Information managers can build complicated queries using SQL and combine them with other criteria, including parameters, to provide virtually unlimited search capabilities to IMSMA<sup>NG</sup> usersAdministration}}
{{HowTo's}}[[Category:NAA]]
6,632
edits

Navigation menu