I need some data from the database and am trying to use Piwik’s existing methods. In particular, I worked now for a while with the getLastVisitsDetails to get what I need. E.g;
$requestLastVisits = ‘method=Live.getLastVisitsDetails
Now the thing is, there is a massive amount of data I get when making this call. There are actually many column I could drop as I don’t use them.
For now, I am filtering in PHP but I was wondering whether
a) there is some solution here (maybe with segments?)
b) I should write my own sql calls if I want some precise data
( c) doing this in PHP is ok)
As for the ordering, is there a way to define the column to sort on when using this function?