DOUBLE

SimpleMapping to map the field with the SQL parameter.

Following is an example of filter by a DOUBLE field.

Include the double column in the where clause. In the following example, PromotionalDiscount which is a double field from the book model is illustrated.

${filterIfNotNull:PROMOTIONAL_DISCOUNT,promotional_discount = $PROMOTIONAL_DISCOUNT$}

The filter should be defined as follows:

<CustomFilterField>
	<FieldRef category="PDF" levelType="ZBKS.Book">
		<FieldName>PromotionalDiscount</FieldName>
	</FieldRef>
	<Type>DOUBLE</Type>
	<Optional>true</Optional>
	<SimpleMapping sqlName="PROMOTIONAL_DISCOUNT"/>
</CustomFilterField>		

Following is an example of display a DOUBLE field.

Include the double column in the select clause. In the following example, PromotionalDiscount which is a double field from the book model is illustrated.

select promotional_discount PROMOTIONAL_DISCOUNT FROM ZBKS_Book

The retrieval should be defined as follows:

<CustomRetrievalField>
	<FieldRef levelType="ZBKS.Book" category="PDF">
		<FieldName>Promotional Discount</FieldName>
	</FieldRef>
	<Type>DOUBLE</Type>
	<SimpleMapping sqlName="PROMOTIONAL_DISCOUNT"/>
</CustomRetrievalField>		

Following are the key points to note:

LevelType in the FieldRef is pointed to Book, which is where the PromotionalDiscount field is defined.
Field Category is set to PDF(PreDefined Field)
Type is set as DOUBLE (Note the capital letters)
SimpleMapping is defined in the CustomRetrievalField
SimpleMapping is used to map the SQL parameter with the field name.