Need help with building tricky qualifier
Need help with building tricky qualifier
- Subject: Need help with building tricky qualifier
- From: Markus Ruggiero <email@hidden>
- Date: Mon, 08 Jul 2013 13:03:40 +0200
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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden