How to pass array kind of structure (from report query) to SQL function?

[jigar.patel]

Hi,

 

I want to pass array kind of structure (from report query) to my PostgreSQL function which accepts text[] as input.

I tried String[] and ArrayList, but it gives compile time error saying "Parameter type not supported in query".

Then I tried passing it as a string ($P!{array_parameter}) but it gives error while deploying report to jasperserver saying: "The selected JRXML could not be parsed. You might have selected the wrong file."

Any Suggestions...!

[ernst_2]

You need to use the provided $X{} functions for such inputs.

Like: $X{IN, <column_name>, <parameter_name>}

Description: http://jasperreports.sourceforge.net/sample.reference/query/

[jigar.patel]

Thanks to ernst_2 for answering. But, That's not what I want. I want to pass my array to SQL function as an arguement, from report query. As for example,

SELECT * FROM my_function($P{my_array_parameter})

which will pass entire array in my PostgreSQL function and I will receive it in my function as I have set datatype text[] as arguement datatype in PostgreSQL function. Any Ideas...

[zh3ntil]

Hi,

As far as I know, there is no way to do that on studio . But, you can make it work by creating a StoredProcedure that parse your parameter string, convert to an array and pass to your function.

[kkumlien]

Hi Jigar,

the $P! syntax should work. Can you compile and display a report in iReport or Jaspersoft Studio?

Once that works, then if you don't manage to publish it to JasperReports Server please create a new question about that and let us know here. Thanks!