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
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?
Its stop at 2000 results
I dont know if the problem is the dbeaver or what.
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.
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.