skip to main content
Formulating queries : Navigating relationships : Resource Path Navigation

Try DataDirect Cloud Now

Resource Path Navigation

Resource path navigation allows a query to reference a related entity from a parent or child entity. For example, with the following table structure, a customer's orders can be referenced from a Customer record, as shown below.
Customer ---> Order ---> OrderItem
---> Contact

List the orders for a particular customer'3')/Orders

List the order items for a particular order for customer 3'3')/Orders('5')/OrderItems

Access a particular order item'3')/Orders('5')/OrderItems('6')

Access a particular property'3')/Name'3')/Orders('5')/OrderItems('6')/ItemName