Query Node Conditions

You can add conditions to the query nodes and relationships of a TQL query in the Query Node Properties dialog box. The conditions filter the query results by retrieving only CIs and relationships that match the conditions defined in the query. There are several types of conditions you can define:

• Attributes. Conditions based on CI property values.

• Cardinality. Conditions based on the number of related query nodes.

• Qualifiers. Conditions based on CI type qualifiers.

• Element type. Conditions based on CI subtypes. See below for details.

• Identity. Conditions based on CI element IDs.

Each one has a separate tab in the dialog box. For details, see Query Node/Relationship Properties Dialog Box.

When you define an attribute condition using the attribute name CI Type, the condition is converted to a complex type condition when you save the query. The condition disappears from the Attribute tab and appears in the Element Type tab. For Enrichment and Impact type queries, the condition disappears from the Attribute tab in Enrichment Manager or Impact Analysis Manager, and you need to open the query in Modeling Studio to edit it in the Element Type tab.

Element Type Conditions

The Element type conditions enable you to specify the subtypes of a query node that should appear in the query results. There are two options for defining this condition:

• Simple Type Condition. The simple type condition enables you to either include all subtypes of the selected query node in the query results, or to exclude all of them.
• Complex Type Condition. The complex type condition enables you to select the specific subtypes of the query node to be included in the query results. For details, see Complex Type Condition.

Element Layout

You can specify the attributes to include in the query results for each query node or relationship in a TQL query in the Element Layout tab of the Query Node Properties dialog box. Select the Select attributes for layout radio button and then select a CIT or relationship in the CIT pane. If you select Specific Attributes for the Attributes condition, only the attributes you move to the Specific Attributes pane are included in the query results for that element. If you select All for the Attributes condition, all of the available attributes are included in the query results for that element. In this case, you can select Exclude specific attributes and move selected attributes to the Excluded Attributes pane.

There is also an option to select attributes by qualifiers. If you select qualifiers in the Attributes with the following qualifiers field, all attributes that have the selected qualifiers are included in the query results for that element, in addition to the attributes selected in the Specific Attributes pane. In this case too, you can exclude selected attributes by moving them to the Excluded Attributes pane.

By default, the attribute settings you select for a CIT are automatically applied to its descendant CITs in the query results; however, the settings are not visible in the Element Layout tab of the dialog box. For example, if you select specific attributes to be included for the Database CIT, the same attributes are included for the Oracle CIT (a child CIT of Database), but if you select Oracle in the CIT pane, the Attributes condition displayed is None (the default condition).

You can then make an attributes condition selection for the child CITs themselves. If the parent CIT has All selected as the attributes condition, then the Specific Attributes option is disabled for the child CITs. If the parent CIT has Specific Attributes selected as the attributes condition, you can select All or Specific Attributes for the child CIT. If you select Specific Attributes, you can add more attributes by moving them to the Specific Attributes pane. These are included in the query results along with the attributes inherited from the parent CIT's setting. Similarly, you can select attributes from the parent CIT's setting to exclude for the child CIT, by moving them to the Excluded Attributes pane. If the parent CIT has qualifiers selected to determine the attribute selection, these are also inherited by the child CIT. If you select additional qualifiers to filter the child CIT's attribute selection, the combined set of selected qualifiers is used to filter the attribute selection for the child CIT.

When you change the type of a query node or relationship using the Change Query Node/Relationship Type dialog box, the attributes selection for that element is lost.

If you import a package with a query that includes an attributes selection that is invalid for the selected query node, or if you make an invalid attributes selection using the JMX console, the query can be saved successfully and a warning appears in the log.

For details on the Element Layout tab, see Element Layout Tab.

Related Information