TOQL queries

• The following query requires the product name, product code, quantity and amount returned for a specific route and specific day, ordered by route code

select (valid state ddp)[instant "1997/01/01"

granularity day].RelativeTo.Code,

(valid state ddp)[instant "1997/01/01"

granularity day].RelativeTo.Name,

(valid state ddp)[instant "1997/01/01"

granularity day].ReturnQuantity,

(valid state ddp)[instant "1997/01/01"

granularity day].RelativeTo.ReturnAmount

from Route as r, r.Performance as ddp

where r.Code = “234”

order by (valid state ddp)[instant "1997/01/01"

granularity day].RelativeTo.Name

Previous slide

Next slide

Back to first slide

View graphic version