Relative dates in query

[russells]

Is there any way to specify a relative date in a work item query? I frequently need to query items created or modified since yesterday or over the last week, but I cannot save those queries due to the need to explicitly specify the date.

Thanks.

[lbauer]

In History Query Filter/Sort, there is a tab for Dates & Labels. Under the Dates section, click "Include Past X days" and choose the number of past days you want in the query results. You should be able to save that query and re-use it.

[russells]

Isn't that for looking at the history of files within the repository? I need to query defects.

[lbauer]

Sorry, I misread your post.

There is no relative date query in Work Item Tracking, but you can use Recent Items for this.

Click Recent Items on the VaultPro Item Tracking tab. This will give you the last X number of items which have been Added, Updated or Commented on.

You can customize the results by clicking View at the right of the screen, and selecting Customize. You can configure which columns you want to see and how many rows. Enter a number for enough rows to cover how many new/updated items you might have in a few days or a week.