How can i fill into a drop down list all the Work Item of a specific type?

How can i fill into a drop down list all the Work Item of a specific type?

• In Over My Head

  Can you please give me detailed info about your question...

  
  

• Sameer123

  I'm don't think that the size of the list should be a problem. The use of global lists as suggested by Marcel is a good suggestion, but if the list size is a problem, you could just have the field as string value rather than a list, allowing users to enter the Main Activity ID rather than selecting from a list. Interestingly enough, we use a similar mechanism internally in "linking" Features to Tasks and Feature Bugs, and this works reasonably well when trying to report up progress on Features in terms of associated task completion and bug counts.

  Using this solution will only take you so far (for example this only provides a single depth tree), does not maintain a hierarchical deeper structure (or Work Breakdown Structures) created through MS Project, does not provide link relationship types and rules around those relationships etc and more. This is something that we are looking to address in V2 through extensions to our existing linking infrastructure, to provide improved traceability on projects, including querying and reporting on those tree structures/links, and displaying those hierarchical relationships in Excel, just as I believe Oliviero would like to, and maintaining the hierarchical structure between TFS and MS Project.

  Hope this helps,

  
  
  

• msaeedf

  I know the features of LinkControl but I don't want use this Control because when I do the report of Work Item's "Detail Activity" in MS Excel I can't display in my table the "Main Activity" linked to them.

  So I'm looking to have a drop down list in my form of all Main Activity titles like you said.

  In this way when I report "Detail Activity" Items I can display the "Main Activity" linked to them in my Excel table and, moreover, change this field directly by MS Excel.

  It's possible do this

  Thank you very much.

  
  

• D. Omar Villarreal

  The way you can do this is as follows:

  Make the drop down bound to a global list

  Make a subscription webservice to workitem change events and there pick up any new workitems of the type you want to associate.

  Then insert these new created workitems in the global list (export to XML, add the new entry, upload the global list again)

  Now you should be able to see the latest added workitems in your dropdown.

  Hope this helps,

  Marcel

  
  
  

• ChrisBarth1

  I would hate to see how large that list would get. I'm curious to test and see if it craps out at a specified length not to mention with even a few hundred items in it how would a person ever find anything. Yuck. But doable except for my first noted concern... how big can that list get
  
  

• Bug-free

  Let me see if I understand this correctly.

  Are you looking to have a drop down list of "active" Main Activity work item titles, for users to pick from within the Detail Activities work item

  What are you trying to accomplish You could try using Linking to create a related link between the Detail and Main Activities work items. On the WI form, go to the links tab and click on the Add button, and add a related link. If you then click on the browse button, it allows you to construct a query (or use a saved query) to browse for the related work items (in this case all Active, Main Activity work items).

  Does this help

  
  
  

• jwf

  i don't think so you can do this way...because right now TFS is having the linking concept in which you can relate the two workitems and you can fetch the data by relating some of the fields from it..and it will be useful for the reporting purpose to check for the status of the particular workitems....ie.. Task completion if you are linking with Feature workitem...how many task completed...so much percentage of work has been done..those activities we can track out...using LINKING...

  Thanks, Kathir

  
  

• Darren Woodford

  Max,

  For this case you can using a conditional statement using the <WHEN> conditional rule: Please see http://msdn2.microsoft.com/en-us/library/ms194966(VS.80).aspx for an example of a dependent pick list. For the final case your details field could be set to <EMPTY/>

  Hope this helps,

  
  
  

• bwengert79

  I have two type of Work Item in my project: "Main Activities" and "Detail Activities".

  In the Work Item "Detail Activities" I would like to have a drop down list where are filled all the existing "Main Activities" Work Item of my project.

  In this way I can choose the "Main Activities" to link with my "Detail Activities".

  Thank you.

  
  

• bglenn

  Hello everyone,

  I think I have a similar question, so I thought it would be better to put it here instead of making a new thread.

  First I'll say what I am working with: C#+ASP.NET, VS2005 & SQL Server 2000

  Now for my question: I want to make 2 drop downlists. 1 drop down lists shows main items, then the second drop down list should be filled with detail items but the catch is that they depend on the main items AND if there are no detail items for a specific main item the detailed Item should be empty.

  To make it more specific:

  Drop down list 1 has main items Home, Work, Holiday

  Then drop down list 2 has details.

  For home the details are: do dishes, put out garbage.

  For work the details are: call client, send e-mail.

  For Holiday there are no details so in this case drop down list doesn't show.

  What would be the best approach to this coding wise and in the data base Right now I am thinking of 2 databases 1 user db with user details and then 1 db for the home, work holiday settings both connected by userID which will be a shared key.

  Thnx

  
  
• How can i fill into a drop down list all the Work Item of a specific type?