Difference between revisions of "Advanced Search"

From IMSMA Wiki
Jump to: navigation, search
(Created page with "{{note| OR will retrieve data that correspond to at least one of the defined criterion. AND will retrieve data that exactly correspond to all defined criteria.}} {{note| Some...")
 
 
(17 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
{{note| OR will retrieve data that correspond to at least one of the defined criterion.
+
The advanced search functionality allows to add different items and criteria during search.
−
AND will retrieve data that exactly correspond to all defined criteria.}}
 
  
−
{{note| Some attributes have ''buttons'' or ''widgets'' that you can click to select an option from a list of corresponding values.
+
<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 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.
 +
[[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.
 +
[[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:
 +
* 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>
 +
<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:
 +
* 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 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>
 +
<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>
  
−
[[Image:sfD14.png|500px]]
+
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.
−
}}
 
  
−
{{note|
+
To delete a search criterion row or criteria group, select the row or the group and click [[Image:EcksButton.png]].
−
To add additional search criteria, click [[Image:FieldTemplateIcon.png]].
 
−
To add a new condition to a criteria node, click OR/AND.
 
  
−
To move a search criterion or criteria node, select the criterion or node and click [[Image:UpBlueArrow.png]] to move it up or [[Image:DownBlueArrow.png]] to move it down.
+
{{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.}}
−
 
 
−
To delete a search criterion or criteria node, select the criterion or node and click [[Image:EcksButton.png]].
 
−
 
 
−
[[Image:sfD15.png|500px]]
 
−
}}
 
  
−
{{note| Selecting the ''Prompt'' checkbox enables you to select other value options when running saved searches.}}
+
{{New_6.0 | More subobjects have been added in version 6.0 as possible Search Targets.}}
  
−
{{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}}
 +
[[Category:NAA]]

Latest revision as of 08:10, 18 March 2019

The advanced search functionality allows to add different items and criteria during search.

  1. Specify which item you would like to use as your main search target by selecting in the drop-down list.
  2. Specify if all criteria should be true (AND) or one or more of the criteria are true (OR) (more details can be found here). This selection can be changed later.
  3. Next action is to add a criterion row by clicking on the FieldTemplateIcon.png button.
    Adv search.png
  4. Each row in the pane represents a criterion. A criterion is comprised of an attribute, operator, and value.
    Criterion Components
  5. 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.
    Adv search dropdown.png
  6. 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.
  7. 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.
    Note.jpg Prompt means that the users may specify the value(s) when Search is run/executed. The prompt function provides flexibility when running Saved Searches.
  8. Repeat steps 3–7 for each criterion you would like to add to the search definition.
  9. 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 UpBlueArrow.png to move it up or DownBlueArrow.png to move it down.

To delete a search criterion row or criteria group, select the row or the group and click EcksButton.png.

Note.jpg 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.
New 6.0.png More subobjects have been added in version 6.0 as possible Search Targets.
Searching for Data in IMSMANG
Retrieved from "http://mwiki.gichd.org:8090/mediawiki/index.php?title=Advanced_Search&oldid=24232"