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]

Reply via email to