Desktop version

Main > Knowledge Base > Developer resources > Development recommendations > Query language > Developer resources > Development recommendations > Query language

Query language

Accessing fields from other fields using . (dot)
Bitness of results of expressions and aggregate functions in query language
Calculating totals by balance fields
Catalog field contents
Complementing query result by days belonging to a specified period
Details on how to use the group inclusion operator
Display of reference fields
Sample queries for hierarchical catalog operations
Selection of all values belonging to a grouping from a query result
Sorting in nested queries
Specifics of connecting to the virtual balances table
Specifics of DATEDIFF function of the query language
Specifics of executing SUBSTRING() function of the query language
Specifics of sorting by reference fields
Specifics of using "IN HIERARCHY" clause in query language
Specifics of using the GROUP BY clause
Specifics of working with the Presentation field and Presentation() function of the query language
Specifics of working with virtual table of calculation register schedule data
Using custom expressions in query language totals
Using filters in queries with virtual tables
Using FOR UPDATE clause in the query language
Using the ISNULL() function




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