Thank you Hugi,
Yes, that resolves my problem. This helps a lot!
Andrew
-Original Message-
From: Hugi Thordarson [mailto:h...@karlmenn.is]
Sent: Wednesday, June 22, 2016 11:54 AM
To: user@cayenne.apache.org
Subject: Re: Effective dated records
Hi Andrew.
If I understand your problem
Hi Andrew.
If I understand your problem correctly you should be able to achieve this by
setting a fetch limit of 1 on your query and sorting by date in descending
order. It's the same as adding LIMIT to an SQL statement.
For example, let’s assume you record the movement of paintings in an entity
