Building Searches - Revision history

Alnaucler at 14:22, 29 May 2017

2017-05-29T14:22:09Z

← Older revision		Revision as of 16:22, 29 May 2017
Line 66:		Line 66:
	{{note \| These Saved searches should be seen as '''inspiration''' and should be adapted to each mine action programme's processes.}}		{{note \| These Saved searches should be seen as '''inspiration''' and should be adapted to each mine action programme's processes.}}

	{{NavBox ~~Getting started with~~ IMSMA}}		{{NavBox IMSMA NG Administration}}

	[[Category:NAA]]		[[Category:NAA]]

Alnaucler at 18:58, 29 September 2015

2015-09-29T18:58:37Z

← Older revision		Revision as of 20:58, 29 September 2015
Line 36:		Line 36:
	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.		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.		Creating searches using SQL criteria requires a detailed understanding of PostgreSQL'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:		To use SQL criteria, simply provide a valid SQL statement in the following format:

Alnaucler at 09:11, 6 November 2014

2014-11-06T09:11:21Z

← Older revision		Revision as of 11:11, 6 November 2014
Line 36:		Line 36:
	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.		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 GICHD IM Advisor may support you in developing the SQL.		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:		To use SQL criteria, simply provide a valid SQL statement in the following format:

Alnaucler at 16:57, 18 October 2014

2014-10-18T16:57:05Z

← Older revision		Revision as of 18:57, 18 October 2014
Line 36:		Line 36:
	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.		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 GICHD IM Advisor may support you in developing the SQL.		Creating searches using SQL criteria requires a detailed understanding of PostgreSQL's SQL syntax and the {{IMSMANG}} data model. 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:		To use SQL criteria, simply provide a valid SQL statement in the following format:

Alnaucler at 11:35, 24 July 2014

2014-07-24T11:35:26Z

← Older revision		Revision as of 13:35, 24 July 2014
Line 64:		Line 64:
	** e.g. "Status Open with links to Activity or QM"		** e.g. "Status Open with links to Activity or QM"

	{{note \| These Saved searches should be seen as '''inspiration''' and should be ~~adopted~~ to each mine action programme's processes.}}		{{note \| These Saved searches should be seen as '''inspiration''' and should be adapted to each mine action programme's processes.}}

	{{NavBox Getting started with IMSMA}}		{{NavBox Getting started with IMSMA}}

	[[Category:NAA]]		[[Category:NAA]]

Laura: Version 6.0

2014-03-06T17:36:10Z

Version 6.0

← Older revision		Revision as of 19:36, 6 March 2014
Line 54:		Line 54:
	** e.g "Victim Duplicate Name & Date Of Birth"		** e.g "Victim Duplicate Name & Date Of Birth"
	* items without any geographical data		* items without any geographical data
			** e.g. "Accident Without Geodata"
	* items that do not have any links to other items		* items that do not have any links to other items
	** e.g. "Assistance Without Links To Victim"		** e.g. "Assistance Without Links To Victim"

Dionysia: Dionysia moved page Principles for Building Searches to Building Searches without leaving a redirect

2014-02-17T13:59:00Z

Dionysia moved page Principles for Building Searches to Building Searches without leaving a redirect

← Older revision	Revision as of 15:59, 17 February 2014
(No difference)

Laura: Version 6.0

2014-02-11T18:10:52Z

Version 6.0

← Older revision		Revision as of 20:10, 11 February 2014
Line 25:		Line 25:

	==Simple Searches==__NOEDITSECTION__		==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 portal~~]].		The simple search options in the Search menu function exactly as all other filters in {{IMSMANG}}, see [[Search Items]].

	==Advanced Searches==__NOEDITSECTION__		==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 portal~~]]. The possibility to use AND / OR and to specify the search parts makes the Advanced searches very flexible.		The different types of search criteria (e.g. subobject and geo area) are described in [[Search by 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__		==Using Prompt==__NOEDITSECTION__

Dionysia at 21:48, 5 February 2014

2014-02-05T21:48:02Z

← Older revision		Revision as of 23:48, 5 February 2014
Line 54:		Line 54:
	** e.g "Victim Duplicate Name & Date Of Birth"		** e.g "Victim Duplicate Name & Date Of Birth"
	* items without any geographical data		* items without any geographical data
	* items that ~~does~~ not have any links to other items		* items that do not have any links to other items
	** e.g. "Assistance Without Links To Victim"		** e.g. "Assistance Without Links To Victim"
	* items which are assigned to different locations		* items which are assigned to different locations

Dionysia at 21:46, 5 February 2014

2014-02-05T21:46:41Z

← Older revision		Revision as of 23:46, 5 February 2014
Line 36:		Line 36:
	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.		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~~ GICHD IM Advisor may support you in developing the SQL.		Creating searches using SQL criteria requires a detailed understanding of PostGreSQL's SQL syntax and the {{IMSMANG}} data model. 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:		To use SQL criteria, simply provide a valid SQL statement in the following format: