Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Universal CMDB11.0

Use > Modeling > Modeling > Modeling Studio > Modeling Studio User Interface > Add/Edit Function Dialog Box

Add/Edit Function Dialog Box

This dialog box enables you to define which of the query node's functions and parameters you want to include in the report.

To access	Click the Add Function button under the Report Layout box in the Query Node Definition pane of the Pattern View Editor.
Important information	When defining the report columns for a selected query node in a view, template, or perspective, you can define a column consisting of data deriving from a function defined for one of its child query nodes. Select the relevant child query node, attribute, and function that you want to define. First, select the required query node and function. The attribute list adjusts to display the relevant attribute for the selected combination. Select the required attribute.
Relevant tasks	How to Define Report Settings
See also	Building a Business View Modeling Studio User Interface

User interface elements are described below:

UI Element (A-Z)	Description
Attribute	Select an attribute from the list.
Function	From the Function list, select the function you want to use to calculate the results on these columns. The following are the available options: Average. The average value of the selected attribute for all the CI instances of the selected query node. Concatenated List. Lists the values of the selected attribute for all the CI instances of the selected query node. Count. Calculates the number of CI instances of the selected query node. Distinct List. Lists the unique values of the selected attribute for all the CI instances of the selected query node. Max. The maximum value of the selected attribute for all the CI instances of the selected query node. Min. The minimum value of the selected attribute for all the CI instances of the selected query node. Sum. The sum of the selected attribute values for all the CI instances of the selected query node.
Related Query Node	The child query node on which you want to perform the function.
Title	The name of the function attribute displayed in the report.