workItem Query on specific approver and specific approval type
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
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Jul 28 '14, 9:22 a.m.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
JAZZ DEVELOPER Jul 28 '14, 10:03 a.m.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>
Since the interpretation of this query is: approval (of any type) by dev, and approval type is verification.
Moti Wertheimer
JAZZ DEVELOPER Jul 28 '14, 9:59 a.m.Screenshot:
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Jul 28 '14, 11:10 a.m.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
Jul 28 '14, 10:24 a.m.what is the wrapper? AND? here is my config of a similar
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Jul 28 '14, 10:43 a.m.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
Jul 28 '14, 11:04 a.m.ah yes.. the approval test doesn't look at the approver of the approval record