https://www.redmine.org/https://www.redmine.org/favicon.ico?16793021292013-03-11T09:21:21ZRedmineRedmine - Feature #13275: Add query parameters/filter for listing time entries via REST APIhttps://www.redmine.org/issues/13275?journal_id=465412013-03-11T09:21:21ZKnut Meyer
<ul></ul><p>Hi,</p>
<p>here I would like to name one other filter condition</p>
<ul>
<li>spent on</li>
</ul>
<p>Thanks!<br />Knut</p> Redmine - Feature #13275: Add query parameters/filter for listing time entries via REST APIhttps://www.redmine.org/issues/13275?journal_id=498452013-06-04T16:38:14ZBob Pack
<ul></ul><p>+1. This makes the "time entries" part of the API very useful. Without it, it's needlessly intensive to do simple things. I think the most key filter would be Knut's "spent on" filter suggestion.</p> Redmine - Feature #13275: Add query parameters/filter for listing time entries via REST APIhttps://www.redmine.org/issues/13275?journal_id=498482013-06-04T16:47:06ZBob Pack
<ul></ul><p>Should have known it already exists! Great.<br />This works just fine on my server (2.2.2)<br /><a class="external" href="http://&lt;redmine">http://&lt;redmine</a> URL>/time_entries.xml?spent_on=%3E%3C2013-05-01|2013-05-31</p>
<p>Also tried it with issue_id and project_id, which worked fine as well.</p> Redmine - Feature #13275: Add query parameters/filter for listing time entries via REST APIhttps://www.redmine.org/issues/13275?journal_id=500982013-06-18T09:18:45Zshawn gao
<ul></ul><p>hi man, the url can't work on my server. They just ingore the parameter like "spent_on=%3E%3C2013-05-01|2013-05-31" <br />can you tell me why would that happen<br />thanks!</p> Redmine - Feature #13275: Add query parameters/filter for listing time entries via REST APIhttps://www.redmine.org/issues/13275?journal_id=504642013-07-11T10:05:10ZJuozapis Juozapauskiksi
<ul></ul><p>Bump<br />Is there any news regarding this one?<br />Spent on is working, but updated_on created_on is not :(</p> Redmine - Feature #13275: Add query parameters/filter for listing time entries via REST APIhttps://www.redmine.org/issues/13275?journal_id=506302013-07-18T10:19:19ZJuozapis Juozapauskiksi
<ul></ul><p>Bump. Any news on this one? <br />Sorry, but I think this is critical one for Redmine integration.</p> Redmine - Feature #13275: Add query parameters/filter for listing time entries via REST APIhttps://www.redmine.org/issues/13275?journal_id=506532013-07-19T05:29:16ZToshi MARUYAMA
<ul><li><strong>Has duplicate</strong> <i><a class="issue tracker-2 status-5 priority-4 priority-default closed" href="/issues/12763">Feature #12763</a>: Add filtering capability to time entries REST API</i> added</li></ul> Redmine - Feature #13275: Add query parameters/filter for listing time entries via REST APIhttps://www.redmine.org/issues/13275?journal_id=507692013-07-25T11:04:33ZJuozapis Juozapauskiksi
<ul></ul><p>Bump. Any news on this one here?</p> Redmine - Feature #13275: Add query parameters/filter for listing time entries via REST APIhttps://www.redmine.org/issues/13275?journal_id=509372013-08-01T13:16:12ZJuozapis Juozapauskiksi
<ul></ul><p>Any news regarding this one?</p> Redmine - Feature #13275: Add query parameters/filter for listing time entries via REST APIhttps://www.redmine.org/issues/13275?journal_id=511262013-08-08T13:10:26ZJuozapis Juozapauskiksi
<ul></ul><p>Bump. Any news?</p> Redmine - Feature #13275: Add query parameters/filter for listing time entries via REST APIhttps://www.redmine.org/issues/13275?journal_id=520782013-09-26T06:52:47ZJuozapis Juozapauskiksi
<ul></ul><p>Bump.</p> Redmine - Feature #13275: Add query parameters/filter for listing time entries via REST APIhttps://www.redmine.org/issues/13275?journal_id=576442014-07-20T03:39:38ZBob Pack
<ul></ul><p>shawn gao wrote:</p>
<blockquote>
<p>hi man, the url can't work on my server. They just ingore the parameter like "spent_on=%3E%3C2013-05-01|2013-05-31" <br />can you tell me why would that happen<br />thanks!</p>
</blockquote>
<p>Sorry, didn't see this till now. If you're using the exact same query I used before, it could be a permissions issue perhaps? Make sure the API token you are using has appropriate rights? I can't think of any other reason the same query that works on mine wouldn't work on yours, unless it's a version difference (as I mentioned, I am on a 2.2.2 build)</p> Redmine - Feature #13275: Add query parameters/filter for listing time entries via REST APIhttps://www.redmine.org/issues/13275?journal_id=647552015-07-09T14:20:22ZV Lindell
<ul></ul><p>As previously mentioned this can already be done "/time_entries.xml?spent_on=><2015-06-01|2015-06-30".</p>
<p>API Documentation should be updated by the filtering posibilities already available.</p> Redmine - Feature #13275: Add query parameters/filter for listing time entries via REST APIhttps://www.redmine.org/issues/13275?journal_id=652732015-08-04T10:13:58ZTommaso Visconti
<ul></ul><p>It's also possible to filter by user id:</p>
<pre>
/time_entries.json?user_id=<ID>
/time_entries.json?user_id=me
</pre>
<p>This is totally undocumented!!!</p> Redmine - Feature #13275: Add query parameters/filter for listing time entries via REST APIhttps://www.redmine.org/issues/13275?journal_id=670992015-11-05T06:12:01ZEugene Terekhov
<ul></ul><p>Filtering by created/updated date would be very appreciated.</p>
<p>That <code>spent_on</code> filter just isn't enough.</p> Redmine - Feature #13275: Add query parameters/filter for listing time entries via REST APIhttps://www.redmine.org/issues/13275?journal_id=676442015-12-04T09:04:14ZDain Gosbee
<ul></ul><p>I agree with Eugene that the spent_on filter is too limiting. I also would heavily appreciate being able to filter by created_on/updated_on.</p>
<p>+1 to Eugene´s post.</p> Redmine - Feature #13275: Add query parameters/filter for listing time entries via REST APIhttps://www.redmine.org/issues/13275?journal_id=691752016-02-11T10:01:35ZThibaut Tropardy
<ul></ul><p>For ticket filter<br /><pre>
/time_entries.json?issue_id=<ID>
</pre></p> Redmine - Feature #13275: Add query parameters/filter for listing time entries via REST APIhttps://www.redmine.org/issues/13275?journal_id=704322016-04-18T09:07:14ZValentin Rudikov
<ul></ul><p>Hello! Also it would be good to support filtering by multiple users:<br />/time_entries.json?user_id=[123,456]<br />It will reduce requests count - no need to query server multiple times(for each user)</p> Redmine - Feature #13275: Add query parameters/filter for listing time entries via REST APIhttps://www.redmine.org/issues/13275?journal_id=742522016-10-28T11:20:43ZAnonymous
<ul><li><strong>File</strong> <a href="/attachments/16947">0001-Expose-created_on-field-for-time-entry-queries.patch</a> <a class="icon-only icon-download" title="Download" href="/attachments/download/16947/0001-Expose-created_on-field-for-time-entry-queries.patch">0001-Expose-created_on-field-for-time-entry-queries.patch</a> added</li></ul><p>Hello, I've run into this issue as well and wrote a small patch to expose the <code>created_on</code> field to the REST API. I'd welcome any feedback, especially on further steps to include it into Redmine proper.</p> Redmine - Feature #13275: Add query parameters/filter for listing time entries via REST APIhttps://www.redmine.org/issues/13275?journal_id=848072018-05-02T17:41:21ZPablo Díaz
<ul></ul><p>Somebody know howto filter by time interval?.</p>
<p>If i use the URL (replacing redmineUrl by a real url and keyValue with a valid key value): <a class="external" href="https://redmineUrl/time_entries.json?key=keyValue&spent_on=2018-03-01">https://redmineUrl/time_entries.json?key=keyValue&spent_on=2018-03-01</a> it returns a valid time entries for this day but if I use the interval filter as said in manualPage: <a class="external" href="http://www.redmine.org/projects/redmine/wiki/Rest_TimeEntries#spent_on-filter">http://www.redmine.org/projects/redmine/wiki/Rest_TimeEntries#spent_on-filter</a> such us: !https://redmineUrl/time_entries.json?key=keyValue&spent_on=><2018-04-01|2018-04-30 It returns the same values as doesn't write any spent_on date filter.</p>
<p>Anyone knows how to use spent_on date filters? May be a bug?</p>
<p>My redmine version is 3.3</p> Redmine - Feature #13275: Add query parameters/filter for listing time entries via REST APIhttps://www.redmine.org/issues/13275?journal_id=848172018-05-03T10:50:00ZPablo Díaz
<ul></ul><p>I've found a solution for comment 20.</p>
<p>If I put at the end of URL <em>&limit=5000</em> I get the <em>time_entries</em> for the given interval with a correct result.</p>
<p>That is, for the example wrote on comment 20 the final url would be:</p>
<p>!https://redmineUrl/time_entries.json?key=keyValue&spent_on=><2018-04-01|2018-04-30&limit=5000</p>