How to create relative date parameters for Domain


I need to create a relative date parameter in Jaspersoft Studio 6.2.  I am using a domain and not a SQL data source.

I have googled "jaspersoft studio domain relative date" and searched for "domain relative date" in the community wiki.

The "best" results that I have found are listed below.

Unfortunately, all reference a SQL data source.  For example:
    <!--[CDATA[select * from test_table where $X{EQUAL, orderDate, dateRange}]]-->

Below you will find my:

  • parameter:  dateRange
  • queryField: dbo_RPT_OpportunityDeNorm.OpenDate
  • field: dbo_RPT_OpportunityDeNorm.OpenDate

    <parameter name="dateRange" class="">
    <queryString language="domain">
                <queryField id="dbo_RPT_OpportunityPracticeGroup.PracticeGroup_Name"/>
                <queryField id="dbo_RPT_OpportunityDeNorm.OpenDate"/>
                <queryField id="dbo_RPT_OpportunityDeNorm.OpportunityOutcome"/>
            <queryFilterString>dbo_RPT_OpportunityDeNorm.StatusLabel == &apos;Closed&apos;</queryFilterString>

    <field name="dbo_RPT_OpportunityDeNorm.OpenDate" class="java.sql.Timestamp">
        <fieldDescription><![CDATA[Open Date]]></fieldDescription>

What I don't understand is how to add the following condition:  $X{EQUAL,dbo_RPT_OpportunityDeNorm.OpenDate,dateRange}

Thank you for your assistance.

terry.davis's picture
Joined: Mar 13 2016 - 10:39am
Last seen: 6 months 1 week ago

0 Answers:

No answers yet