Difference between revisions of "Advanced Search"
From IMSMA Wiki
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 | + | <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 | |
− | + | * 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>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. |
Revision as of 12:56, 24 March 2015
The advanced search functionality allows to add different items and criteria during search.
- Specify which item you would like to use as your main search target by selecting in the drop-down list.
- Specify if all criteria should occur (AND) or one or more of the criteria are true (OR) (more details can be found here). This selection can be changed later.
- Next action is to add a criterion row by clicking on the button.
- Each row in the pane represents a criterion. A criterion is comprised of an attribute, operator, and value.
- 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 subobjects in alphabetic order
- other search targets and the SQL criteria.
- 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.
- 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 here.
- Choose operator, specify value(s) and check the Prompt checkbox.
- Choose operator and check the Prompt checkbox.
Prompt means that the users may specify the value(s)when Search is run/executed. The prompt function provides flexibility when running Saved Searches. - Repeat steps 3–7 for each criterion you would like to add to the search definition.
- When all criteria have been added, click on Run to start the search.
To move a search criterion row or criteria group, select the criterion or group and click to move it up or to move it down.
To delete a search criterion row or criteria group, select the row or the group and click .
If you select SQL from the attribute drop-down list, you can enter a valid SQL statement in the value field. See Building Searches for more information. |
More subobjects have been added in version 6.0 as possible Search Targets. |