Jump to: navigation, search

Building Searches

33 bytes added, 10:11, 6 November 2014
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 PostgreSQL's SQL syntax and the {{IMSMANG}} data model. Your [[Management Consulting 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:

Navigation menu