public static void main(String[] args) throws URISyntaxException, IOException {
String host = "https://rally1.rallydev.com";
String apiKey = "_abc123";
String workspaceRef = "/workspace/12352608129";
String applicationName = "bulkUpdateTagsOnDefects";
RallyRestApi restApi = new RallyRestApi(new URI(host), apiKey);
restApi.setApplicationName(applicationName);
try {
String tagToRemove = "tag1";
String tagToAdd = "new tag";
// find all defects with "tag1" with ScheduleState < Completed
QueryRequest defectRequest = new QueryRequest("Defect");
defectRequest.setWorkspace(workspaceRef);
defectRequest.setFetch(new Fetch(new String[] {"Name", "FormattedID", "Tags"}));
defectRequest.setLimit(1000);
defectRequest.setQueryFilter(
(new QueryFilter("Tags.Name", "contains", tagToRemove))
.and(new QueryFilter("ScheduleState", "<", "Completed")));
QueryResponse defectQueryResponse = restApi.query(defectRequest);
System.out.println("Size: " + defectQueryResponse.getTotalResultCount());
/*
QueryRequest oldTagRequest = new QueryRequest("Tag");
oldTagRequest.setWorkspace(workspaceRef);
oldTagRequest.setQueryFilter(new QueryFilter("Name", "=", tagToRemove));
QueryResponse oldTagQueryResponse = restApi.query(oldTagRequest);
if(oldTagQueryResponse.getTotalResultCount() == 0){
System.out.println("Cannot find tag: " + tagToRemove);
return;
}
JsonObject oldTagJsonObject = oldTagQueryResponse.getResults().get(0).getAsJsonObject();
String oldTagRef = oldTagJsonObject.get("_ref").getAsString();
System.out.println(oldTagRef);
*/
QueryRequest newTagRequest = new QueryRequest("Tag");
newTagRequest.setWorkspace(workspaceRef);
newTagRequest.setQueryFilter(new QueryFilter("Name", "=", tagToAdd));
QueryResponse newTagQueryResponse = restApi.query(newTagRequest);
if (newTagQueryResponse.getTotalResultCount() == 0) {
System.out.println("Cannot find tag: " + tagToAdd);
return;
}
JsonObject newTagJsonObject = newTagQueryResponse.getResults().get(0).getAsJsonObject();
String newTagRef = newTagJsonObject.get("_ref").getAsString();
System.out.println(newTagRef);
if (defectQueryResponse.getTotalResultCount() == 0) {
System.out.println("Cannot find defects tagged : " + tagToRemove);
return;
} else {
for (int i = 0; i < defectQueryResponse.getResults().size(); i++) {
JsonObject defectJsonObject = defectQueryResponse.getResults().get(i).getAsJsonObject();
String defectRef = defectJsonObject.get("_ref").getAsString();
System.out.println(
"Name: "
+ defectJsonObject.get("Name")
+ " FormattedID: "
+ defectJsonObject.get("FormattedID"));
int numberOfTags = defectJsonObject.getAsJsonObject("Tags").get("Count").getAsInt();
QueryRequest tagCollectionRequest =
new QueryRequest(defectJsonObject.getAsJsonObject("Tags"));
tagCollectionRequest.setFetch(new Fetch("Name", "ObjectID"));
JsonArray tags = restApi.query(tagCollectionRequest).getResults();
for (int j = 0; j < numberOfTags; j++) {
System.out.println("Tag Name: " + tags.get(j).getAsJsonObject().get("Name"));
}
tags.add(newTagJsonObject);
JsonObject defectUpdate = new JsonObject();
defectUpdate.add("Tags", tags);
UpdateRequest updateDefectRequest = new UpdateRequest(defectRef, defectUpdate);
UpdateResponse updateDefectResponse = restApi.update(updateDefectRequest);
if (updateDefectResponse.wasSuccessful()) {
System.out.println(
"Successfully updated : "
+ defectJsonObject.get("FormattedID")
+ " Tags after update: ");
QueryRequest tagCollectionRequest2 =
new QueryRequest(defectJsonObject.getAsJsonObject("Tags"));
tagCollectionRequest2.setFetch(new Fetch("Name", "ObjectID"));
JsonArray tagsAfterUpdate = restApi.query(tagCollectionRequest2).getResults();
int numberOfTagsAfterUpdate = restApi.query(tagCollectionRequest2).getResults().size();
for (int j = 0; j < numberOfTagsAfterUpdate; j++) {
System.out.println(
"Tag Name: " + tagsAfterUpdate.get(j).getAsJsonObject().get("Name"));
}
}
}
}
} finally {
restApi.close();
}
}
public static void main(String[] args) throws URISyntaxException, IOException {
String host = "https://rally1.rallydev.com";
String apiKey = "_abc123";
String workspaceRef = "/workspace/12352608129";
String applicationName = "Nick: updateMilestoneCollection";
RallyRestApi restApi = new RallyRestApi(new URI(host), apiKey);
restApi.setApplicationName(applicationName);
try {
String milestoneName = "Mid January";
String storyId = "US30015";
QueryRequest milestoneRequest = new QueryRequest("Milestone");
milestoneRequest.setWorkspace(workspaceRef);
milestoneRequest.setQueryFilter(new QueryFilter("Name", "=", milestoneName));
QueryResponse milestoneQueryResponse = restApi.query(milestoneRequest);
if (milestoneQueryResponse.getTotalResultCount() == 0) {
System.out.println("Cannot find milestone: " + milestoneName);
return;
}
JsonObject milestoneJsonObject = milestoneQueryResponse.getResults().get(0).getAsJsonObject();
String milestoneRef = milestoneJsonObject.get("_ref").getAsString();
System.out.println(milestoneRef);
QueryRequest storyRequest = new QueryRequest("HierarchicalRequirement");
storyRequest.setWorkspace(workspaceRef);
storyRequest.setFetch(new Fetch("FormattedID", "Name", "Milestones"));
storyRequest.setQueryFilter(new QueryFilter("FormattedID", "=", storyId));
QueryResponse storyQueryResponse = restApi.query(storyRequest);
;
if (storyQueryResponse.getTotalResultCount() == 0) {
System.out.println("Cannot find story : " + storyId);
return;
}
JsonObject storyJsonObject = storyQueryResponse.getResults().get(0).getAsJsonObject();
String storyRef = storyJsonObject.get("_ref").getAsString();
System.out.println(storyRef);
int numberOfMilestones =
storyJsonObject.getAsJsonObject("Milestones").get("Count").getAsInt();
System.out.println(numberOfMilestones + " milestone(s) on " + storyId);
QueryRequest milestoneCollectionRequest =
new QueryRequest(storyJsonObject.getAsJsonObject("Milestones"));
milestoneCollectionRequest.setFetch(new Fetch("Name"));
JsonArray milestones = restApi.query(milestoneCollectionRequest).getResults();
for (int j = 0; j < numberOfMilestones; j++) {
System.out.println("Milestone Name: " + milestones.get(j).getAsJsonObject().get("Name"));
}
milestones.add(milestoneJsonObject);
JsonObject storyUpdate = new JsonObject();
storyUpdate.add("Milestones", milestones);
UpdateRequest updateStoryRequest = new UpdateRequest(storyRef, storyUpdate);
UpdateResponse updateStoryResponse = restApi.update(updateStoryRequest);
if (updateStoryResponse.wasSuccessful()) {
System.out.println("Successfully updated : " + storyId + " Milestones after update: ");
QueryRequest milestoneCollectionRequest2 =
new QueryRequest(storyJsonObject.getAsJsonObject("Milestones"));
milestoneCollectionRequest2.setFetch(new Fetch("Name"));
JsonArray milestonesAfterUpdate = restApi.query(milestoneCollectionRequest2).getResults();
int numberOfMilestonesAfterUpdate =
restApi.query(milestoneCollectionRequest2).getResults().size();
for (int j = 0; j < numberOfMilestonesAfterUpdate; j++) {
System.out.println(
"Milestone Name: " + milestonesAfterUpdate.get(j).getAsJsonObject().get("Name"));
}
}
} finally {
restApi.close();
}
}