Jump to: navigation, search

Building Searches

847 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 [[Searching for Data in IMSMANG | Search in the Using IMSMA portalby Subobject]] and [[Search by Map Area]], respectively. The possibility to use AND / OR and intent to specify the search parts (which correspond to brackets) makes the Advanced searches very flexible.
==Using Prompt==__NOEDITSECTION__
When 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 the "XYZ" organisation and another user wants to have the same search but for the "ABC organisation, it is better to save one search and prompt on Organisation.
==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 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.
Creating searches using SQL criteria requires a detailed understanding of PostGreSQLPostgreSQL's SQL syntax and the {{IMSMANG}} data model. Of cause your 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:
The SQL 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 hazard_guid.
{{note|* We strongly recommended to develop and test the SQL query with a SQL tool before pasting it into the SQL criteria since {{IMSMANG}} does not provide SQL debugging support.}}
==Using Search ParametersSaved Searches==__NOEDITSECTION__When a search is designed, it can be given a name and description and then saved for later use. Saving a 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 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,” returning results using 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 a template to create other searches by using the “Save as” functionality.
Search parameters allow users to change one or more search criteria when running a search==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. For example, if a user wants "Accident Without Geodata"* items that do not have any links to find all progress reports submitted by “XYZ” organisation, they can build a search for “XYZ progress reportsother items** e.” If another user wants to search for progress reports submitted by “ABC” organisation, they can build another search for “ABC Progress Reportsg.” Alternatively, an information manager can build one search with a parameter for “Organisation” that allows users "Assistance Without Links To Victim"* items which are assigned to provide different values for the organisation when running the searchlocations** e.g. "Land & Activity Not Same Location"* task as Search target** e. This makes one search, for example, “Progress Reports by Organisation,” available for multiple purposesg. The ability "Land Included In More Than One Task"* possible mine action process quality issues** e.g. "Status Open with links to build dynamic searches allows information managers to customise search capabilities to meet the needs of various stakeholders within their programmes.Activity or QM"
{{note|Searches can include geospatial data These Saved searches should be seen as a parameter which allows users '''inspiration''' and should be adapted to define a geospatial extent to search withineach mine action programme's processes. For the purposes of searching, records without geospatial data are defined as “outside” the geospatial extent}}
{{NavBox IMSMA NG Administration}}
 ==Description Pre-populated Saved Searches==__NOEDITSECTION__ {{NavBox Getting started with IMSMA}}[[Category:NAA]]

Navigation menu