NUMBER type literal

NUMBER type literal has the following representation:

<Integer>[.<Integer>]

Examples:

TYPE(String) // Returns String type
TYPE(Catalog.Nomenclature) // Returns reference to Nomenclature catalog type

TYPE values can be used in comparison, order and grouping operations of the query language.
An example of using type in a comparison operation:

SELECT
VALUETYPE(Sales.Recorder)
FROM
FROM AccumulationRegister.Sales AS Sales
WHERE
VALUETYPE(Sales.Recorder) = TYPE (Document.ExpInvoice)

The value of the TYPE type can be passed as a query parameter.

Example:

SELECT
VALUETYPE(Sales.Recorder)
FROM
FROM AccumulationRegister.Sales AS Sales
WHERE
VALUETYPE(Sales.Recorder) = &Type

When the TYPE values are compared, they have the following order (the type listed first is the smallest):

  1. NUMBER
  2. References to a table
  3. Other types

1C:Enterprise Developer's Community