Can pickListCriteria be specified in the data source xml? If so, can you give an example of the syntax when there are multiple fields involved? This is the sort of thing I would imagine being able to do, but obviously this won't work with multiple "field" attributes in the same element.
I first tried this, which had no effect on the generated SELECT.
<pickListProperties pickListCriteria="{ATTDTPI:007, ATTDCTI:001}"/>
Code:
<field name="DRSN" type="text" title="Reason" length="3" detail="true" optionDataSource="IPATTDS" valueField="ATTDDSI" displayField="ATTDDSD"> <pickListCriteria field="ATTDTPI" value="007" field="ATTDCTI" value="001"/> </field>
<pickListProperties pickListCriteria="{ATTDTPI:007, ATTDCTI:001}"/>
Comment