Analyzing query text

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

Listing 13.13. Query text

    MaterialsAndServices.Parent AS ServiceGroup,
    MaterialsAndServicesCat.Ref AS Service,
    Catalog.MaterialsAndServices AS MaterialsAndServicesCat
        LEFT JOIN InformationRegister.Prices.SliceLast(&ReportDate, ) AS PricesSliceLast
        ON (PricesSliceLast.MaterialOrService = MaterialsAndServicesCat.Ref)
    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.