Jump to: navigation, search

Building Searches

10 bytes added, 16:22, 29 May 2017
no edit summary
==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 to specify the search parts makes the Advanced searches very flexible.
==Using Prompt==__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. 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 be seen as '''inspiration''' and should be adopted adapted to each mine action programme's processes.}}
{{NavBox Getting started with IMSMANG Administration}}

Navigation menu