MQTT IoT Suite Product Introduction
Profile Architecture Advantages Definitions
QuickStart
Account and Login
Products and Devices
Create Product Create Device
Device Connection
User Guide
Data Stream and Data Point Protocol Adaptation Service
Service Introduction Operation Process Development Guide Examples
Device Image
Service Introduction Console Usage
Rule Engine
Service Introduction Rule Configuration Basic Data Format SQL Built-in Function
Security Authentication
Overview Token Algorithm Token Generator Algorithm Examples
java python
Application Management
Service Introduction Controls Introduction Operating Instructions
Device Development Guide
Protocol Specifications Development Guide Development Examples Topic Cluster
Overview Data Point Topic Cluster Device Command Topic Cluster Device Image Topic Cluster
Application Development Guide
Use of API Error Code API
Query Device Register Device Remove Device Update Device Key Device Command Query Device Image Update Device Image Query Device Data Points
Best Practices
Device Connection Upload Data Points Device Synchronization Command Device Image
Change Log

Built-in function

The SELECT statement supports using built-in functions to obtain device-related constants (case-sensitive function names). The contents returned by built-in functions are string constants, and related insert operations are supported. Please follow the instructions below:

Function Name Description Example Remarks
imei() Get NB device imei number SELECT *,imei() as imei Only NB devices are supported. For other protocol devices, the function returns an empty string "".
bin_data() Get binary data from device messages SELECT *,bin_data() as bin_data Only valid for binary data points uploaded by devices. Extract binary data from data points and convert them to hexadecimal strings. For example, 0x0102 is converted to "0102". For non-binary data points, the function returns an empty string "". Note: The size of binary data points is limited to 80k.
deviceName() Get device name SELECT *,deviceName() as name Get the name of the device that generated the message

Examples of built-in functions are as follows:

Original JSON SQL Statement Result Description
{"a":1} SELECT *,imei() as b {"a":1,"b":"4A7B3123F202"} NB devices
{"a":1} SELECT *,imei() as b {"a":1,"b":""} Null for non-NB devices
{"a":1} SELECT *,bin_data() as b {"a":1,"b":"010203"} Binary data points
{"a":1} SELECT *,bin_data() as b {"a":1,"b":""} Null for non-binary data points
{"a":1} SELECT *,deviceName() as b {"a":1,"b":"mydevice"} -

个搜索结果，搜索内容 “”

    0 个搜索结果，搜索内容 “”