Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Querying on Custom attributes of WorkItem

Hi ,

From one of my previous posts I understand that RTC 2.0 provides better querying capability on Custom fields.We would like to query on a custom field of the workitem. For example, if there is field called "Platform" , when I try to use "exists" on that field, it is ignoring the condition and retrieving all the workitems.

Please suggest?

Thanks,
Bharath

0 votes



11 answers

Permanent link
This is exactly what I need. But using 'exists' operator didn't
disable the value list. Is there something we need to do?

That is something that I still have to implement
https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/40152

--
Regards,
Patrick
Jazz Work Item Team

1 vote


Permanent link
From one of my previous posts I understand that RTC 2.0 provides
better querying capability on Custom fields.We would like to query on
a custom field of the workitem. For example, if there is field called
"Platform" , when I try to use "exists" on that
field, it is ignoring the condition and retrieving all the
workitems.

Please suggest?

The 'exists' operator allows to find all work items that have the custom
attribute (which can be all). This operator does not need any values (the
value list should actually be disabled -- there is a work item for that).

For regular queries, you would use the default 'is' operator, e.g.
"Platform is 'OS X'"

--
Regards,
Patrick
Jazz Work Item Team

0 votes


Permanent link

The 'exists' operator allows to find all work items that have the custom
attribute (which can be all). This operator does not need any values (the
value list should actually be disabled -- there is a work item for that).

This is exactly what I need. But using 'exists' operator didn't disable the value list. Is there something we need to do?

Thanks,
Bharath

0 votes


Permanent link
Thanks for the update Patrick

--Bharath

0 votes


Permanent link
So what is the way to query for all work items which have a non-empty value for a custom text field?

0 votes


Permanent link
So what is the way to query for all work items which have a non-empty
value for a custom text field?

There is an 'Unassigned' text box in the condition field of the Eclipse UI
-- in the Web UI, 'Unassigned' is part of the values in the list control.
Select that and choose the 'is not' operator

e.g.: MyCustomString 'is not' 'Unassigned'

--
Regards,
Patrick
Jazz Work Item Team

0 votes

Comments

There is an API constant to refer to the 'Unassigned' value?

It seems an externalized UI string... Can we use "Literals.getUnassignedLiteral(null)" from "com.ibm.team.workitem.service.internal.util.Literals"?
Thanks in advance.


Permanent link
Ahh - I don't use the Eclipse UI much - I do see the unassigned checkbox there and it does work as expected. However in the web UI I do not see a list to choose from. I only have a textbox to enter the text value in. The field is of type small string.

Have you seen this actually work for a string field in the Web UI? Some lightweight digging in filed work items did not immediately lead to one for this issue.

I'm using FF3.5, when going to IE8 - I get a "loading..." in red text above the text field in the query that never goes away.

BTW - I think the "Version (Bugzilla)" field in the RTC project (jazz.net) is a text field. Querying against showed me the same.

0 votes


Permanent link
Have you seen this actually work for a string field in the Web UI?
Some lightweight digging in filed work items did not immediately lead
to one for this issue.

You are right, it is actually missing for strings. This is
https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/42069

--
Regards,
Patrick
Jazz Work Item Team

0 votes


Permanent link
Any chance I can convince you to get this into 2.0.0.2? :)

0 votes


Permanent link
Any chance I can convince you to get this into 2.0.0.2? :)

Yes :) I set the 'Planned for' to 2.0.0.2.

--
Regards,
Patrick
Jazz Work Item Team

0 votes

1–15 items
page 1of 1 pagesof 2 pages

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: Aug 13 '09, 7:18 a.m.

Question was seen: 9,697 times

Last updated: May 16 '13, 9:47 a.m.

Confirmation Cancel Confirm