= CURRENT_DATE - INTERVAL '10 DAY'
AND COALESCE(DATE("END_TIME"), CURRENT_DATE - INTERVAL '1 DAY') <= CURRENT_DATE
GROUP BY 1, 2, 3;]]>
<band height="35" isSplitAllowed="true" >
<staticText>
<reportElement
x="61"
y="5"
width="412"
height="18"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font pdfFontName="Helvetica-Bold" size="14" isBold="true"/>
</textElement>
<text><![CDATA[Job Scheduler - Order History Report]]></text>
</staticText>
<line direction="TopDown">
<reportElement
x="0"
y="25"
width="534"
height="0"
key="line"/>
<graphicElement stretchType="NoStretch" pen="1Point"/>
</line>
<line direction="TopDown">
<reportElement
x="0"
y="3"
width="534"
height="0"
key="line"/>
<graphicElement stretchType="NoStretch" pen="1Point"/>
</line>
</band>