Team Foundation Server Team Blog - All Comments

re: Programming for the TFS Excel Add-in

Sven Hubert AIT — Sat, 06 Nov 2010 18:57:35 GMT

Thanks for this post!

Any hints on how to avoid the odd beahvior of the Visual Basic Editor in Excel when Work Items are loaded into a Sheet? Spaces are removed automatically and so forth...

Sven

re: Tool to configure SharePoint Server for dashboard compatibility with Team Foundation Server 2010

jenny — Tue, 07 Sep 2010 04:38:30 GMT

Thanks to the upcoming World Basketball Festival, we now get a “USA” Air Jordan 2010 Team. It seems as if more people like the Air Jordan 2010 Team than the original Air Jordan 2010 because of the windowless side panels. I’m not one of those people who likes the team better; I think the original

re: WIQL syntax for Link Query

Garry English — Wed, 18 Aug 2010 22:56:33 GMT

The following worked for me to run queries:

Dictionary<string, string> context = new Dictionary<string, string>();

context .Add( "project", queryDefinition.Project.Name );

return store.Query( queryDefinition.QueryText, context );

When adding variables, you shouldn't add the '@' symbol:

msdn.microsoft.com/.../bb130306.aspx

re: WIQL syntax for Link Query

Rene Guder — Thu, 12 Aug 2010 13:58:52 GMT

Are there any other fields you can use in the <link expression> other than [System.Links.LinkType] ? I would like to filter my WorkItemLinks by their Comment. Using the API and a loop over all WorkItemLinks of a WorkItem is just too slow for my purpose.

re: Change in HTML Field Behavior in the 2010 TFS Excel Integration

Simon Jones — Wed, 28 Jul 2010 21:41:24 GMT

See this article for a description of how to add an HTML Comments field to the Task item and copy all data from Comments to HTMLComments. You may be able to adapt this to Bugs.

msmvps.com/.../using-rich-html-descriptions-instead-of-plain-text.aspx

re: VS 2010 and TFS with Office 2003

Shawn Levendusky — Wed, 14 Jul 2010 13:41:23 GMT

Great post. Thank you. My client has a comprehensive software request process so this 10 minute work around solved the immediate problem.

re: Announcing Team Foundation Server Scrum v1.0 Beta

Carl — Wed, 14 Jul 2010 08:25:28 GMT

Hi,

I am finding this template to be perfect for our team. Do you have a rough guide as to when it will no longer be in beta?

Thank you.

re: Work Item Tracking Queries Object Model in 2010

Smitha Saligrama- MSFT — Mon, 12 Jul 2010 19:23:13 GMT

If you want to use OM to run Linked queries, below is a sample

public WorkItemLinkInfo[] RunLinkQuery(string wiql)

{

Query query = new Query(m_workItemStore, wiql)

WorkItemLinkInfo[] workItemLinkInfoArray = null;

if (query.IsLinkQuery)

{

workItemLinkInfoArray = query.RunLinkQuery();

}

else

{

throw new Exception("Run link query fail. Query passed is not a link query");

}

return workItemLinkInfoArray;

}

re: WIQL syntax for Link Query

Smitha Saligrama- MSFT — Fri, 09 Jul 2010 07:04:39 GMT

There is a new Query object you will have to use to run linked queries.

Below is a sample

public WorkItemLinkInfo[] RunLinkQuery(QueryDefinition queryDefinition)

{

Query query = null;

WorkItemLinkInfo[] workItemLinkInfoArray = null;

query = GetQueryObjectFromQueryDefinition(queryDefinition);

if (query.IsLinkQuery)

{

workItemLinkInfoArray = query.RunLinkQuery();

}

else

{

throw new Exception("Run link query fail. Query passed is not a link query");

}

return workItemLinkInfoArray;

}

private Query GetQueryObjectFromQueryDefinition(QueryDefinition queryDefinition)

{

string wiql = queryDefinition.QueryText;

//Below code is to replace any macros

System.Collections.Hashtable context = new System.Collections.Hashtable();

context.Add("@project", m_projectName);

queryReturn = new Query(m_workItemStore, wiql, context);

return queryReturn;

}

For full example on how to get QueryDefinition object, please check my another blog at

blogs.msdn.com/.../work-item-tracking-queries-object-model-in-2010.aspx

re: WIQL syntax for Link Query

Grzegorz Wilczura — Wed, 07 Jul 2010 11:03:54 GMT

Hello.

How can i execute such query from C# code? I tried WorkItemStore.Query() but i got:

"You have specified a query string that is not valid when you use the query method for a flat list of work items. You cannot specify a parameterized query or a query string for linked work items with the query method you specified."

Greg.