Hello,
> -----Original Message-----
> From: Phil Warrick [mailto:[EMAIL PROTECTED]
> Here is my model:
>
> [A] <1--n> [B] <1--n> [C] <1--1> [D]
> | |
> C1 C2
>
> I want to query for A objects using a C1 timestamp field as
> criteria (C1
> is a subclass of C and C does not have the timestamp field) and a D
> string field as criteria.
[..]
> It would be nice to reduce the DB hits and query for the A's
> directly as
> is possible in with standard OQL:
>
> select c1.b.a from c1 in C1.class
> where (c1.d.stringField = \"foo\" or
> c1.d.stringField = \"foofoo\") and
> e.theTimestamp >= timestamp '" + timeStamp1 + "' " and
> e.theTimestamp <= timestamp '" + timeStamp2 + "' "
>
> Is there any possibility that this is possible with PB queries?
I have been searching for a way to do such queries, too.
(see posting "nested queries, collection fields, and projections"
and also "repost: subqueries")
I have not found a solution or got any replies.
Best regards,
Olli
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]