Hi there, we use to connect to the onDemand sites of ppm via Dbeaver, when we create a query the result shown is limited, for example.
SELECT count(*) FROM scXXXXX.ODF_CA_INV the result is 3298
but if i do
SELECT * FROM scXXXXXX.ODF_CA_INV
its return 200 records, if I scroll a get 200 more records, and so on.
Is there any limitation on the query to Jasper or is any configuration on the JDBC driver, or the DBeaver.
This is what i user
jdbc:jaspersoft@https://cppmrpt103.ondemand.ca.com/reportservice;datasource=/ca_ppm/data_sources/CA_PPM_BEAN;pagesize=500
Cheers,
Pablo