How to copy personal queries to another project area?
Hi, I'm using RTC3.0.1.3 and our clients do really want to copy their personal queries to other project because they have many personal queries and there are many shared queries in our project area already. It's really inconvenient when they join a new project.
I had looked up to the forum and I found some people might asked the same question as I am asking, but I didn't find the solution. Then I try to write a java application to achieve it.
Following is my code(Omitted):
IQueryClient queryClient = (IQueryClient)itr.getClientLibrary(IQueryClient.class);
IQueryDescriptorWorkingCopyManager manager = queryClient.getWorkingCopyManager();
List<IQueryDescriptor> queryDesList = queryClient.findPersonalQueries(
projectArea, itr.loggedInContributor(),
null, IQueryDescriptor.FULL_PROFILE, null);
for (IQueryDescriptor des : queryDesList) {
manager.connect(des, null);
IQueryDescriptorWorkingCopy copy = manager.getWorkingCopy(des);
QueryDescriptor descCopy = (QueryDescriptor) copy.getQueryDescriptor();
descCopy.setProjectArea(targetProjectArea);
copy.saveCopy(des.getName() + "cpy", true, null);
}
After I test the application, I found the query is copied to other project, but after I clicked this query, the result is same as the old project(it mean the query in B project listed the workitems which is belongs to A project). Is any one could give me some advice?
Thank you.
Accepted answer
Thanks Millarde for the solution search.
Thank you Di Tang for sharing your code. Perhaps a workaround would be to create a new Query in the new project area, then iterate over the conditions in the old query and add them to the new query. Or extract the xml from the old descriptor and assign it to the new descriptor. There are some examples of using QueryDescriptor in com.ibm.team.workitem.common.test.QueryDescriptorTest.java which may be helpful (if this is not available to you, please let me know).
@bill: The best workaround may be to write queries that are to be migrated as predefined queries. These are added to the process spec, for example:
<query description="Work items I have created which have been resolved" id="com.ibm.team.workitem.queries.predefined.closedCreated" name="Closed created by me">
<select/>
<where>
<and>
<condition operator="is">
<attribute name="creator"/>
<variable type="currentUser"/>
</condition>
<condition operator="is">
<attribute name="internalState"/> <variable arguments="closed" type="state"/> </condition> </and>
</where>
</query>
These can then be easily migrated using the Process Spec xml configuration.
Regards,
Larry
One other answer
In answer to @bill, there is no gesture for this. There have been several requests for this capability (see work items 37198, 65750 and 210655). Enhancement 210655 included an RFE which was rejected earlier this year. The underlying issue is that the query could reference attributes and values that are not available in the target project area, making a reliable move/copy operation difficult or dependent on having exactly the same process spec in the target.
Comments
Bill Higgins
JAZZ DEVELOPER May 02 '13, 3:49 p.m.I am in a similar situation; we are basically splitting out some work from an existing project area into a new project area and the team would like to take their queries with them to the new project area.