API getLastVisitsDetails - sorting a range of data


#1

I’m currently working with getLastVisitsDetails API method. I am attempting to receive paginated results sorted by idvisit. While the filter_limit and filter_offset attributes appear to be working, filter_sort_column and filter_sort_order do not seem to produce the proper results.

Consider the following example:
http://demo.piwik.org/?module=API&method=Live.getLastVisitsDetails&idSite=7&period=range&date=2014-04-01,2014-04-11&filter_limit=10&filter_sort_column=idVisit&filter_sort_order=desc&format=xml&token_auth=anonymous

Ordering DESC (which appears to be the default) The first result in the result set is a visit late on April 11th. This looks correct.

But, when you change to ASC:
http://demo.piwik.org/?module=API&method=Live.getLastVisitsDetails&idSite=7&period=range&date=2014-04-01,2014-04-11&filter_limit=10&filter_sort_column=idVisit&filter_sort_order=asc&format=xml&token_auth=anonymous

The results to not change order. The first result is from late on April 11th. My expectation would be that upon sorting ASC, the first result would be the first visit on April 1st.

Should this functionality be working, or is the report limited to viewing the visit log in descending order from your closing date in the configured date range?


(Matthieu Aubry) #2

This is a “missing feature”, but we could add support for it. feel free to create a ticket at: http://dev.piwik.org/ for your request