Main > Knowledge Base > Knowledge Base > Knowledge base > Practical developer guide 8.3 > Lesson 13 (4:30). Reports > Breaking down by days in the selected period > In Designer mode > Analyzing query text > Practical developer guide 8.3 > Lesson 13 (4:30). Reports > Breaking down by days in the selected period > In Designer mode > Analyzing query text

Analyzing query text

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

Listing 13.10. Query text

SELECT
    SalesTurnovers.Technician,
    SalesTurnovers.Period,
    SalesTurnovers.Customer,
    SalesTurnovers.RevenueTurnover AS Revenue
FROM
    AccumulationRegister.Sales.Turnovers( , , Day, ) AS SalesTurnovers

Note that in the query description the periodicity of data selected from the data source is set to Day (listing 13.11).

Listing 13.11. Specifying virtual table periodicity

FROM
    AccumulationRegister.Sales.Turnovers( , , Day, ) AS SalesTurnovers

This is why you can use the Period field in the selection.

Next page: Resources




© 1C LLC. All rights reserved
1C Company respects the privacy of our customers and visitors
to our Web-site.