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 > How to Define Report Settings

How to Define Report Settings

This task describes how to define report settings for a view, template, or perspective.

Prerequisites

After defining the content and hierarchy of a view, template, or perspective, you can define the report settings. Select the Report tab in the Pattern View Editor.
Select Attributes to Appear as Report Columns

For each query node in the view, select the query node in the Hierarchy pane and select the attributes to appear as columns in the report for that query node. You select attributes in the Query Node Definition pane by moving them from the Attributes list to the Report Layout list. Set the order of the columns using the arrow buttons in the Report Layout list. For details, see Pattern View Editor and select Query Node Definition Pane.
Add Function Columns to the Report - Optional

You have the option of adding a column for a selected query node consisting of data derived from a function performed on one of its child query nodes. Click the Add Function button to open the Add Function dialog box where you can select the relevant settings. For details, see Add/Edit Function Dialog Box.
Set the Sort Order of the Column Content

Click the Set Sort Order button to open the Sort Column Content dialog box. Determine the columns by which to sort the report by moving columns from the Available Columns list to the Sorted Columns list. Use the arrow buttons to set the sort order of the columns. Use the Sort Ascending/Sort Descending buttons to set the sort direction for each column. For details, see Sort Column Content Dialog Box.
Add a Chart to the Report - Optional

You have the option of adding a chart to your report, in place of a table, for a selected layer of the view. When the necessary conditions for adding a chart are satisfied, the Define Chart link in the Chart Properties section of the Query Node Definition pane is active. Click the link and enter the chart settings. For details, see Pattern View Editor.
Set the Report Properties

Select the View tab in the Pattern View Editor. Select the Report Properties button to assign a title and subtitle to the report and to select the report format. For details, see Report Properties Dialog Box.

Related Information

Send Help Center feedback