[daisy] Query to find variants of which another language variant is older/newer

[Hofmann. David]

Hi,

I have the following problem:

We maintain documents in two languages. Normally, when someone edits the
English version, then normally he is supposed to update the German
version as well afterwards.

I want to find all document variants where someone forgot to do so.

That means:

*	Variant is German
*	It has an English Variant on the same branch
*	The German Variant is OLDER than the English Variant

 

However, I couldn't manage to find the right Query.

The Problem is, there is no function HasVariant() but only
DoesNotHaveVariant() (I couldn't manage to negate it neither with NOT
nor !)

Furthermore I found no way to compare [EnglishVariant].lastModified with
lastModified.

 

Is there a way to solve this with a Query? Otherwise I will simply
develop an extension.

 

Thank you for your help...

David

_________________________________________________________________________

SEEBURGER AG				Vorstand/Seeburger Executive Board:
Sitz der Gesellschaft/			Bernd Seeburger, Axel Haas, Michael Kleeberg
Registered Office:
Edisonstrasse 1				Vorsitzender des Aufsichtsrats/Chairperson of
D-75015 Bretten				the Seeburger Supervisory Board:
Tel.: 07252 / 96-0			Dr. Franz Scherer
Fax:  07252 / 96-2222
Internet: http://www.seeburger.de	Registergericht/Commercial Register:
e-mail: info at seeburger.de		HRB 240708 Mannheim
_________________________________________________________________________

Dieses E-Mail ist nur fur den Empfanger bestimmt, an den es gerichtet 
ist und kann vertrauliches bzw. unter das Berufsgeheimnis fallendes
Material enthalten. Jegliche darin enthaltene Ansicht oder Meinungs-
au?erung ist die des Autors und stellt nicht notwendigerweise die
Ansicht oder Meinung der Seeburger AG dar.
Sind Sie nicht der Empfanger, so haben Sie diese E-Mail rrtumlich
erhalten und jegliche Verwendung, Veroffentlichung, Weiterleitung,
Abschrift oder jeglicher Druck dieser E-Mail ist strengstens untersagt.
Weder die Seeburger AG noch der Absender (David Hofman)
ubernehmen die Haftung fur Viren; es obliegt Ihrer Verantwortung,
die E-Mail und deren Anhange (0) auf Viren zu prufen.

The present email addresses only the addressee which it targets and
may contain confidential material that may be protected by the
professional secret. The opinions reflected herein is not necessarily
the one of the Seeburger AG.
If you are not the addressee, you have accidentally got this email and
are not enabled to use, publish, forward, copy or print it in any way.
Whether the Seeburger AG, nor the sender (David Hofman) are
liable for viruses, being your own responsibility to check this email
and it attachments (0) for this purpose.
_________________________________________________________________________

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.cocoondev.org/pipermail/daisy/attachments/20070727/ab3d00e8/attachment.htm