Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Previous sectionNext section

SIBLINGS

Returns a set that contains the specified member and all its siblings.

Returned Type

This function returns a set of members.

Syntax and Details

member_expression.SIBLINGS

Where:

Example

For example:

SELECT MEASURES.[%COUNT] ON 0, homed.cypress.SIBLINGS ON 1 FROM patients
 
                             Patient Count
1 Cypress                             1,089
2 Magnolia                            1,073
3 Pine                                1,039
Copy code to clipboard

To see a picture of the hierarchy used in this example, see the FIRSTCHILD function.

See Also