You must store data in databases with specific types in remote queries.
General query datatypes
Type | Description |
|---|---|
Int | An integer |
string_lookup | A lookup string field |
Enum | An enumerated value, stored in the database as an integer |
Mac | A MAC address |
Long | A long value |
Float | A float value |
Timespan | An SQL timespan |
boolean | A Boolean value |
string_enum | An enumerated value stored as a string instead of an integer |
ipv4 | An IPv4 address |
ipv6 | An IPv6 address |