Skip to main content

Query Column Properties

  • Updated

BackPrevious Topic  Next TopicNext

Query Column Properties

This topic describes the properties of a Column object in a query.

There are two types of the Column object in a query: table column and computed column. All the properties are read only for table columns, while some are editable for computed columns.

Property NameDescription
ArraySpecifies whether the column is an array type.

Data type: Boolean

Column NameShows the name of the column in the raw database.
CurrencyShows whether to control the SQL type of the formulas and summaries which reference the column if the column is of BigDecimal type.
  • true - Apply the BigDecimal type to the formulas and summaries and set their SQL Type to 3.
  • false - Apply normal data type to the formulas and summaries.

Data type: Boolean

Note icon Designer does not provide this property for a computed column.

DescriptionSpecifies the description of the object.

Data type: String

Display WidthSpecifies the display width of the object, which takes effect when you insert the object into reports. Type a numeric value to change the width. If you do not set the display width, Designer applies a default width to it automatically.

Data type: Float

Note icon After you set the Display Width property of an object and use the object while creating a data component with wizard, Designer may adjust its width according to the paper size.

NameShows the mapped name of the column in the catalog.
NullableSpecifies the nullability for the values of the object. Choose an option from the drop-down list.
  • true
    Select to indicate the object supports null values.
  • false
    Select to indicate the values of the object cannot be null.
  • unknown
    Select to indicate whether the values of the object can be null or not is unknown.

Data type: Enumeration

PrecisionSpecifies the precision for the values of the object. The default precision comes from data source metadata and defines the object's largest number of digits. The larger the precision is, the more memory it might take; however, the more accurate values you can get.

Data type: Integer

ScaleSpecifies the number of digits to the right of the decimal point for the values of the object.

Data type: Integer

SQL TypeSpecifies the SQL type of the object defined in Java. Choose an option from the drop-down list.

Data type: Integer

BackPrevious Topic  Next TopicNext