ERXQ allows you to chain qualifiers. However, I believe to traverse the
relationships you need the famous .dot()
qualifier =
Product.EDOC.dot(Ref.STATEMENT).dot(Statement.comments).contains("aword")
I dont' know the exact names of your relations and if you were typing the
qualifier, typeahead should help.
Is this what you are looking for? There are a few examples in the mailing list.
http://www.mail-archive.com/[email protected]/msg41116.html
Ted
On Jul 8, 2013, at 7:03 AM, Markus Ruggiero <[email protected]> wrote:
> I am not even able to really figure the plain SQL statement :-((
>
> Model:
>
> product <-->> edoc <-->> refs <<-> statement
>
> refs has a comments and a status attribute
>
> An edoc is defined by its assigned statements. Each single assignment can
> have a specific status and comment. Which statements out of a pool are
> assigned is determined by the type of edoc. Each edoc is product specific
> with possibly specific comments and status. Thus the same statement can be
> assigned to many edocs (one edoc of a given type per product).
>
> User wants to find edocs of a specific type, thus the list of assigned
> statements is already given.
>
> The list of statements for the given edoc type is shown inside a repetition
> where the user can specify for each possible ref a comment and a status as
> search criteria. I need to build a qualifier to retrieve edocs that have
> references to statements and the reference is qualified by status and comment.
> The whole thing lives inside D2W. The list is shown with a custom property
> level query component in a standard D2WQuery page, the result is then shown
> in a standard D2WList page. My intention is to build the display group
> qualifier incrementally inside the setComment() and setStatus() accessor
> methods in each pass through the WORepetition. D2W will then take care of any
> other property level query value on the rest of the query page. This all
> works, it's just that I have not yet succeeded in building that particular
> qualifier. Either I find too much data or I do not find anything at all.
>
> Example:
>
> Assume the list of assignable statements is S1... S10
> I show a repetition with 10 items (one item per statement)
> The users enters "foo" for the comment on line 3 (corresponding to statement
> S3) and "bar" on line 10 (corresponding to statement S10)
> The selection should now return all edocs where the reference to statement S3
> has the comment "foo" AND the reference to statement S10 has the comment
> "bar", it must not return edocs where only one condition is met. To make
> things even more interesting the user might also throw in some selection on
> status, either in combination with a comment or individually. I need all the
> edocs that fulfill ALL criteria.
>
> It looks so innocuous but when I try to come up with something it becomes
> more and more complicated. Can anyone help?? The
>
> Thanks a lot
> ---markus---
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list ([email protected])
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/webobjects-dev/tedpet5%40yahoo.com
>
> This email sent to [email protected]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
