IF Condition inside queryString Tag

[2001 JI Open Discussion]

By: swami - shakai2k

IF Condition inside queryString Tag

2002-10-02 16:42

Hi All

 

I want to do a IF Condition inside the queryString tag based upon the Parameters that I receive, to deceide upon which query must be sent across for building the final PDF report.

 

Thanks

 

Swami

 

 

By: Teodor Danciu - teodord

RE: IF Condition inside queryString Tag

2002-10-04 02:00

 

Hi,

 

You can only make that IF in your parent application,

outside JasperReports.

 

You decide what you query is before sending

it as a parameter.

 

That's seems to be the only way,

at least for the moment.

 

Thank you,

Teodor

 

 

 

By: Mike - fallofrome

RE: IF Condition inside queryString Tag

2002-10-04 17:41

I just did a quick and dirty implementation of query switching withing an XML -- note: this requires changing the DTD to accept multiple queryString elements that now have a name attribute.

<p>

Basically you can now have multiple queryString elements, each with a name=X or name=Y value. When you call JasperReport, you can pass a parameter called 'QUERY_KEY' with the value as 'X' or 'Y' and have it use the right query. This is obviously helpful as you can reuse the same template for multiple queries that may have different where clauses or parameterizations, but return the same structured ResultSet.

<p>

There may be errors (I cheesed out and just commented out the code in the Verifier), but here's a very dirty dump of the changes I made...

<p>

 

JRXmlLoader

 

CHANGED:

 

digester.addSetNext("jasperReport/queryString", "setQuery", "dori.jasper.engine.JRQuery");

TO:

 

digester.addSetNext("jasperReport/queryString", "addQuery", "dori.jasper.engine.JRQuery");

 

 

JRQueryFactory

 

ADDED:

JRXmlLoader xmlLoader = (JRXmlLoader)digester.peek(digester.getCount() - 1);

 

if (atts.getValue("name") == null || atts.getValue("name").trim().equals(""))

{

xmlLoader.addError(new Exception("Query name missing."));

}

 

query.setName(atts.getValue("name"));

ABOVE:

 

return query;

 

 

JRBaseQuery

 

ADDED:

 

protected String name = null;

 

public void setName( String name )

{

this.name = name;

}

 

public String getName()

{

return this.name;

}

 

 

BELOW:

 

protected JRBaseQuery()

{

}

 

 

 

JasperDesign

 

CHANGED:

 

 

public void setQuery(JRQuery query)

{

this.query = query;

}

 

TO:

 

public void addQuery(JRQuery query)

{

this.queryMap.put( query.getName(), query );

}

 

 

JRBaseReport:

 

CHANGED:

 

protected JRQuery query = null;

 

TO:

 

protected Map queryMap = new HashMap();

 

 

CHANGED:

 

query = JRBaseObjectFactory.getQuery(report.getQuery(), baseObjectsMap);

TO:

 

Map jrqueryMap = report.getQueryMap();

if (jrqueryMap != null && jrqueryMap.size() > 0)

{

queryMap = new HashMap();

for (Iterator i=jrqueryMap.entrySet().iterator(); i.hasNext(); )

{

Map.Entry e = (Map.Entry) i.next();

JRQuery query = (JRQuery) e.getValue();

query = JRBaseObjectFactory.getQuery(query, baseObjectsMap);

queryMap.put( query.getName(), query );

}

}

 

 

 

CHANGED:

 

public JRQuery getQuery()

{

return this.query;

}

 

TO:

 

public Map getQueryMap()

{

return this.queryMap;

}

 

 

 

JRQuery

 

ADDED:

 

public String getName();

 

 

 

JRReport

 

CHANGED:

 

public JRQuery getQuery();

 

TO:

 

public java.util.Map getQueryMap();

 

 

JRBaseFiller

 

CHANGED:

 

protected JRQuery query = null;

 

TO:

 

protected Map queryMap = new HashMap();

 

CHANGED:

 

this.query = jasperReport.getQuery();

 

TO:

 

this.queryMap = jasperReport.getQueryMap();

 

 

 

ADDED:

 

JRQuery query = null;

String queryKey = (String) parameters.get( "QUERY_KEY" );

if (queryKey != null)

query = (JRQuery) queryMap.get( queryKey );

else

query = (JRQuery) queryMap.values().iterator().next();

 

 

 

BELOW:

parameters.put("REPORT_CONNECTION", conn);

 

 

 

JRVerifier

 

COMMENT OUT INTERNALS FOR:

 

private void verifyQuery() throws JRException

 

 

JRXmlWriter

 

CHANGE:

 

if(report.getQuery() != null)

{

this.writeQuery(report.getQuery());

}

 

TO:

 

if(report.getQueryMap() != null)

{

this.writeQueryMap(report.getQueryMap());

}

 

CHANGE:

 

/**

*

*/

private void writeQuery(JRQuery query)

{

this.sbuffer.append("t<queryString><![CDATA[");

 

this.sbuffer.append(query.getText());

 

this.sbuffer.append("]]></queryString>n");

}

 

TO:

 

private void writeQueryMap(Map queryMap)

{

for (Iterator i=queryMap.entrySet().iterator(); i.hasNext(); ) {

Map.Entry e = (Map.Entry) i.next();

JRQuery q = (JRQuery) e.getValue();

this.sbuffer.append("t<queryString name="" + (String) e.getKey() + ""><![CDATA[");

this.sbuffer.append(q.getText());

this.sbuffer.append("]]></queryString>n");

}

}