Skip to main content
System StatusContact Support
VersionOne Community

Exporting Closed Work Items

This feature is available in all editions.

editions-all.png

Answer

In Lifecycle grids, closed work items display as strikethrough text and open items display as plain text. When you export items to Excel, the strikethrough formatting is lost and both open and closed items display as plain text. This makes it difficult to tell which ones are closed and which ones are open. 

Solutions

As a workaround, you can use one of these options below to get the list of closed items only.

Option 1: Copy and Paste Closed Items into Excel

  1. On any page, click on the magnifying glass next to the search field.

  2. On the Advanced Search page:

    • Type an * (asterisk) in the search field.

    • Select the Closed check box.

    • Click Search.

  3. Select and copy the items in the grid.

  4. Open a new worksheet in Excel, and then choose Paste Special. If prompted, choose HTML format.

  5. Save the Excel file to your computer.

Option 2: Use the VersionOne API

You can also retrieve closed items by querying the data using the Lifecycle API. This is the best way to retrieve a large number of closed items. To learn more, see Getting Started with the API.

  • Was this article helpful?