bbromonti Posted April 25, 2011 Share Posted April 25, 2011 Hi,i use jasper with iReport. I would like to test what queries sends iReport to the database (oracle)In the v$sql i have found the following condition:...and ANOESTACION IN (:1) and 0 = 0 and CODEALPHA2 like :2...I thought that Oracle would receive the query with the chosen filters. But when does it assign the chosen values of the filters? Bianca Link to comment Share on other sites More sharing options...
mdahlman Posted April 25, 2011 Share Posted April 25, 2011 That's how v$sql is supposed to work with bound variables. The values are being sent along with the SQL, but they aren't part of the SQL.I could guess that you're having a problem with the IN clause... but perhaps it's better if you post to describe any problem you're having.Regards,Matt Link to comment Share on other sites More sharing options...
bbromonti Posted April 26, 2011 Author Share Posted April 26, 2011 Thank you for your answer.The problem was just simple: the column to be filtered can have 2 vaules: 0 and 1. But these values were stored (who knows why) as space+1 and space+0.I have changed the multi-select-list-of-values to space+1 and space+0 and now the filter works fine. Bianca Post Edited by bbromonti at 04/26/2011 07:24 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now