NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
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 do not have any links to other items
** e.g. "Assistance Without Links To Victim"
** 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}}
[[Category:NAA]]
