Using parameters in SQL query. Jaspersort Studio 5.5

[jvmolto]

Hi,

with iReport I use the following query without error, but with Jaspersort Studio I get the errors marked in red

SELECT $P!{parTabla}.*,almdes      (==> mismatched input '.' expecting 'FROM')
FROM  $P!{parTabla}, alm
WHERE almcod=almlalm AND $P!{parWhere}
ORDER BY $P!{sqlOrden}               (==>  no viable alternative at input $P!{sqlOrden})

How to do this with jaspersoft studio?

Thanks in advance

 

[bbaley]

I think

 $P!{parTabla}.

should be

 $P{parTabla}.

(where did the exclamation mark come from?)

[ilona]

There has been a change in the syntax. 

$P{parametername} is the old format and will not correct with null values. (Also, the ! in your SQL query shouldn't be there.)

It is best to use the new format: $X{EQUAL,fieldname,parametername}

Regards,
Ilona

[Ankur Gupta]

Hi ilona,

I just wanted to ask you about the changes in the new format, regarding the dynamic queries, with this I mean that

 

Earlier for the queries to be dynamic what we did that is that we could store the whole SQL in a format of String as the default expression of the parameter, and then used that parameter in the query as $P!{parameter}

 

Please throw some light on the change in the new version.

 

Any Help is appreciated.

 

Thanks

Ankur Gupta

[Ankur Gupta]

Hi jvmolto,

I have created a video for dynamic queries in the Jasper Soft Studio, and what I noticed is the error which is coming does not affect the output 

 

Hope that this helps.
Thanks
Ankur Gupta
http://ankurthetechie.blogspot.in/

[Giulio Toffoli]

Hi jvmolto,

the syntax of your query seems ok, what's the problem with Jaspersoft Studio? If the syntax highlighting suggests an error, you can ignore it, the query should work normally anyway.

Thanks

Giulio