× {{alert.msg}} Never ask again
Get notified about new tutorials RECEIVE NEW TUTORIALS

Get more than 100 issues from redmine

Simone Carletti
Mar 21, 2015
<p><code>having</code> is a SQL operator. Here you are not using <code>ActiveRecord</code>, but <code>ActiveResource</code> that performs an HTTP request. For security, a REST API will never allow you (or should never allow you) to provide SQL fragments to be arbitrary executed on the database.</p> <p>If you read the <a href="http://www.redmine.org/projects/redmine/wiki/Rest_Issues" rel="nofollow">API documentation for Redmine</a> you will notice there is no <code>having</code> parameter. It's likely you invented it.</p> <p>What you need to do in order to fetch all the issues, is to use the pagination <code>offset</code> and <code>limit</code>.</p> <pre><code>Paging example: GET /issues.xml?offset=0&amp;limit=100 GET /issues.xml?offset=100&amp;limit=100 </code></pre> <p>This tip was originally posted on <a href="http://stackoverflow.com/questions/26775981/Get%20more%20than%20100%20issues%20from%20redmine/26776103">Stack Overflow</a>.</p>
comments powered by Disqus