Parameterized Query Issue with {?}

0

Hi, 

Querys take longer in Jaspersoft then other query tools. My current theory is parameters from Jaspersoft could be the thing throwing off the query optimizer and taking longer than DBViz because of the '?' that is passed in the query. 

Is there a way to substute the '?' for something else when the query is built?

Thanks,

 

Example

query in Dataset query and Dialog box 

SELECT TOP 1
COL1,

COL2,

COL3
FROM TABLE1
WHERE  COL1 = $P{P1} AND COL2 LIKE $P{P2}

Query Sent 

SELECT TOP 1
COL1,

COL2,

COL3
FROM TABLE1
WHERE  COL1 = 1 AND COL2 LIKE '?'

 

CodyKrafft's picture
Joined: Jul 16 2020 - 11:46am
Last seen: 1 month 2 weeks ago

0 Answers:

No answers yet
Feedback
randomness