FAQ #8: Is there a way to clear a field when another field changes?

Another question posed recently on an internal alias. The answer from Naren Datha:             <FIELD refname="Field1">               <WHEN field="Field2" value="Fix Available">                 <COPY from="value" value="" />               </WHEN>


FAQ #7: Can I combine a list of valid TFS users and a fixed list to present as an option for an &quot;Assigned To&quot; field?

This question came in on an internal alias. The answer from Naren Datha: <ALLOWEDVALUES expanditems="true" filteritems="excludegroups">           <LISTITEM value="Active" />           <LISTITEM value="Closed" />           <LISTITEM value="[project]\Contributors" />           <LISTITEM value="MsftConn" />           <LISTITEM value="[project]\Test Vendor Contributors" />           <LISTITEM value="[project]\Test Vendor Readers" /> </ALLOWEDVALUES>


FAQ #6: How do I change the frequency that the reporting warehouse updates?

This tip comes from Markus Hain: The default update frequency is 3600 seconds (1 hour), below are the steps to change the time. 1. Log on to the application tier of Team Foundation Server. 2. Start Internet Explorer. 3. In the Internet Explorer Address box, type http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx. 4. On the ControllerService page, click ChangeSetting. 5….


FAQ #5: How do I destroy work items or work item types?

In order to destroy work items or work item types, you’ll need TFS 2008 and you’ll need the TFS 2008 Power Tools. There are two commands: DestroyWI: You can use this to destroy one or more work items. DestroyWITD: You can use this to destroy an entire work item type — this means, you are…


FAQ #4: How do you change to format of a date on a work item?

Recently, we were asked: A customer wants to format the dates in the Work Item to the format of DDMMMYYY (e.g. 05Feb2008) instead of the standard MMDDYYYY (e.g. 02032008) This answer comes from Aliaksei Baturytski on our team: You can change the way date/time fields appear on the form by using DateTimeControl control type in…


FAQ #3: How do I find the location of the OLAP cube?

I’ve heard this one a couple of times and asked it myself a couple of times.  When I use Excel to do an analysis of the project data, I need to connect to the OLAP cube (Data->From Other Sources->From Analysis Services). I get a dialog that asks the address of the database server.  Here’s a…


FAQ #2: How do I enforce a rule on Area Path or Iteration Path?

I saw a question on this recently and thought it would be good to contribute to the FAQ that Gregg started: Incidentally, this solution is from Gregg too 🙂   <FIELD name=”Iteration Path – Validation” refname=”MyFields.IterationPathValidation” type=”String”>   <HELPTEXT>Hidden field used to validate Iteration Path</HELPTEXT>   <WHEN field=”System.IterationId” value=”XX”>    <COPY from=”value” value=”Restricted” />   </WHEN>   <PROHIBITEDVALUES not =…


FAQ #1: How do you display a field twice on the same WIT form?

Many times I get asked questions, either via forums, in person, email, whatever. Sometimes, I answer the question several times. What I’m going to start doing is posting FAQ entries on this blog as I encounter these questions. Hopefully, you’ll find them useful. One question I get is, how do you display a field more…