Multi-Select Input Control w/ Domain Query - Selecting Multiples Causes Error?

0

  Being limited to Domain Queries I've had a helluva time getting reports to do what I want. Everything is a workaround, and now I'm stuck (again). I've got multi-select parameters that work, however, I can only select one value. If I try to select multiple values I get an error. If I'm understanding correctly, the reason for this is because I cannot use IN in a Domain query. How can I make my parameters work to let me select multiple values? (Parameters are Collections w/ nested strings).

Here's my Domain Query:

    <queryFilterString> LoadRefNum.QualifierName == &apos;CSTRF&apos; and LoadRefNum.RefNumValue != null and Load.DateTime_PlannedStart in (StartDate:EndDate) and Load.TransportModeName in (TransitMode) and Load.LoadTmsStatus in (TransitStatus)</queryFilterString>

 

Here's my Source Code:

  <parameter name="TransitMode" class="java.util.Collection" nestedType="java.lang.String" isForPrompting="false">
        <property name="com.jaspersoft.studio.js.ic.path" value="/public/Fastway/InputControls/TransitMode"/>
        <defaultValueExpression><![CDATA[new ArrayList(Arrays.asList(new String[] {"LTL"}))]]></defaultValueExpression>
    </parameter>
    <parameter name="TransitStatus" class="java.util.Collection" nestedType="java.lang.String" isForPrompting="false">
        <property name="com.jaspersoft.studio.js.ic.path" value="/public/Fastway/InputControls/TransitStatus"/>
        <defaultValueExpression><![CDATA[new ArrayList(Arrays.asList(new String[] {"InTransit"}))]]></defaultValueExpression>

 

Additionally, my source code and parameters for the above two parameters are identical (minus field names of course), but the default value expression only works for the first one. No matter what I do, I cannot get "InTransit" to be checked by default in the input control. It worked once, and I don't know what I did that made it stop working.

 

Any help y'all could give would be greatly appreciated.

zgadson's picture
11
Joined: Sep 24 2018 - 11:24am
Last seen: 2 days 23 hours ago

0 Answers:

No answers yet
Feedback
randomness