Agile Central - Projects: How to find all projects with status Open or Close?

book

Article ID: 107057

calendar_today

Updated On:

Products

CA Agile Central On Premise (Rally) CA Agile Central SaaS (Rally)

Issue/Introduction



We would like to get a full comprehensive view of all our projects including their states so we know all the Open and all Closed projects.

Environment

Release:
Component: ACSAAS

Resolution

Excel add-in can be of major help for this. You can run a simple query that will export all your projects to a spreadsheet, providing you a comprehensive view including all states. You can further use Excel's capabilities to sort and further filter what you may need.

Here is an example of how you can do that. In this example we're executing a query named: "AllProjects" that exports the status along with some additional information of all the projects:

<Please see attached file for image>

User-added image

<Please see attached file for image>

User-added image

<Please see attached file for image>

User-added image

<Please see attached file for image>

User-added image

Additional Information

More on Excel add-in:

Installation: https://help.rallydev.com/rally-add-excel-installation-user-guide
Import/Export: https://help.rallydev.com/rally-add-exce

Attachments

1558699216415000107057_sktwi1f5rjvs16jmc.png get_app
1558699214685000107057_sktwi1f5rjvs16jmb.png get_app
1558699212902000107057_sktwi1f5rjvs16jma.png get_app
1558699211089000107057_sktwi1f5rjvs16jm9.png get_app