Yeah, I started thinking about that ...
there is not a lot of data but I'll probably use a different solution.
Johnny
On Jan 15, 2010, at 5:55 PM, Mike Schrag wrote:
> this is REALLY non-optimal fetching here, but if it works for you, cool ...
>
> ms
>
> On Jan 15, 2010, at 10:53 PM, Johnny
Well at least there is a good reason I didn't find it.
After thinking about the query as SQL I decided to just use the "in" qualifier.
i.e. Artist.fetchMG_Artists(ec(),
Artist.ARTWORKS.in(Artwork.fetchAllMG_Artworks(ec())), so);
Thanks for the help.
Johnny
On Jan 15, 2010, at 4:00 PM, Mike Sc
this is REALLY non-optimal fetching here, but if it works for you, cool ...
ms
On Jan 15, 2010, at 10:53 PM, Johnny Miller wrote:
> Well at least there is a good reason I didn't find it.
>
> After thinking about the query as SQL I decided to just use the "in"
> qualifier.
>
> i.e. Artist.fetc
oh .. actually this is a qualifier in my own code that isn't in wonder. whoops.
i think there's a houdah one for this?
On Jan 15, 2010, at 8:44 PM, Johnny Miller wrote:
> I'm not familiar with that qualifier (but I've sure been looking for it :) ).
> Can you please point me in the right direct
I'm not familiar with that qualifier (but I've sure been looking for it :) ).
Can you please point me in the right direction or provide an example?
On Jan 15, 2010, at 3:39 PM, Mike Schrag wrote:
> isNotNull only really makes sense on a to-one ... you probably want to use
> the to-many count
isNotNull only really makes sense on a to-one ... you probably want to use the
to-many count qualifier (or something like it) for a to-many.
On Jan 15, 2010, at 8:38 PM, Johnny Miller wrote:
> Hi Mike,
>
> The two entities Artist <->> Artwork
>
> The qualifier is Artist.ARTWORKS.isNotNull()
>
Hi Mike,
The two entities Artist <->> Artwork
The qualifier is Artist.ARTWORKS.isNotNull()
The generated SQL
Thanks a lot,
Johnny
On Jan 15, 2010, at 3:21 PM, Mike Schrag wrote:
> there's more than one entity at play here ... please include example entity
> names and the exact generated
there's more than one entity at play here ... please include example entity
names and the exact generated sql.
On Jan 15, 2010, at 8:18 PM, Johnny Miller wrote:
> Hi,
>
> I'm trying to get a list of entities who has a relationship that is not null
>
> so my ERXKey qualifier looks like
>
> ent
Hi,
I'm trying to get a list of entities who has a relationship that is not null
so my ERXKey qualifier looks like
entity.relationship.isNotNull()
When I look at the SQL generated it is making sure that the primary key of the
entity is not null and it is not looking at the relationship at all.
