Define a Related Clause
A Related Clause is a Query Clause that finds Business Objects whose related Business Object satisfy some of the criteria.
Use the Query Builder window to create a Related Clause. When you define this type of clause, you define:
- Relationship: Existing CSM Relationship between two Business Objects (example: Incident links Service).
- Value: Number of Business Object records in the relationship (There are exactly 3 Services).
Good to know:
- For each item with "n", a Record number menu appears that allows the number to be selected.
To create a Related Clause:
- Open a Query Builder.
- Click the New button on the Query Builder toolbar, and then select Related Clause.
- Select a related Business Object from the Relationship drop-down.
- Select a
value in the Contains drop-down:
- All <related business object>
- There is at least one <related business object>
- There are no <related business object>
- There is exactly 1 <related business object>
- There is not exactly 1 n <related business object>
- There is more than 1 n <related business object>
- There is at least 1 n <related business object>
- There are less than 1 n <related business object>
- There are 0 or 1 n <related business object>
The clause you created displays in the Query:
- Add additional clauses to refine your search (optional).
Note: If you are using the Stored Query Builder, there is an Options button that allows you to define additional options, including availability and icon image.
-
Click OK.