Clarity PPM

Expand all | Collapse all

Help - Using DBeaver for OnDemand Sites

Jump to Best Answer
  • 1.  Help - Using DBeaver for OnDemand Sites

    Posted 04-23-2019 11:12 AM

    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



  • 2.  Re: Help - Using DBeaver for OnDemand Sites

    Posted 04-23-2019 11:26 AM

    Hi Pablo - 

     

    I'm not sure I understand your question correctly.

     

    Select count (*) will only give you the number of rows in this table.  Select * will give you all the data in the table.  The scrolling is just what the UI can show you on the screen.  If you kept scrolling, it would stop at 3298.

     

    Can you let me know exactly what you are expecting?

     

    -Stephanie



  • 3.  Re: Help - Using DBeaver for OnDemand Sites

    Posted 04-23-2019 12:42 PM

    Its stop at 2000 results

     

     

    I dont know if the problem is the dbeaver or what.

     

    Cheers,

    Pablo



  • 4.  Re: Help - Using DBeaver for OnDemand Sites
    Best Answer

    Posted 04-24-2019 01:39 AM

    It should be a DBeaver setting. DBeaver gets 200 results each time by default.

     

     

    In this screenshot, the configuration is set to get 200 results ('Result-set fetch size' setting), and the value next to it specifies that there are more than 200 results ('200+'), so scrolling would fetch additional rows.

     

    https://dbeaver.com/files/docs/wiki/navigation.html

     

    You can also check their old forums (archived) https://dbeaver.io/forum/index.php or their issue tracker https://github.com/dbeaver/dbeaver/issues for more info.

     

    Regards,

    Marc