EntityQuery with "global" restrictions

[alxs.alxs.gmx.de]

Hi,

I'm trying to implement something like the following statement using an extended EntityQuery object in Seam 2.2.0.GA

FROM Project p WHERE (p.owner.id=#{currentUser.id} AND p.deleted is null) AND (restriction1 OR/AND restriction2 OR restriction3)

restriction1 ... restriction3 are restrictions set by setRestrictionExpressionStrings() method while

(p.owner.id=#{currentUser.id} AND p.deleted is null)

is always added to the statement.

The problem is that the EntityQuery is building the query like

FROM Project p WHERE (p.owner.id=#{currentUser.id} AND p.deleted is null) AND/OR (restriction1 OR/AND restriction2 OR restriction3)

This means that using OR as restriction logic operator will erase my global restriction

(p.owner.id=#{currentUser.id} AND p.deleted is null)

Is there some way I can use EntityQuery to fulfill this task or do I have to implement all by myself?

Thanks,
Alex

[sean.tozer]

I'm not sure if EntityQuery would support something like that. I would suspect not.

If it can't, you could still use EntityQuery, but overwriting the relevant parsing method to do what you want it to. That would leave all the other functionality intact.

[alxs.alxs.gmx.de]

I've already been looking into EntityQuery and Query.
The simplest would be indeed overwriting the parsing methods. Unfortunately they rely on private fields and I would have to reimplement almost EnityQuery and Query completely.

[lvdberg]

Hi,

You could add the necessary IN-annotation and override the normal getEjbql() and add the additional restrictions.

It's just providing the correct query-string to the entitymanager.Putting EL-strings in the query is helpful, but  NOT necessary. It works the same by some concatting.

Leo