[dev] History getByTimestamp

[Chuck Hagenbuch]

Quoting Mikael Geijer <mikael at nufort.net>:

> I guess you need a self-join, something like
> select a.category_id from horde_category_attributes a,
> horde_category_attributes b where a.category_id = b.category_id and
> (a.attribute_key = 'ts' and b.attribute_key = 'action') and (
> a.attribute_value > '1066379566' and b.attribute_value = 'update');
>
> Complicates it quite a lot. Maybe there's some simple way to work this out?

Not that I can think of so far, and yes, this is what is needed.

My best thought so far is to have some kind of an explicit marker in the
criteria array denoting that you need a new set of attributes (a join) to query
against.

-chuck

--
Charles Hagenbuch, <chuck at horde.org>
Born right the first time.