View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
15635 | Feature requests | RemoteControl | public | 2019-12-02 02:19 | 2019-12-02 02:19 |
Reporter | DeveloperChris | Assigned To | |||
Priority | none | Severity | feature | ||
Status | new | Resolution | open | ||
Summary | 15635: 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.
| ||||
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;"; | ||||
Tags | No tags attached. | ||||
Bug heat | 0 | ||||
Story point estimate | |||||
Users affected % | |||||
Date Modified | Username | Field | Change |
---|---|---|---|
2019-12-02 02:19 | DeveloperChris | New Issue |