Work Item Approval Query Functionality
![]() Hello,
I am using CLM 6.0.6.
I want to create a query which pulls the work items that don't have an approval of a particular name. What I believe to be some key information is that the way we use our environment, work items will have more than one approval. These queries can be created if it is enforced that every work item only have one approval, however it seems to not be possible to create this query having more than one approval on a work item.
Instead of finding all of the work items that don't have an approval of a certain name, you find all of the work items that have an approval of any name other than what was specified.
Is there any way this can be mitigated other than executing a second query to find what needs to be manually filtered from the other?
|
Accepted answer
![]()
Ralph Schoon (63.3k●3●36●46)
| answered Jun 07 '19, 9:54 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER edited Jun 07 '19, 10:14 a.m. My understanding is that the RFE Community https://www.ibm.com/developerworks/rfe/ is what product management has to look at. They may consider an enhancement request in RTC. I think you should create an RFE and refer back to the enhancement requests.
It has always been a problem for query engines to handle multiple values, however I also agree that there are issues with the approval story that exists today. Especially for querying, reporting and other automation.
Timothy Distel selected this answer as the correct answer
Comments Thank you Ralph, I appreciate the link. I'll submit an RFE and reference the past enhancement requests. |
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.
Comments
From a developer's perspective, how feasible would it be to add a condition to provide this query functionality?
There are a lot of RFE's linked to this particular RFE requesting the same thing.