Changes

Advanced Search

1,276 bytes added, 09:10, 18 March 2019
no edit summary
[[Image:Adv The advanced search functionality allows to add different items and criteria during search.png|400px|center]]
First you need to specify <ol><li>Specify which item you would like to use as you your main search target by selecting in the drop-down list.</li>Next decision to take is <li>Specify if '''all ''' criteria should be true (AND) or if it is good enough if one or more of them the criteria are true (for 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 detailson 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>
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 delete a search criterion row or criteria group, select the row or the group and click [[Image:EcksButton.png]].
{{note| Some attributes have ''buttons'' or ''widgets'' that If you can click to select an option SQL from the attribute drop-down list, you can enter a list of corresponding valuesvalid SQL statement in the value fieldSee [[Image:sfD14.pngBuilding Searches#SQL criteria|500pxBuilding Searches]]for more information.}} {{note|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{{New_6.png]] to move it up or [[Image:DownBlueArrow0 | More subobjects have been added in version 6.png]] to move it down0 as possible Search Targets.}}
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.}}
 
{{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:COONAA]]
6,632
edits