STATE
To configure a state field, set the field type to STATE:
Filter
For the filter field, you can specify either a single-select or multi-select field. Here are examples of each:
Single-select
Provide the following in the WHERE clause of the SQL:
${filterIfNotNull:STATE,state = $STATE$}The filter field definition is as follows:
<CustomFilterField> <FieldRef category="PDF" levelType="ZBKS.Book"> <FieldName>State</FieldName> </FieldRef> <Type>STATE</Type> <SimpleMapping sqlName="STATE"/> <CustomModelName>Standard ZBKS.Book</CustomModelName></CustomFilterField>Multi-select
Provide the following in the WHERE clause of the SQL. Note the difference from the clause used for the single-select variation:
${filterIfNotNull:STATE,state IN $STATE$}The filter field definition is the same as single-select, except there's an extra attribute uiFieldRenderMode which tells the UI to display it as a checkbox group:
<CustomFilterField uiFieldRenderMode="ColumnarCheckboxesNoButtons"> <FieldRef category="PDF" levelType="ZBKS.Book"> <FieldName>State</FieldName> </FieldRef> <Type>STATE</Type> <SimpleMapping sqlName="STATE"/> <CustomModelName>Standard ZBKS.Book</CustomModelName></CustomFilterField>Following are the key points to note:
Type is set as STATE (Note the capital letters)
CustomModelName is used to fetch the states defined on model