[Tickets #12558] Re: History: Add getLatestEntry($guid)

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/12558
------------------------------------------------------------------------------
  Ticket             | 12558
  Updated By         | Michael Rubinsky <mrubinsk at horde.org>
  Summary            | History: Add getLatestEntry($guid)
  Queue              | Horde Framework Packages
  Version            | Git master
  Type               | Enhancement
  State              | Feedback
  Priority           | 1. Low
  Milestone          |
  Patch              | 1
  Owners             |
------------------------------------------------------------------------------


Michael Rubinsky <mrubinsk at horde.org> (2013-08-12 19:28) wrote:

You will need to add a GROUP BY clause if you are returning  
non-aggregate fields in the query along with an aggregate field (MAX).  
This will work in mySql, but not pgsql. That being said, can you just  
get rid of the MAX and use ORDER BY history_modseq DESC  and add limit  
=> 1 instead? See Bug: 12476


Also, would be great if you could add a test as well :)