How can I get the last modified date for all test cases in a project area?
I have followed the advice provided in this post - https://jazz.net/forum/questions/229216/which-information-in-the-data-warehouse-can-be-used-to-get-the-last-modified-date-in-an-rqm-project-using-birt/229347
I have some follow up questions,
1. Can someone please help me with the expression to give so that I can get the last modified date for all the testcases for each project area? In other words, I want to know when was the last date any of the test cases were modified in each project area.
2. Basically, I want to have 4 columns in my report - Project Area Name, Last date of Test case modification, Last date of TCER Modification, Last date of Test Plan modification. Can you please help me with the table names where I can get the TCER last modified date and testplan last modified date?
3. Or I can think of another way I can get what I want. Let me give you the objective of this report - I want to know when any testcase/TCER/testplan was created/updated in all the project areas. By using this date, I will know whether a project area is being used or not. And if not used in the past one year, the project area will be archived. Keeping this objective in mind, can you please tell me if there is a single column in some table that will tell me this last modified date?