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):
-
NUMBER
-
References to a table
-
Other types