[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         | Thomas Jarosch <thomas.jarosch at intra2net.com>
  Summary            | History: Add getLatestEntry($guid)
  Queue              | Horde Framework Packages
  Version            | Git master
  Type               | Enhancement
  State              | Feedback
  Priority           | 1. Low
  Milestone          |
  Patch              | 1
  Owners             |
------------------------------------------------------------------------------


Thomas Jarosch <thomas.jarosch at intra2net.com> (2013-08-12 20:31) 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

ok, can do.

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

I knew you would say that :o)

I'll revisit this probably after my holidays (=October). The latest changes
to the Kolab Horde History already make use of it but as my
pull request doesn't see any sign of live, it's not a problem anyway :P