MashZone NextGen focuses in dashboard development on three data types: 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, i.e. string, date, and floating number, during follow-up processing of the results. Note that the mapping of a numeric data type, e.g., 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 MashZone NextGen 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 |