Advanced Search - Revision history

Alnaucler at 07:10, 18 March 2019

2019-03-18T07:10:48Z

← Older revision		Revision as of 09:10, 18 March 2019
Line 30:		Line 30:

	{{NavBox HowTo Search}}		{{NavBox HowTo Search}}
	[[Category:~~COO~~]]		[[Category:NAA]]

Alnaucler at 06:32, 3 March 2018

2018-03-03T06:32:15Z

← Older revision		Revision as of 08:32, 3 March 2018
Line 17:		Line 17:
	* Choose operator, specify value(s) and check the '''Prompt''' checkbox.		* Choose operator, specify value(s) and check the '''Prompt''' checkbox.
	* Choose operator and check the '''Prompt''' checkbox.		* Choose operator and check the '''Prompt''' checkbox.
	{{note\| ''Prompt'' means that the users may specify the value(s)when Search is run/executed. The prompt function provides flexibility when running [[Saved Searches Window \| Saved Searches]].}}</li>		{{note\| ''Prompt'' means that the users may specify the value(s) when Search is run/executed. The prompt function provides flexibility when running [[Saved Searches Window \| Saved Searches]].}}</li>
	<li>Repeat steps 3–7 for each criterion you would like to add to the search definition.</li>		<li>Repeat steps 3–7 for each criterion you would like to add to the search definition.</li>
	<li>When all criteria have been added, click on '''Run''' to start the search.</li></ol>		<li>When all criteria have been added, click on '''Run''' to start the search.</li></ol>

Alnaucler at 17:24, 17 June 2017

2017-06-17T17:24:34Z

← Older revision		Revision as of 19:24, 17 June 2017
Line 3:		Line 3:
	<ol>		<ol>
	<li>Specify which item you would like to use as your main search target by selecting in the drop-down list.</li>		<li>Specify which item you would like to use as your main search target by selecting in the drop-down list.</li>
	<li>Specify if all criteria should ~~occur~~ (AND) or one or more of the criteria are true (OR) (more details can be found [[And Versus Or \|here]]). This selection can be changed later.</li>		<li>Specify if '''all''' criteria should be true (AND) or one or more of the criteria are true (OR) (more details can be found [[And Versus Or \|here]]). This selection can be changed later.</li>
	<li>Next action is to add a criterion row by clicking on the [[Image:FieldTemplateIcon.png]] button.		<li>Next action is to add a criterion row by clicking on the [[Image:FieldTemplateIcon.png]] button.
	[[Image:Adv search.png\|600px\|center]]</li>		[[Image:Adv search.png\|600px\|center]]</li>

Alnaucler at 12:44, 16 June 2017

2017-06-16T12:44:57Z

← Older revision		Revision as of 14:44, 16 June 2017
Line 17:		Line 17:
	* Choose operator, specify value(s) and check the '''Prompt''' checkbox.		* Choose operator, specify value(s) and check the '''Prompt''' checkbox.
	* Choose operator and check the '''Prompt''' checkbox.		* Choose operator and check the '''Prompt''' checkbox.
	{{note\| ''Prompt'' means that the users may specify the value(s)when Search is run/executed. The prompt function provides flexibility when running [[~~Access the~~ Saved Searches Window \| Saved Searches]].}}</li>		{{note\| ''Prompt'' means that the users may specify the value(s)when Search is run/executed. The prompt function provides flexibility when running [[Saved Searches Window \| Saved Searches]].}}</li>
	<li>Repeat steps 3–7 for each criterion you would like to add to the search definition.</li>		<li>Repeat steps 3–7 for each criterion you would like to add to the search definition.</li>
	<li>When all criteria have been added, click on '''Run''' to start the search.</li></ol>		<li>When all criteria have been added, click on '''Run''' to start the search.</li></ol>

Dionysia at 11:56, 24 March 2015

2015-03-24T11:56:41Z

Alnaucler at 12:27, 15 March 2015

2015-03-15T12:27:56Z

