Query column

The properties of a query column are:

Property Name Description Editable Data Type
Display Width The display width of the query column. N Integer
Name The display name of the query column. N String
Column Name The column name in the raw database. N String
Array Indicates whether the query column is array or not. N Boolean
Precision The column's number of decimal digits. N Integer
Description Explanatory comments on the query column. N String
SQL Type The SQL type from java.sql.Types as Array, Char, Date etc. N Integer
GUI Field The GUI Field that will be used when the resource entity is inserted into report. N String
Scale The number of digits to the right of the decimal point for the query column value. N Integer
Nullable The nullability of values in the designated query column. 0 indicates the column is not null; 1 indicates it is null. N Integer
Original Time Zone The original time zone of the query column. N String