Changes

Advanced Search

1,461 bytes added, 09:10, 18 March 2019

no edit summary

{{note| OR will retrieve data that correspond The advanced search functionality allows to at least one of the defined criterion.AND will retrieve data that exactly correspond to all defined add different items and criteriaduring search.}}

{{note| Some attributes have <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'buttons'' 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|''widgetsCriterion Components'' ]]</li><li>Select that attribute that you can click 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 select an option the attribute from a the list . The available operators are determined by the data type of corresponding 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>

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

{{note|To add additional delete a search criterion row or criteriagroup, select the row or the group and click [[Image:FieldTemplateIconEcksButton.png]].To add a new condition to a criteria node, click OR/AND.

To move a search criterion or criteria node, {{note| If you select SQL from the criterion or node and click [[Image:UpBlueArrow.png]] to move it up or [[Image:DownBlueArrow.png]] to move it attribute drop-down. To delete list, you can enter a search criterion or criteria node, select valid SQL statement in the criterion or node and click [[Image:EcksButtonvalue field.png]]. See [[Image:sfD15.pngBuilding Searches#SQL criteria|500pxBuilding Searches]]for more information.}}

{{noteNew_6.0 | Selecting the ''Prompt'' checkbox enables you to select other value options when running saved searchesMore 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 NavBox HowTo Search}}[[Building Searches#SQL criteria|Building SearchesCategory:NAA]] for more information.}}

• ← Older edit

Alnaucler

NoPublic, bureaucrat, administrator

6,632

edits