It's all about the answers!

Ask a question

workItem Query on specific approver and specific approval type


Moti Wertheimer (18913628) | asked Jul 28 '14, 7:45 a.m.
JAZZ DEVELOPER
 Hi,

Suppose I am using "Approval" type for Dev. approval and "Verification" for QA approval.
Now I want to create a query that will give me all defects that are pending for verification and are set for Dev. (so I will change the verifyier to QA - since Dev. shouldn't do it in my process)
The problem is that a query can select type of approval and name of approver seperately. no way to bind them and tell RTC to give me work item that this kind of approval is pending on that approver.

Hope I clarified myself enough, and will glad to have a solution!
Thanks,
Moti

Comments
Ralph Schoon commented Jul 28 '14, 9:22 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

Moti, I am not sure what you want to do and where the problem lies. Can you describe the example data and what you see better? Can you provide a screenshot of your query?


Moti Wertheimer commented Jul 28 '14, 9:59 a.m. | edited Jul 28 '14, 10:03 a.m.
JAZZ DEVELOPER

Hi Ralph, Sure, this is complicated and I will try to describe: 


Two defects 1 and 2. Two contributors: "Dev" and "QA"
Two approval descriptor types: "Verification" and "Approval"
Defect 1 : approval pending on Dev, verification pending on Qa
Defect 2 : approval pending on Dev, verification pending on Dev 
 
My logic is that I don't want that Dev will do verifications, only approvals.
So I will try to find this wrong situation and correct it.
Logically, query would be: find all defects that has a verification that is pending on dev. (approv. descriptor type = "verification")
Currently I can do something like that (let's say "dev" is "Moti")
<ADDING SCREENSHOT>  

But this is wrong and will return both defect 1 and defect 2.
Since the interpretation of this query is: approval (of any type) by dev, and approval type is verification.

Is any way to COUPLE the two conditions?


Moti Wertheimer commented Jul 28 '14, 9:59 a.m.
JAZZ DEVELOPER

Screenshot:


Ralph Schoon commented Jul 28 '14, 10:23 a.m. | edited Jul 28 '14, 11:10 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

I just tried with 5.0 two work items one with an approval pending for me and one with a verification pending for me. It seemed to work first. However, looking a bit deeper, if I have a work item with an approval as well as a verification something breaks. The query returns the record if I am approver for the approval and someone else is approver for the verification.

I would assume that the query mechanism does not look nested. It looks if there is an approver and if there is a matching approval. it does not look if the approver is actually approver for the specific approval.

There are several work items around approvals. You might explain your case.


sam detweiler commented Jul 28 '14, 10:24 a.m.

what is the wrapper?  AND?  here is my config of a similar


Ralph Schoon commented Jul 28 '14, 10:43 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

Hi Sam, I used the AND all must match.....

Here My query and output

If you look at 79 I am an approver, but for a verification - there is also an approval.



sam detweiler commented Jul 28 '14, 11:04 a.m.

ah yes.. the approval test doesn't look at the approver of the approval record

showing 5 of 7 show 2 more comments

Accepted answer


permanent link
Ralph Schoon (63.1k33645) | answered Jul 28 '14, 11:12 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Moti,

as per our discussion above, your observation seems to be correct and I am not aware how to fix that. You might want to open a work item.
Moti Wertheimer selected this answer as the correct answer

Comments
Moti Wertheimer commented Jul 29 '14, 4:07 a.m.
JAZZ DEVELOPER

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.