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
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.
Comments
Timothy Distel
Jun 07 '19, 6:28 a.m.From a developer's perspective, how feasible would it be to add a condition to provide this query functionality?
Timothy Distel
Jun 07 '19, 8:53 a.m.There are a lot of RFE's linked to this particular RFE requesting the same thing.