Azure Digital Twins query language reference: Reserved keywords
This document contains the list of reserved keywords in the Azure Digital Twins query language. These words cannot be used as identifiers in queries unless they are escaped in double square brackets.
List of reserved keywords
Here are the reserved keywords in the Azure Digital Twins query language:
- ALL
- AND
- AS
- ASC
- AVG
- BY
- COUNT
- DESC
- DEVICES_JOBS
- DEVICES_MODULES
- DEVICES
- ENDS_WITH
- FALSE
- FROM
- GROUP
- IN
- IS_BOOL
- IS_DEFINED
- IS_NULL
- IS_NUMBER
- IS_OBJECT
- IS_PRIMITIVE
- IS_STRING
- MAX
- MIN
- NOT
- NOT_IN
- NULL
- OR
- ORDER
- SELECT
- STARTS_WITH
- SUM
- TOP
- TRUE
- WHERE
- IS_OF_MODEL
Escaping reserved keywords in queries
To use a reserved keyword as an identifier in a query, escape the keyword by enclosing it with double square brackets like this: [[<keyword>]]
For example, consider a set of digital twins with a property called GROUP
, which is a reserved keyword. To filter on that property value, the property name must be escaped where it is used in the query, as shown below:
SELECT * FROM DIGITALTWINS WHERE [[Group]] = 'BravoTeam'
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho