The focus of dashboard development is on three types of data: string, date, and floating number. In addition to these basic data types, RAQL supports other simple data types when working with input data or casting data. The data types of the RAQL query results, however, are always mapped to the three basic data types during follow-up processing of the results.
Note that the mapping of a numeric data type, for example, BigDecimal, to a floating number may imply a loss of precision.
The following table shows the data types RAQL supports, their Java equivalent, as well as their mapping to one of the three basic data types.
RAQL Datatype |
Java Equivalent |
Query Result Mapping |
bigdecimal |
java.math.BigDecimal |
number |
boolean |
java.lang.boolean |
string |
byte |
java.lang.byte |
string |
character |
java.lang.character |
string |
datetime |
java.util.Date |
date |
double |
java.lang.Double |
number |
float |
java.lang.Float |
number |
integer |
java.lang.Integer |
number |
long |
java.lang.Long |
number |
short |
java.lang.Short |
number |
string |
java.lang.String |
string |