Jump to: navigation, search

Building Searches

30 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:
** e.g "Victim Duplicate Name & Date Of Birth"
* items without any geographical data
** e.g. "Accident Without Geodata"* items that does do not have any links to other items
** e.g. "Assistance Without Links To Victim"
* items which are assigned to different locations
** e.g. "Status Open with links to Activity or QM"
{{note | These Saved searches should been be seen as '''inspiration''' and should be adopted adapted to each mine action programme's processes.}}
{{NavBox Getting started with IMSMANG Administration}}

Navigation menu