Problems with Input Control (Single-select Query)

[danielobs]

Hi,

In Input Control (Single-select Query) I have this SQL query:

SET transaction READ WRITE;
DROP SEQUENCE IF EXISTS kkk;
CREATE TEMP SEQUENCE kkk START 1;
select kontrahent, nazwa, nip from (select nextval('kkk') as xx, kontrahent, nazwa, nip from kontra_a where nip like '356%'
       union  select nextval('kkk') as xx, -1, 'NO DATA', 'NO DATA') as aa where kontrahent>=0 or (kontrahent=-1 and xx = 1);



Unfortunately jasperserver returns error "Request returned no results"  and more but the pgAdmin of the same SQL returns the correct result.

What could be causing problems on the jasperserver?


Best regards,


Daniel