a.kamarski_1 Posted December 20, 2019 Share Posted December 20, 2019 Hello, I am trying to generate a report with jaspersoft studio. Everithing works fine until I try to replace a value in the sql query with a parameter.The parameter is not string or integer value.I am talking about UUID.Fhe first query looks like this and it works perfectly:SELECT field_name_a, field_name_bFROM table_nameWHERE id = 'b9c4bace-2267-11ea-978f-2e728ce88125'[/code]The second one is like that:SELECT field_name_a, field_name_b,FROM table_nameWHERE id = $P{id}[/code]When I click on data preview and then refresh preview data I get exception:Error executing SQL statement for: data.Details:ERROR: operator does not exist: uuid = character varyingHint: No operator matches the given name and argument type(s). [/code]Do you have any idea how and why the id as parameter is actually breaking my query? And suggestions what can I try to fix this problem?I will be very thankful if someone can help with advise!Tnx in advance 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