Issue trying to query an Enumerated list attribute
We are on RTC 6.0.2 iFix010. I am trying to query Request for Change (RFC) Work Item's type with an enumerated list, "multi-impact", attribute with the following options:
-- unassigned
-- yes
-- no
Both the Default Literal and the Unassigned Literal are "Unassigned".
When I query for RFC's that have the multi-impact attribute noted above that is unresolved I get inconsistent results. Below is the result of a query that queries for RFC's where the attribute is as follows:
unassigned = 66
yes = 46
no = 28
all three conditions = 140
When I remove the filter altogether = 2,223, (which returns the number of RFC's that are unresolved)
I originally thought it may have something to do with the attribute configuration. But no matter what I tried it didn't work.
Thanks in advance for any assistance you can offer.
One answer
I cannot see any inconsistency based on my understanding. Although the attribute name is "multi-impact" and is of the type enumeration list, I believe it is in fact single-valued - it makes no sense to select more than one values given the literal labels. So the number of unresolved RFCs with such attribute adds up perfectly: 66+46+28=140.
The only bit appearing inconsistent is the number of unresolved RFCs is way larger than you may expect, but it can easily be explained - some RFCs just don't have such attributes and RFCs that are last updated before the "multi-impact" attribute was added to the work item type naturally fall into this category. If you pick an RFC that is not in the 140 that you can find, you should see that it does not have the "multi-impact" attribute - using an OSLC call to verify it as you can really tell in an editor.