Changes

Jump to: navigation, search

Building Searches

2,911 bytes removed, 16:22, 29 May 2017
no edit summary
*to prepare data for reports and analysis
The search functionality is navigation and map display searches are typically designed to find a single record or a set of different types:*simple as in only one filter option may be used*advanced as in more records. These searches are generally simpler than one filter option may be used the other kinds of searches and complex critera using AND / OR is possible are designed to define*saved searches which are prepared by information managers for usage by all return records that userscan browse through to find the necessary data.
Saved The reporting searches simplifies the 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 experience and ensures consistency of use by sharing identical searches with all usersinteraction. Of cause all users have the possibility to saved These searches which is a convenience so they may can also be re-saved and run independently of reports and usedfor browsing data.
Particularly, creating saved Data quality analysis searches facilitate access to programme help identify possible data problems and reporting is a key component of implementing and managing a ensure that mine action programme’s information programme-specific workflowsteps are being followed. These searches can be used to help protect data integrity.
The In {{IMSMANG}} version 6.0 database 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 pre-populated with possible to define*'''saved ''' searches developed which are prepared by GICHD that may be customised to meet the specific needs of the mine action programmeinformation managers for usage by all users.
<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 Saved searches simplifies the user experience and map display''' || align="left" | Search for items ensures consistency of use by a specific ID | align="left" | Find sharing identical searches with all users. Of course all lands with a local ID that includes = “MF-001” | align="left" | Set users have the local ID as ability to save searches which is a parameter convenient way to be supplied when the search is run|re-| align="left" rowspan="2" | These searches are typically designed to find a single record or a set of records. These searches are generally simpler than the other kinds of use favourite searches and are designed to return records that users can browse through to find the necessary data. || align="left" | Search for items by type| align="left" | Find all lands with a mine action are type = “Minefield”| align="left" | Mine Action Area Type|-| align="left" | Search for items by date| align="left" | Find all activities between January 1 and February 1| align="left" | The date range|-| align="left" rowspan="4" | '''Reporting and data quality analysis'''
Reporting Particularly, creating saved searches are typically more complicated than navigation searches since they are intended facilitates access to return programme data. Reporting is a set key component of records to populate implementing and managing 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 programme-specific mine action programme’s information 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 activities 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 lands cleared by an organisation| align="left" | Find all lands that are linked to activities whose type = “Clearance” and the organisation = “XYZ Org”| align="left" | Mine Action Area Type|-| align="left" | Search for all lands with AP mines| align="left" colspan="2" | Find all active lands 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 lands whose status is “Worked On” with no active activities
Find all clearances The {{IMSMANG}} version 6.0 database is pre-populated with saved searches developed by GICHD that are not linked may be customised to a landmeet the specific needs of the mine action programme.
Find ==Simple Searches==__NOEDITSECTION__The simple search options in the Search menu function exactly as all victims with no link to accidentother filters in {{IMSMANG}}, see [[Search Items]]. |}==Advanced Searches==__NOEDITSECTION__<The different types of search criteria (e.g. subobject and geo area) are described in [[Search by Subobject]] and [[Search by Map Area]], respectively. The possibility to use AND /center>OR and to specify the search parts makes the Advanced searches very flexible.
==Building Simple SearchesUsing Prompt==__NOEDITSECTION__Building When the prompt function is used in Advanced searches in {{IMSMANG}} is the re-usability and user-friendliness are greatly increased. For example, if a simple three-step process in which information managers determine: #The item user wants to find all progress reports submitted by the "XYZ" organisation and another user wants to have the same search but for#The attributes of the item "ABC organisation, it is better to use in the save one search#Whether all of the criteria must be met (AND) or any of the criteria must be met (OR)and prompt on Organisation.
Following these three steps==SQL criteria==__NOEDITSECTION__While the {{IMSMANG}} search functionality is extremely flexible allowing searches on CDFs, customised option list values and links among items, there are cases where users can build 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 simple or as complex as the examples below:filter criteria.
*find lands with an ID Creating searches using SQL criteria requires a detailed understanding of “MF-101”*find victims who are children PostgreSQL's SQL syntax and were injured the {{IMSMANG}} data model. Your [[Information Management Team | GICHD IM Advisor]] may support you in 2010*find progress reports about work done by XYZ organization on lands in Province ABC between 2008 and 2010*find all clearances completed on lands with antipersonnel minesdeveloping the SQL.
When a search is designed, it can be given a name and description and then saved for later To use. Saving a search saves the 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 a search called “Open Lands” that finds 25 lands with a status of “Open.” If 10 additional lands are entered into 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 data trends over time using consistent search criteria. Information managers can also use an existing search as simply provide a template to create other searches by using valid SQL statement in the “Save as” functionality.following format:
==Using Search Parameters==__NOEDITSECTION__Search parameters allow users to change one or more search criteria when running a searchSELECT [item_guid] FROM [item_table] WHERE. For example, if a user wants to find all progress reports submitted by “XYZ” organisation, they can build 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 the needs of various stakeholders within their programmes.
{{note|Searches can include geospatial data as a parameter The SQL query may be complex with left joins and subqueries but may only have '''one''' output column which allows users to define a geospatial extent to search within. For should be the purposes item_guid of searching, records without geospatial data are defined as “outside” the geospatial extent}} Search target i.e if your search target is Land then only output column should be hazard_guid.
==Building Complex Searches==__NOEDITSECTION__While the {{IMSMANG}} search functionality is extremely robust—allowing searches on CDFs, customised option list values note| We strongly recommended to develop and links among items— there are some cases where users may want to run more complex searches that cannot be built using test the SQL query with a SQL tool before pasting it into the standard search interface. For these cases, SQL criteria since {{IMSMANG}} includes a special Structured Query Language (SQL) search functionality that allows information managers to does not provide SQL syntax for executing searchesdebugging support. Creating searches using SQL criteria requires a detailed understanding of relational databases, SQL and the {{IMSMANG}} data model and should only be undertaken by advanced users.
To use SQL ==Saved Searches==__NOEDITSECTION__Saving a search saves the criteriaof the search rather than the search results. This means that searches are automatically updated when additional data is added to the system, simply provide a valid SQL statement in 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 SQLshould be adapted to each mine action programme's processes. In this way, {{IMSMANG}} unleashes the full power of SQL criteria, joins and subqueries in an easy-to-run interface.
{{note|* It is recommended that information managers test their SQL in an external SQL editor prior to using it within {{IMSMANG}} since {{IMSMANG}} 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 {{IMSMANG}} usersNavBox IMSMA NG Administration}}
{{NavBox Getting started with IMSMA}}[[Category:NAA]]
6,601
edits

Navigation menu