It's all about the answers!

Ask a question

How to gather recent accessed RTC project areas

Sangeetha Jadav (1578) | asked Sep 16 '14, 10:43 a.m.
We have a CLM environment where RTC is installed and has more than 500 RTC project areas.

Is there a way where we can gather all recently accessed (like say in the last 2 months or so) RTC project areas ?

Please let me know if you have any answers/ideas here.


2 answers

permanent link
sam detweiler (12.5k6195201) | answered Sep 16 '14, 10:58 a.m.
edited Sep 16 '14, 10:59 a.m.
there is no straight approach.. you would have to run a  query against each. the query should look for changed workitems (get 5 wokitems) since some date.

you can automate all of that with some java code..  

get the list of projects
for each (not archived) project
   build a query,
   execute the query
   if there are changed workitems,
      add the project to the list of accessed projects,
loop to next project.

report the list of changed projects

permanent link
Sangeetha Jadav (1578) | answered Sep 16 '14, 11:06 a.m.
Thank Sam for your time and response!

Do we not have any plugin which can do that job?

Not sure how to automate in java code also because of the urgency.

sam detweiler commented Sep 16 '14, 11:15 a.m. | edited Sep 16 '14, 11:26 a.m.

this would be a plain java application..

automate means use the logic I presented to do this in one job execution.

an RTC plain java developer should be able to do this in less than a day

the 1st answer here  has a routine that gets some/all the project areas on a server

sample query code here

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.