Complex RTC queries on depends relations - multiple criteria to same depends
Hi all,
what I'm trying to do, is to get a list of all work item that:
- Has a depends relation to something UNRESOLVED
- AND for that depends, it is NOT in current release
If this is not possible, I'm thinking I can easily write this using the java code API. My next question is then:
- Can I implement a piece of java code as a kind of "RTC Query plugin" so that it can be executed using the web client?
/Morten.
Accepted answer
Hi Morten,
I am pretty sure the Query Engine does not support such a query. I once created an enhancement request for this. These kinds of queries are not easy to do in any case. Using the API you can do that, but you will likely have to iterate several times.
There are query entries (e.g. the lifecycle queries) where queries are hooked up, but I don't know which extension point (if any) is available for this kind of set up. I would try to figure how the lifecycle queries are hooked up and look if that is something I could use.
Comments
Thanks Ralph.
I went for a work around, where I am showing two different queries on my "IT Operations" dashboard:
* All work items for current release with DEPENDS_ON where the depends_on.status != "ready for production".
* All work items NOT on current release where status is NOT resolve AND it BLOCKS a work item on current release.
This way by "turning the query around" and selecting the blocking work items, I can kinda get what I want.