Changes

The mine action information collected and stored in IMSMA^NG {{IMSMANG}} is useless without the ability to find it and use it to make operational decisions. That’s why IMSMA^NG {{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^NG, 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^NG {{IMSMANG}} search function has three primary purposes:

• *to navigate to data• *to display data on the map• *to prepare data for reports and analysis

Information managers can customise IMSMA^NG 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" | Accident || align="left" | Date of AccidentAccident Type| align="left" | QM || align="left" | Start DateEnd DateOrganisationResults|}</center>

==Building Simple Searches==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. In {{IMSMANG}} we refer to different types of functionality in the Search menu:*'''simple''' as in only one filter option may be usedBuilding searches *'''advanced''' as in IMSMA<sup>NG<more than one filter option may be used and complex critera using AND /sup> OR is a simple three-step process in possible to define*'''saved''' searches which are prepared by information managers determine:for usage by all users. 1Saved searches simplifies the user experience and ensures consistency of use by sharing identical searches with all users. The item Of course all users have the ability to search for2. The attributes of the item save searches which is a convenient way to re-use in the search3favourite searches. Whether all of the criteria must be met (AND) or any of the criteria must be met (OR)

Following these three stepsParticularly, users can build creating saved searches as simple or as complex as the examples below:facilitates access to programme data. Reporting is a key component of implementing and managing a mine action programme’s information workflow.

* find hazards The {{IMSMANG}} version 6.0 database is pre-populated with an ID saved searches developed by GICHD that may be customised to meet the specific needs of “MF-101”* find victims who are children and were injured in 2010* find progress reports about work done by XYZ organization on hazards in Province ABC between 2008 and 2010* find all clearances completed on hazards with antipersonnel minesthe mine action programme.

When a ==Simple Searches==__NOEDITSECTION__The simple search is designedoptions in the Search menu function exactly as all other filters in {{IMSMANG}}, it can be given a name and description and then saved for later usesee [[Search Items]]. Saving a ==Advanced Searches==__NOEDITSECTION__The different types of search saves the criteria of the search rather than the search results(e. This means that searches are automatically updated when additional data is added to the system, ensuring that searches return the most up-to-date datag. For example, an information manager can build a search called “Open Hazards” that finds 25 hazards with a status of “Open.” If 10 additional hazards subobject and geo area) are entered into the system with a status of “Opendescribed in [[Search by Subobject]] and [[Search by Map Area]],” the search would find 35 records when it is run againrespectively. In this way, searches are dynamically updated as data is added The possibility to use AND / OR and to specify the system, allowing information managers to assess data trends over time using consistent search criteria. Information managers can also use an existing search as a template to create other parts makes the Advanced searches by using the “Save as” functionalityvery flexible.

==Using Search ParametersPrompt==__NOEDITSECTION__Search parameters allow users to change one or more search criteria when running a searchWhen the prompt function is used in Advanced searches the re-usability and user-friendliness are greatly increased. For example, if a user wants to find all progress reports submitted by “XYZ” the "XYZ" organisation, they can build a search for “XYZ progress reports.” If and another user wants to have the same search but for progress reports submitted by “ABC” the "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 it is better to provide different values for the organisation when running the search. This makes save one search, for example, “Progress Reports by and prompt on Organisation,” available for multiple purposes. The ability to build dynamic searches allows information managers to customise search capabilities to meet the needs of various stakeholders within their programmes.

==SQL criteria==__NOEDITSECTION__While the {{note|Searches can include geospatial data as a parameter which allows IMSMANG}} search functionality is extremely flexible allowing searches on CDFs, customised option list values and links among items, there are cases where users may want to define a geospatial extent to run more complex searches that cannot be built using the Advanced search withininterface. For the purposes of searchingthese cases, records without geospatial data are defined as “outside” the geospatial extent{{IMSMANG}} includes a special SQL search criteria that allows information managers to use a SQL query as filter criteria.

==Building Complex Searches==While the IMSMA^NG search functionality is extremely robust—allowing searches on CDFs, customised option list values and links among items— there are some cases where users may want to run more complex searches that cannot be built using the standard search interface. For these cases, IMSMA^NG includes a special Structured Query Language (SQL) 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, PostgreSQL's SQL syntax and the IMSMA^NG {{IMSMANG}} data model and should only be undertaken by advanced users. Your [[Information Management Team | GICHD IM Advisor]] may support you in developing the SQL.

Using The SQL criteria, information managers can design complicated searches that can query may be complex with left joins and subqueries but may only have '''one''' output column which should be the item_guid of the Search target i.e if your search target is Land then only output column should be saved hazard_guid. {{note| We strongly recommended to develop and run by users test the SQL query with no understanding of a SQL tool before pasting it into the SQL criteria since {{IMSMANG}} does not provide SQLdebugging support. In this way, IMSMA^NG unleashes }} ==Saved Searches==__NOEDITSECTION__Saving a search saves the full power criteria of SQL criteriathe search rather than the search results. This means that searches are automatically updated when additional data is added to the system, joins and subqueries in an easyensuring that searches are returning results using the updated data.  ==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-run interfacedifferent 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 issues** e.g."Status Open with links to Activity or QM"

{{note|* It is recommended that information managers test their SQL in an external SQL editor prior These Saved searches should be seen as '''inspiration''' and should be adapted to using it within IMSMA^NG since IMSMA^NG does not provide SQL debugging supporteach mine action programme's processes.* Information managers can build complicated queries using SQL and combine them with other criteria, including parameters, to provide virtually unlimited search capabilities to IMSMA^NG users}}