Fields Not Listed in Ad Hoc Editor

The Ad Hoc editor only supports certain data types. 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. The following data types are 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 data types may occur when editing Topics manually, and sometimes with data sources for big data, in particular MongoDB. The connector for MongoDB uses the data type 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 data types:

com.jaspersoft.ji.adhoc.metadata.AdhocTopicMetadata

For information about enabling logging, see Configuring System Logs.

Version: 
Feedback
randomness