ATG Repository Guide

Includes Item Queries

Some repositories support properties that are arrays or collections of items belonging to another (or the same) item descriptor. For example, the addresses property might point to an array of items, which themselves have address-related properties.

In this case, RQL allows for a subquery to be defined on these properties. For example:

addresses INCLUDES ITEM (zip = "48322" AND state = "MI")

This query means “find all people whose list of addresses includes at least one address whose zip code is 48322 and whose state is MI”.