Analyzing query text

Let us analyze the generated query text (listing 13.13).

Listing 13.13. Query text

SELECT
    MaterialsAndServices.Parent AS ServiceGroup,
    MaterialsAndServicesCat.Ref AS Service,
    PricesSliceLast.Price
FROM
    Catalog.MaterialsAndServices AS MaterialsAndServicesCat
        LEFT JOIN InformationRegister.Prices.SliceLast(&ReportDate, ) AS PricesSliceLast
        ON (PricesSliceLast.MaterialOrService = MaterialsAndServicesCat.Ref)
WHERE
    MaterialsAndServicesCat.MaterialServiceType = &MaterialServiceType

Almost all of the clauses used in this query are already familiar to you. Let us proceed to editing the data composition schema.

Next page: Resources

Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.