Where is your schema language sl?

[gowsy]

Hi

Can u tell me that where can i see the sl schema of jasperserver. Now i am in critical situation to complete my report module

 

i am using jasperserver version 3.1

 

i want to generate report for past 24 hours.I dont know how to use <queryFilterString>

 

Adhoc getnerated the jrxml file in that i can see the below line for between date condition

<queryFilterString>MODIFIEDTIME in (d'2009-08-21':d'2009-08-22')</queryFilterString>

 

The above is fixed date but i want the one day data so i replaced as below

<queryFilterString>MODIFIEDTIME in (CONCAT("d'", subdate(current_date,1),"'",":d'",current_date,"'"))</queryFilterString>

 

but it is showing null pointer exception. how can i solve this problem. i want to give between date dynamically .

 

Please hepl me

 

Thanks,

 

Syed.

[swood]

The "sl" query language is used by domains in Jaspersoft Professional. It is not SQL. The domains are used to determine what exact query is to be generated.

 

You need something like:

 

<queryFilterString>MODIFIEDTIME in (yesterday():today())</queryFilterString>

 

yesterday() and today() can be defined as functions in WEB-INF/applicationContext-semanticLayer.xml

 

The *SQLGenerator beans define mapping from a function name to the SQL that gets generated. You need something like:

 

                <entry key="today">
                    <value>"now"</value>
                </entry>

 

where "now" is something that will work for your flavour of database.

 

There are different mappings available for the different databases.

 

 

Sherman

Jaspersoft