Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?

LASTCHILD

Returns the last child of the given member.

Returned Type

This function returns a member.

Syntax and Details

member_expression.LASTCHILD 

Where:

The function returns the last child of this member. To determine which child is last, the function considers the default order of the set of children.

Example

For example:

SELECT MEASURES.[%COUNT] ON 0, homed.zip.[34577].LASTCHILD ON 1 FROM patients
 
                             Patient Count
Pine                                 1,100

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

For another example:

SELECT MEASURES.[%COUNT] ON 0, birthd.[1950].LASTCHILD ON 1 FROM patients
                             Patient Count
Dec-1950                                  8

See Also

Feedback