When using the Zend_Gdata_Query library to fetch google calendar events using the example below my results are in th开发者_Python百科e opposite order that I need. Is there a simple variation on the
$query->setOrderby('starttime');
method that will achieve a list with the closest to now date at top and furthest in the future at the bottom?
Code below taken from http://framework.zend.com/manual/en/zend.gdata.calendar.html
$query = $service->newEventQuery();
$query->setUser('default');
// Set to $query->setVisibility('private-magicCookieValue') if using
// MagicCookie auth
$query->setVisibility('private');
$query->setProjection('full');
$query->setOrderby('starttime');
$query->setFutureevents('true');
Any help will be greatly appreciated.
You just have to set descending order instead of ascending.
$query->setSortOrder('d');
Valid values are ascending (with synonyms ascend and a) and descending (with synonyms descend and d).
As seen in the gData API reference.
$query->setSortOrder('a');
This will sort by current date to future date. a
stands for ascending.
if this does not do the trick, try:
$query->setOrderby('starttime');
$query->setSortOrder('a'); //ascending
精彩评论