It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,874

question asked: May 10 '10, 3:22 p.m.
question was seen: 3,940 times
last updated: May 10 '10, 3:22 p.m.

Related questions

problem with query logic for approvals

0
Brian Wolfe (256●1●37●25) | asked May 10 '10, 3:22 p.m.
I want to find workitems where the verification approval was Approved by other than a specific set of people.

I cannot get the query to deal with the case of a workitem with 2 approvals on it -- I can include an AND condition inside the query which has Approval type is verification and Approval is not X, Y or Z and Approval descriptor cumulative status is Approved, but this does not distinguish the approvers between 2 approvals on the same workitem --it does not tie the approver to the type selected so if there is any approval on the workitem by someone else, it returns the workitem in the result set.

Any suggestions are appreciated

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Ralph Schoon (63.5k●3●36●46) | answered May 11 '10, 3:16 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
I want to find workitems where the verification approval was Approved by other than a specific set of people.

I cannot get the query to deal with the case of a workitem with 2 approvals on it -- I can include an AND condition inside the query which has Approval type is verification and Approval is not X, Y or Z and Approval descriptor cumulative status is Approved, but this does not distinguish the approvers between 2 approvals on the same workitem --it does not tie the approver to the type selected so if there is any approval on the workitem by someone else, it returns the workitem in the result set.

Any suggestions are appreciated


Brian,

I have similar issues with a condition such as

All Work items type=T in State=S AND (For all children (Child>type=CT implies Child>State=CS))

It seems if one child qualifies the query qualifies. I would be interested in getting more detail on how such things could be solved.

Ralph

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.