NoPublic, bureaucrat, administrator
4,913
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 PostGreSQL's SQL syntax and the {{IMSMANG}} data model. Of cause your Your GICHD IM Advisor may support you in developing the SQL.
To use SQL criteria, simply provide a valid SQL statement in the following format: