Changes

Jump to: navigation, search

Building Searches

1,063 bytes removed, 16:22, 29 May 2017
no edit summary
*'''saved''' searches which are prepared by information managers for usage by all users.
Saved searches simplifies the user experience and ensures consistency of use by sharing identical searches with all users. Of cause course all users have the possibility ability to saved save searches which is convenience a convenient way to re-use favourite searches.
Particularly, creating saved searches facilitate facilitates access to programme data and reporting . 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.
==Simple Searches==__NOEDITSECTION__
The simple search options in the Search menu function exactly as all other filters in {{IMSMANG}}, see [[Searching for Data in IMSMANG | Search in the Using IMSMA portalItems]].
#==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 item that you want possibility to filter on needs use AND / OR and to be added to the filter combo box with the column picker#Select the item in specify the combo box and specify search parts makes the criterion#Click on ApplyAdvanced searches very flexible.
Examples of simple ==Using Prompt==__NOEDITSECTION__When the prompt function is used in Advanced searches / filters:*filter Land on Land IDs which contain the re-usability and user-friendliness are greatly increased. For example, if a user wants to find all progress reports submitted by the "XYZ"101organisation and another user wants to have the same search but for the "*filter Victims ABC organisation, it is better to save one search and prompt on gender*filter Activities done by the Organisation "DDG" .
==Building Complex SearchesSQL criteria==__NOEDITSECTION__While the {{IMSMANG}} search functionality is extremely robust—allowing flexible allowing searches on CDFs, customised option list values and links among items— items, there are some cases where users may want to run more complex searches that cannot be built using the standard Advanced search interface. For these cases, {{IMSMANG}} includes a special Structured Query Language (SQL) search functionality criteria that allows information managers to provide use a SQL syntax for executing searchesquery as filter criteria.  Creating searches using SQL criteria requires a detailed understanding of relational databases, PostgreSQL's SQL syntax and the {{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.
To use SQL criteria, simply provide a valid SQL statement in the following format:
SELECT [item_guid] FROM [item_table] WHERE...
For example, SELECT hazreduc_guid FROM hazreduc WHERE hazreduc_localID =’ÇL-001’
 
Using SQL criteria, information managers can design complicated searches that can then be saved and run by users with no understanding of SQL. 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}} users}}
==Using Search Parameters==__NOEDITSECTION__When a search is designed, it can The SQL query may be given a name complex with left joins and description and then saved for later use. Saving a search saves subqueries but may only have '''one''' output column which should be the criteria item_guid 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 dataSearch target i. For example, an information manager can build a e if your 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 target 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 a template to create other searches by using the “Save as” functionalityLand then only output column should be hazard_guid.
Search parameters allow users {{note| We strongly recommended to change one or more search criteria when running a search. 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 develop and test the SQL query with a parameter for “Organisation” that allows users to SQL tool before pasting it into the SQL criteria since {{IMSMANG}} does not 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 programmesSQL debugging support.}}
{{note|==Saved Searches can include geospatial data as ==__NOEDITSECTION__Saving a parameter which allows users to define a geospatial extent to search withinsaves the criteria of the search rather than the search results. For This means that searches are automatically updated when additional data is added to the purposes of searchingsystem, records without geospatial data ensuring that searches are defined as “outside” returning results using the geospatial extent}} 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 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 issues
** e.g. "Status Open with links to Activity or QM"
{{note | These Saved searches should be seen as '''inspiration''' and should be adapted to each mine action programme's processes.}}
==Description Pre-populated Saved Searches==__NOEDITSECTION__{{NavBox IMSMA NG Administration}}
{{NavBox Getting started with IMSMA}}[[Category:NAA]]
6,632
edits

Navigation menu