Jazz Register Log in
Jazz Forum Welcome to the Jazz Community Forum

Welcome to the Jazz Community Forum

Connect and collaborate with IBM Engineering experts and users

Work Item Query - Attribute Doesn't Exist

I can create a work item query where it's possible to specify "show me work items where attribute XYZ exists."

I cannot, however, find a way to create a similar query in which a given attribute does not exist. This would be helpful in identifying work items that require attribute synchronization.

Did I miss this feature somehow? If not, is an RTC enhancement already created for it (I couldn't find one).

Thanks, Gary

0 votes



4 answers

Permanent link
I am also now in need of this exact thing ... can it be done? Anybody?

Susan

I can create a work item query where it's possible to specify "show me work items where attribute XYZ exists."

I cannot, however, find a way to create a similar query in which a given attribute does not exist. This would be helpful in identifying work items that require attribute synchronization.

Did I miss this feature somehow? If not, is an RTC enhancement already created for it (I couldn't find one).

Thanks, Gary

0 votes


Permanent link
Which type of Attribute are you trying to do this on? I thought most types allow you to select "is not".

0 votes


Permanent link
Mine is actually an enumeration. It isn't that I want when it is "not" something, but rather, when the field doens't exist. My situation is, I have about 50,000 work items across various workItemTypes. I recently added a new attribute field. We've gone through to do a Sync Attributes on all of the attribute types and when we do that, the attribute shows "Unassigned". However, we have several that we have found that are not Sync'd, so when you try to edit the WorkItem, the field doesn't display. Those need to be Sync'd, but I can't find a query for them. I have tried a query where the attribute "is not" and then select all of the items (so not any of the known values) and get 0. So that one didn't work. There is an "exists" but there isn't a "does NOT exist".

I can create a query to just show everything, export that, and I can see the ones where it "doesn't exist" but then I have to do them all one at a time.

Susan


Which type of Attribute are you trying to do this on? I thought most types allow you to select "is not".

0 votes


Permanent link
Ok sorry...I don't know about that one. I usually just create a query that returns all the records I want to sync but with 50,000 records I could imagine that being difficult.

0 votes

Comments

Hi All,

 Got any solution on this? I am also looking for it.

Thanks,

Kavita

Your answer

Register or log in to post 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Sep 29 '10, 1:55 p.m.

Question was seen: 5,554 times

Last updated: Jul 02 '14, 4:37 a.m.

Confirmation Cancel Confirm