← Older revision		Revision as of 14:27, 15 March 2015
Line 27:		Line 27:

	{{note\| If you select SQL from the attribute drop-down list, you can enter a valid SQL statement in the value field. See [[Building Searches#SQL criteria\|Building Searches]] for more information.}}		{{note\| If you select SQL from the attribute drop-down list, you can enter a valid SQL statement in the value field. See [[Building Searches#SQL criteria\|Building Searches]] for more information.}}

			{{New_6.0 \| More subobjects have been added in version 6.0 as possible Search Targets.}}

	{{NavBox HowTo Search}}		{{NavBox HowTo Search}}
	[[Category:COO]]		[[Category:COO]]

Dionysia at 11:03, 6 October 2014

2014-10-06T11:03:06Z

← Older revision		Revision as of 13:03, 6 October 2014
Line 3:		Line 3:
	<ol start="1">		<ol start="1">
	<li>Specify which item you would like to use as your main search target by selecting in the drop-down list.</li>		<li>Specify which item you would like to use as your main search target by selecting in the drop-down list.</li>
	~~</ol>~~
	~~<ol start="2">~~
	<li>Specify if all criteria should occur (AND) or one or more of the criteria are true (OR) (more details can be found [[And Versus Or \|here]]). This selection can be changed later.</li>		<li>Specify if all criteria should occur (AND) or one or more of the criteria are true (OR) (more details can be found [[And Versus Or \|here]]). This selection can be changed later.</li>
	~~</ol>~~
	~~<ol start="3">~~
	<li>Next action is to add a criterion row by clicking on the [[Image:FieldTemplateIcon.png]] button.		<li>Next action is to add a criterion row by clicking on the [[Image:FieldTemplateIcon.png]] button.
	[[Image:~~fig73~~.png\|center~~\|500px\|''Criterion Components''~~]]		[[Image:Adv search.png\|600px\|center]]</li>
	<li>Each row in the pane represents a criterion. A criterion is comprised of an attribute, operator, and value.~~</li>~~		<li>Each row in the pane represents a criterion. A criterion is comprised of an attribute, operator, and value.
	~~</ol>~~		[[Image:fig73.png\|center\|500px\|''Criterion Components'']]</li>

	[[Image:~~Adv search~~.png\|~~600px~~\|~~center~~]]

	<~~ol start="5"~~>
	~~[[Image:Adv search dropdown.png\|center\|600px\|]]~~
	<li>Select that attribute that you would like use in the drop-down list. The drop-down list consists of two parts:		<li>Select that attribute that you would like use in the drop-down list. The drop-down list consists of two parts:
	:* the attributes of the search target included CDFs and [[Search by Subobject \| subobjects]] in alphabetic order		:* the attributes of the search target included CDFs and [[Search by Subobject \| subobjects]] in alphabetic order
	:* other search targets and the SQL criteria.		:* other search targets and the SQL criteria.
			[[Image:Adv search dropdown.png\|center\|600px\|]]</li>
	<li>Select the operator that you would like to apply to the attribute from the list. The available operators are determined by the data type of the selected attribute.</li>		<li>Select the operator that you would like to apply to the attribute from the list. The available operators are determined by the data type of the selected attribute.</li>
	<li>Do one of the following to specify the value(s) that the attribute must meet:</li>		<li>Do one of the following to specify the value(s) that the attribute must meet:</li>
Line 25:		Line 17:
	*Choose operator, specify value(s) and check the '''Prompt''' checkbox.		*Choose operator, specify value(s) and check the '''Prompt''' checkbox.
	*Choose operator and check the '''Prompt''' checkbox.		*Choose operator and check the '''Prompt''' checkbox.
	{{note\| ''Prompt'' means that the users may specify the value(s)when Search is run/executed. The prompt function provides flexibility when running [[Access the Saved Searches Window \| Saved Searches]].}}		{{note\| ''Prompt'' means that the users may specify the value(s)when Search is run/executed. The prompt function provides flexibility when running [[Access the Saved Searches Window \| Saved Searches]].}}</li>
	<li>Repeat steps 3–7 for each criterion you would like to add to the search definition.</li>		<li>Repeat steps 3–7 for each criterion you would like to add to the search definition.</li>
	<li>When all criteria have been added, click on '''Run''' to start the search.</li>		<li>When all criteria have been added, click on '''Run''' to start the search.</li>
Line 34:		Line 26:
	To delete a search criterion row or criteria group, select the row or the group and click [[Image:EcksButton.png]].		To delete a search criterion row or criteria group, select the row or the group and click [[Image:EcksButton.png]].

			{{note\| If you select SQL from the attribute drop-down list, you can enter a valid SQL statement in the value field. See [[Building Searches#SQL criteria\|Building Searches]] for more information.}}


	~~{{note\| If you select SQL from the attribute drop-down list, you can enter a valid SQL statement in the value field. See [[Building Searches#SQL criteria\|Building Searches]] for more information.}}~~
	{{NavBox HowTo Search}}		{{NavBox HowTo Search}}
	[[Category:COO]]		[[Category:COO]]

Dionysia at 11:00, 6 October 2014

2014-10-06T11:00:09Z

← Older revision		Revision as of 13:00, 6 October 2014
Line 1:		Line 1:
	The advanced search functionality allows to add different items and criteria during search.		The advanced search functionality allows to add different items and criteria during search.

	~~[[Image:Adv search.png\|600px\|center]]~~

	<ol start="1">		<ol start="1">
Line 14:		Line 12:
	<li>Each row in the pane represents a criterion. A criterion is comprised of an attribute, operator, and value.</li>		<li>Each row in the pane represents a criterion. A criterion is comprised of an attribute, operator, and value.</li>
	</ol>		</ol>

			[[Image:Adv search.png\|600px\|center]]

	<ol start="5">		<ol start="5">

Dionysia at 10:59, 6 October 2014

2014-10-06T10:59:09Z

← Older revision		Revision as of 12:59, 6 October 2014
Line 7:		Line 7:
	</ol>		</ol>
	<ol start="2">		<ol start="2">
	<li>~~Next decision to take is~~ if all criteria should ~~be true~~ or ~~if it is good enough if~~ one of ~~them~~ are true (~~for~~ more [[And Versus Or \| ~~details~~]]). ~~Of cause this decision is possible to change~~ later.</li>		<li>Specify if all criteria should occur (AND) or one or more of the criteria are true (OR) (more details can be found [[And Versus Or \|here]]). This selection can be changed later.</li>
	</ol>		</ol>
	<ol start="3">		<ol start="3">

Dionysia at 10:55, 6 October 2014

2014-10-06T10:55:04Z

← Older revision		Revision as of 12:55, 6 October 2014
Line 4:		Line 4:

	<ol start="1">		<ol start="1">
	<li>Specify which item you would like to use as ~~you~~ main search target by selecting in the drop-down list.</li>		<li>Specify which item you would like to use as your main search target by selecting in the drop-down list.</li>
	</ol>		</ol>
	<ol start="2">		<ol start="2">

← Older revision		Revision as of 13:56, 24 March 2015
Line 1:		Line 1:
	The advanced search functionality allows to add different items and criteria during search.		The advanced search functionality allows to add different items and criteria during search.

	<ol ~~start="1"~~>		<ol>
	<li>Specify which item you would like to use as your main search target by selecting in the drop-down list.</li>		<li>Specify which item you would like to use as your main search target by selecting in the drop-down list.</li>
	<li>Specify if all criteria should occur (AND) or one or more of the criteria are true (OR) (more details can be found [[And Versus Or \|here]]). This selection can be changed later.</li>		<li>Specify if all criteria should occur (AND) or one or more of the criteria are true (OR) (more details can be found [[And Versus Or \|here]]). This selection can be changed later.</li>
Line 9:		Line 9:
	[[Image:fig73.png\|center\|500px\|''Criterion Components'']]</li>		[[Image:fig73.png\|center\|500px\|''Criterion Components'']]</li>
	<li>Select that attribute that you would like use in the drop-down list. The drop-down list consists of two parts:		<li>Select that attribute that you would like use in the drop-down list. The drop-down list consists of two parts:
	:* the attributes of the search target included CDFs and [[Search by Subobject \| subobjects]] in alphabetic order		* the attributes of the search target included CDFs and [[Search by Subobject \| subobjects]] in alphabetic order
	:* other search targets and the SQL criteria.		* other search targets and the SQL criteria.
	[[Image:Adv search dropdown.png\|center\|600px\|]]</li>		[[Image:Adv search dropdown.png\|center\|600px\|]]</li>
	<li>Select the operator that you would like to apply to the attribute from the list. The available operators are determined by the data type of the selected attribute.</li>		<li>Select the operator that you would like to apply to the attribute from the list. The available operators are determined by the data type of the selected attribute.</li>
	<li>Do one of the following to specify the value(s) that the attribute must meet:~~</li>~~		<li>Do one of the following to specify the value(s) that the attribute must meet:
	*Choose operator and specify value(s). More details on different operators and values [[Filter Lists \| here]].		* Choose operator and specify value(s). More details on different operators and values [[Filter Lists \| here]].
	*Choose operator, specify value(s) and check the '''Prompt''' checkbox.		* Choose operator, specify value(s) and check the '''Prompt''' checkbox.
	*Choose operator and check the '''Prompt''' checkbox.		* Choose operator and check the '''Prompt''' checkbox.
	{{note\| ''Prompt'' means that the users may specify the value(s)when Search is run/executed. The prompt function provides flexibility when running [[Access the Saved Searches Window \| Saved Searches]].}}</li>		{{note\| ''Prompt'' means that the users may specify the value(s)when Search is run/executed. The prompt function provides flexibility when running [[Access the Saved Searches Window \| Saved Searches]].}}</li>
	<li>Repeat steps 3–7 for each criterion you would like to add to the search definition.</li>		<li>Repeat steps 3–7 for each criterion you would like to add to the search definition.</li>
	<li>When all criteria have been added, click on '''Run''' to start the search.</li>		<li>When all criteria have been added, click on '''Run''' to start the search.</li></ol>
	</ol>

	To move a search criterion row or criteria group, select the criterion or group and click [[Image:UpBlueArrow.png]] to move it up or [[Image:DownBlueArrow.png]] to move it down.		To move a search criterion row or criteria group, select the criterion or group and click [[Image:UpBlueArrow.png]] to move it up or [[Image:DownBlueArrow.png]] to move it down.