Changes

Building Searches

216 bytes removed, 21:21, 15 September 2013

no edit summary

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 portal]].

#==Advanced Searches==__NOEDITSECTION__The item that you want to filter on needs to be added to the filter combo box with the column picker#Select the item different types of search criteria e.g. subobject and geo area are described in [[Searching for Data in IMSMANG | Search in the combo box Using IMSMA portal]]. The possibility to use AND / OR and specify intent the search parts (which correspond to brackets) makes the criterion#Click on ApplyAdvanced searches very flexible.

Examples of simple ==Using Prompt==__NOEDITSECTION__When the prompt function is used in Advanced searches / filters:*filter Land on Land IDs which contain "101"*filter Victims on gender*filter Activities done by the Organisation "DDG" re-usability and user-friendliness are greatly increased.

==Building Complex SearchesSQL criteria==__NOEDITSECTION__While the {{IMSMANG}} search functionality is extremely robust—allowing flexible allowing searches on CDFs, customised option list values and links among items— items, there are some cases where users may want to run more complex searches that cannot be built using the standard Advanced search interface. For these cases, {{IMSMANG}} includes a special Structured Query Language (SQL) search functionality criteria that allows information managers to provide use a SQL syntax for executing searchesquery as filter criteria.  Creating searches using SQL criteria requires a detailed understanding of relational databases, PostGreSQL's SQL syntax and the {{IMSMANG}} data model and should only be undertaken by advanced users. Of cause 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:

SELECT [item_guid] FROM [item_table] WHERE...

For example, SELECT hazreduc_guid FROM hazreduc WHERE hazreduc_localID =’ÇL-001’

Using The SQL criteria, information managers can design complicated searches that can then query may be saved and run by users complex with no understanding of SQL. In this way, {{IMSMANG}} unleashes the full power of SQL criteria, left joins and subqueries in an easy-to-run interfacebut may only have '''one''' output column which should be the item_guid of the Search target i.e if your search target is Land then only output column should be hazard_guid.

{{note|

* It is We strongly recommended that information managers to develop and test their the SQL in an external query with a SQL editor prior to using tool before pasting it within {{IMSMANG}} into the SQL criteria since {{IMSMANG}} does not provide SQL debugging support.* Information managers can build complicated queries using SQL and combine them with other criteria, including parameters, to provide virtually unlimited search capabilities to {{IMSMANG}} users}}

==Using Search Parameters==__NOEDITSECTION__

• ← Older edit
• Newer edit →

Alnaucler

NoPublic, bureaucrat, administrator

6,632

edits