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

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

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".

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.