AnsweredAssumed Answered

Help - Using DBeaver for OnDemand Sites

Question asked by PabloMC on Apr 23, 2019
Latest reply on Apr 24, 2019 by Marc_Buigues

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

Outcomes