How do I display a custom column in a Work Item Query?

Hi Keith,

in general custom attributes do show up in the attributes to display in queries (RTC 2.0.0.2). However there seems to be a restriction on which types will show up. I see Integer, I assume enumerations will show up. What I did not see is lists of contributors for instance. Maybe you have a type that won't show up?

In general it is important to know the version you are using.

Ralph

My project manager created a new custom column called "Test Owner". When I create a Work Item Query in RTC, I am unable to select this custom column in "Result Layout". How do I enable the contents of this custom column to be displayed in a Work Item Query?

Thanks,

Keith Carter

So that we can verify, can you provide the attribute type in your case too, please?

Ralph

So that we can verify, can you provide the attribute type in your case too, please?

Ralph

Here is the information on the "Test Owner" custom attribute:
<customAttribute>

Here is the version for my Eclipse-baed RTC client:
Version: 2.0
Build id: I20090618-1753

So that we can verify, can you provide the attribute type in your case too, please?

Ralph

Here is the type for the "Test Owner" custom attribute:
type="contributorList"

Here is the version for my Eclipse-baed RTC client:
Version: 2.0
Build id: I20090618-1753

So that we can verify, can you provide the attribute type in your case too, please?

Ralph

Here is the type for the "Test Owner" custom attribute:
type="contributorList"

Here is the version for my Eclipse-baed RTC client:
Version: 2.0
Build id: I20090618-1753

Hi Keith,

the contributor list wouldn't show up for me neither. That was the first one I stumbled upon. My thought on that is that it is probably hard to show lists in tables.

You should consider to search for a work item in the RTC project and file one if you don't find one. I am not sure that is in the plans for 3.0

Ralph

So that we can verify, can you provide the attribute type in your case too, please?

Ralph

Here is the type for the "Test Owner" custom attribute:
type="contributorList"

Here is the version for my Eclipse-baed RTC client:
Version: 2.0
Build id: I20090618-1753

Hi Keith,

the contributor list wouldn't show up for me neither. That was the first one I stumbled upon. My thought on that is that it is probably hard to show lists in tables.

You should consider to search for a work item in the RTC project and file one if you don't find one. I am not sure that is in the plans for 3.0

Ralph

Ralph, Thanks for the information. Can you please reply with list of or reference to attribute types that will show up? Thanks!

Ralph, Thanks for the information. Can you please reply with list of or reference to attribute types that will show up? Thanks!

I would have to try that out also. My best guess is: Text/strings, Enumeration, html types and any other simple type - one entry of a kind - will show up.

Lists of several items only work for relationships between work items ans far as I know.

Ralph

A workaround for getting custom column in a query is to use the export function the RTC thick client.

Go into the Work Item Perspective and select export from the file menu.

When the export window opens, browse into "Team" and select "Work Items".

The "Export Work Item" window will open. Select "Browse" next to the Query box to browse for and select the Work Item query that you wish to use. Select the format and destination as required.

Now the "Export Work Items" window will be displayed. Press the "Add columns" button.

The "Add Columns" window will open which enables you to select any of the columns in the work item, including the ones not available in the normal work item query.

If you also select "Show Custom" you can also select any of you custom columns to be displayed. Note that the "Comments" column is the content of the discussion field in the work item. Select the columns you want to a add into your report and hit ok. Do a "Ctrl-Click" to select multiple columns.

You will return to the "Export Work Items" windows. You can now remove or reorder columns. When you are ready to go hit finish and you report file will be created, including columns not normally available in queries.