View Issue Details

This bug affects 1 person(s).
 0
IDProjectCategoryView StatusLast Update
15635Feature requestsRemoteControlpublic2019-12-02 02:19
ReporterDeveloperChris Assigned To 
PrioritynoneSeverityfeature 
Status newResolutionopen 
Summary15635: Add count feature to export responses
Description

Currently if you want to export a small number of responses there is no API way to determine the last response id to use.

Because you cannot assume that record ID's are contiguous you cannot simply add the count to the Record ID.

https://api.limesurvey.org/classes/remotecontrol_handle.html#method_export_responses

Being able to specify the number of records to return would be very handy.

Using the API currently stands I can only see two ways to achieve the desired result.

Pick a small number of records to return in a loop until the count is satisfied or use a separate call into the database to determine what the last record id is.

  • The former is slow and cumbersome
  • The latter assumes access to the database and renders the remote control api redundant.
Additional Information

The sql I am currently using to grab 'count' records

"SELECT MAX(id) as maxid FROM (SELECT id FROM {$table} where id >= {$from_id} order by id ASC limit {$count}) ids;";

TagsNo tags attached.
Bug heat0
Story point estimate
Users affected %

Users monitoring this issue

There are no users monitoring this issue.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2019-12-02 02:19 DeveloperChris New Issue