<?xml version="1.0" encoding="utf-8"?>
<rss xmlns:atom="http://www.w3.org/2005/Atom" version="2.0"><channel><title>Answers to: How to count all rows in the database</title><link>https://answers.axonivy.com/questions/3837/how-to-count-all-rows-in-the-database</link><description>&lt;p&gt;Hi all,
Currently, I want to know in the database have many records and I try to use &lt;code&gt;businessDataRepository.search(t.getClass()).execute().count();&lt;/code&gt;, but this one just returns for me 10 rows by default. 
For example: in the database, I have 10.000 records, and I want to return this number.&lt;/p&gt;
&lt;p&gt;Do we have any API to do this case?&lt;/p&gt;</description><atom:link href="https://answers.axonivy.com/questions/3837/how-to-count-all-rows-in-the-database" rel="self"></atom:link><language>en</language><lastBuildDate>Thu, 06 Jun 2019 07:08:14 -0400</lastBuildDate><item><title>Answer by vagabond</title><link>https://answers.axonivy.com/questions/3837/how-to-count-all-rows-in-the-database/3838</link><description>&lt;p&gt;&lt;a href="https://developer.axonivy.com/doc/7.0.latest/PublicAPI/ch/ivyteam/ivy/business/data/store/search/Result.html#totalCount--"&gt;https://developer.axonivy.com/doc/7.0.latest/PublicAPI/ch/ivyteam/ivy/business/data/store/search/Result.html#totalCount--&lt;/a&gt;&lt;/p&gt;</description><dc:creator xmlns:dc="http://purl.org/dc/elements/1.1/">vagabond</dc:creator><pubDate>Thu, 06 Jun 2019 07:08:14 -0400</pubDate><guid>https://answers.axonivy.com/questions/3837/how-to-count-all-rows-in-the-database/3838</guid></item></channel></rss>