Jump to content
We've recently updated our Privacy Statement, available here ×

Problem creating UUID as a parameter


a.kamarski_1

Recommended Posts

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

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...