Fields Not Listed in Ad Hoc Editor

This documentation is an older version of JasperReports Server Administration Guide. View the latest documentation.

The Ad Hoc Editor supports only certain datatypes. If a Topic contains a field with an unsupported type, the field does not appear when you open the Topic in the Ad Hoc Editor. These are the datatypes supported in the Ad Hoc Editor:

•

java.lang.String

•

java.lang.Byte

•

java.lang.Short

•

java.lang.Integer

•

java.lang.Long

•

java.lang.Float

•

java.lang.Double

•

java.lang.Number

•

java.util.Date

•

java.sql.Date

•

java.sql.Time

•

java.sql.Timestamp

•

java.math.BigDecimal

•

java.math.BigInteger

•

java.lang.Boolean

•

java.lang.Object

Unsupported datatypes may occur when editing Topics manually, and sometimes with data sources for big data, in particular MongoDB. The connector for MongoDB uses the datatype of a given value in the last document containing that value, and errors in input files may cause unexpected types. For example, omitting the single quotes in the JSON format causes a string type to be interpreted as a numeric type.

If your Topic or Domain fields do not appear in the Ad Hoc Editor, you can enable logging on the following class to see details of fields with unsupported datatypes:

com.jaspersoft.ji.adhoc.metadata.AdhocTopicMetadata

For information about enabling logging, see Configuring System Logs.