QueryRequest userRequest = new QueryRequest("User"); userRequest.setFetch(new Fetch("UserName", "Subscription", "DisplayName", "SubscriptionAdmin")); userRequest.setQueryFilter(new QueryFilter("UserName", "=", "someuser@co.com")); QueryResponse userQueryResponse = restApi.query(userRequest); JsonArray userQueryResults = userQueryResponse.getResults(); JsonElement userQueryElement = userQueryResults.get(0); JsonObject userQueryObject = userQueryElement.getAsJsonObject(); String userRef = userQueryObject.get("_ref").getAsString(); System.out.println(userRef); if (userQueryObject.get("SubscriptionAdmin").getAsBoolean() == false){ System.out.println(userQueryObject.get("SubscriptionAdmin")); }
// Query for Story to associate with Defect String storyFormattedID = "US20142"; QueryRequest storyRequest = new QueryRequest("HierarchicalRequirement"); storyRequest.setFetch(new Fetch("FormattedID","Name","Changesets")); storyRequest.setQueryFilter(new QueryFilter("FormattedID", "=", storyFormattedID)); QueryResponse storyQueryResponse = restApi.query(storyRequest); JsonObject storyJsonObject = storyQueryResponse.getResults().get(0).getAsJsonObject(); String storyRef = storyJsonObject.get("_ref").toString(); JsonObject newDefect = new JsonObject(); newDefect.addProperty("Name", "Test Defect"); newDefect.addProperty("Priority", "High Attention"); newDefect.addProperty("Severity", "Major Problem"); newDefect.addProperty("Requirement", storyRef); CreateRequest storyCreateRequest = new CreateRequest("defect", newDefect); CreateResponse storyCreateResponse = restApi.create(storyCreateRequest);
QueryRequest testcaseRequest = new QueryRequest("testcase"); testcaseRequest.setFetch(new Fetch("LastResult", "c_BlockedReason"));
QueryRequest testCaseRequest = new QueryRequest("TestCase"); testCaseRequest.setFetch(new Fetch("FormattedID","Name", "Steps")); testCaseRequest.setWorkspace(workspaceRef); testCaseRequest.setQueryFilter(new QueryFilter("FormattedID", "=", "TC6")); QueryResponse testCaseQueryResponse = restApi.query(testCaseRequest); JsonObject testCaseJsonObject = testCaseQueryResponse.getResults().get(0).getAsJsonObject(); String testCaseRef = testCaseJsonObject.get("_ref").getAsString(); int numberOfSteps = testCaseJsonObject.getAsJsonObject("Steps").get("Count").getAsInt(); System.out.println(testCaseJsonObject.get("Name") + " ref: " + testCaseRef + "number of steps: " + numberOfSteps + " " + testCaseJsonObject.get("Steps")); try { JsonObject stepOne = new JsonObject(); JsonObject stepTwo = new JsonObject(); stepOne.addProperty("Input", "Open Database Connection"); stepOne.addProperty("StepIndex", 1); stepTwo.addProperty("StepIndex", 2); stepOne.addProperty("TestCase", testCaseRef); stepTwo.addProperty("Input", "Verify the Target Schema Specified"); stepTwo.addProperty("TestCase", testCaseRef); CreateRequest createRequest = new CreateRequest("testcasestep", stepOne); CreateResponse createResponse = restApi.create(createRequest); CreateRequest createRequest2 = new CreateRequest("testcasestep", stepTwo); CreateResponse createResponse2 = restApi.create(createRequest2); } finally { restApi.close(); }
QueryRequest testCaseRequest = new QueryRequest("testcase"); testCaseRequest.setQueryFilter(new QueryFilter("FormattedID", "=", "TC1")); testCaseRequest.setFetch(new Fetch("FormattedID", "Name", "Steps")); QueryResponse testCaseResponse = restApi.query(testCaseRequest); JsonObject testCase = testCaseResponse.getResults().get(0).getAsJsonObject(); System.out.println(String.format("Found: %s - %s", testCase.get("FormattedID").getAsString(), testCase.get("Name").getAsString())); //Inspect the steps collection JsonObject steps = testCase.getAsJsonObject("Steps"); int stepCount = steps.get("Count").getAsInt(); System.out.println(String.format("\nTotal steps: %d", stepCount)); //Query the steps collection QueryRequest stepRequest = new QueryRequest(steps); stepRequest.setFetch(new Fetch("StepIndex","ExpectedResult","Input")); QueryResponse queryResponse = restApi.query(stepRequest); if (queryResponse.wasSuccessful()) { for (JsonElement result : queryResponse.getResults()) { JsonObject step = result.getAsJsonObject(); System.out.println(String.format("\t%d: Input=%s, ExpectedResult=%s", step.get("StepIndex").getAsInt(), step.get("Input").getAsString(), step.get("ExpectedResult").getAsString())); } }
try{ QueryRequest c = new QueryRequest("testcaseresult"); c.setFetch(new Fetch("testcase")); c.setQueryFilter(new QueryFilter("testcase", "=", testCaseRef)); QueryResponse cc = r.query(c); String testresultRef = cc.getResults().get(0).getAsJsonObject().get("_ref").toString(); } catch(IndexOutOfBoundsException e){ //Create a testcaseresult here. }
QueryRequest ustore = new QueryRequest("hierarchicalrequirement"); ustore.setLimit(Integer.MAX_VALUE); ustore.setFetch(new Fetch("FormattedID","Name","Parent","Feature","Blocked","PlanEstimate","ScheduleState","Release","Iteration","Owner","Project")); ustore.setQueryFilter(new QueryFilter("Feature.Name","=",feature.getName())); QueryResponse usResp = restApi.query(ustore);
QueryRequest testCaseResultsRequest = new QueryRequest("TestCaseResult"); testCaseResultsRequest.setFetch(new Fetch("Build","TestCase","TestSet", "Verdict","FormattedID")); testCaseResultsRequest.setQueryFilter(new QueryFilter("TestCase.FormattedID", "=", "TC8147").and( new QueryFilter("TestSet.FormattedID", "=", "TS363"))); QueryResponse testCaseResultResponse = restApi.query(testCaseResultsRequest); int numberTestCaseResults = testCaseResultResponse.getTotalResultCount(); System.out.println(numberTestCaseResults); if(numberTestCaseResults >0) System.out.println(testCaseResultResponse.getResults().get(0).getAsJsonObject().get("Verdict").getAsString()); else System.out.println("Not executed");
QueryRequest defectRequest = new QueryRequest("defect"); defectRequest.setFetch(new Fetch("Project", "LastUpdateDate", "FormattedId", "SubmittedBy", "Owner")); defectRequest.setProject("/project/12345"); //The project oid for your project defectRequest.setScopedDown(true); QueryResponse projectDefects = rallyApi.query(defectRequest);
projectRequest.setFetch(new Fetch("Name", "TeamMembers")); projectRequest.setWorkspace(workspaceRef); projectRequest.setQueryFilter(new QueryFilter("Name", "=", "Company X"));
try { restApi = new RallyRestApi( new URI(host), username, password); restApi.setApplicationName(applicationName); QueryRequest defectRequest = new QueryRequest("Defect"); defectRequest.setProject(projectRef); defectRequest.setFetch(new Fetch(new String[] {"Name", "FormattedID","State", "Priority", "Severity", "Requirement"})); defectRequest.setLimit(1000); defectRequest.setScopedDown(false); defectRequest.setScopedUp(false); defectRequest.setQueryFilter(new QueryFilter("Requirement", "=", storyRef)); QueryResponse defectQueryResponse = restApi.query(defectRequest); for (int i=0; i<defectQueryResponse.getResults().size();i++){ JsonObject defectJsonObject = defectQueryResponse.getResults().get(i).getAsJsonObject(); System.out.println("Name: " + defectJsonObject.get("Name") + " State: " + defectJsonObject.get("State") + " Priority: " + defectJsonObject.get("Priority") + " FormattedID: " + defectJsonObject.get("Requirement")); } } finally { if (restApi != null) { restApi.close(); } }
public static void main(String[] args) throws URISyntaxException, IOException { // Create and configure a new instance of RallyRestApi String host = "https://rally1.rallydev.com"; String username = "user@domain.com"; String password = "secret"; String wsapiVersion = "v2.0"; String workspaceRef = "/workspace/1111"; String projectRef = "/project/2222"; String applicationName = "DirectChildrenCount"; RallyRestApi restApi = new RallyRestApi( new URI(host), username, password); restApi.setWsapiVersion(wsapiVersion); restApi.setApplicationName(applicationName); QueryRequest storyRequest = new QueryRequest("HierarchicalRequirement"); storyRequest.setFetch(new Fetch("Name","DirectChildrenCount")); storyRequest.setWorkspace(workspaceRef); storyRequest.setQueryFilter(new QueryFilter("FormattedID", "=", "US16")); QueryResponse storyQueryResponse = restApi.query(storyRequest); JsonObject storyJsonObject = storyQueryResponse.getResults().get(0).getAsJsonObject(); System.out.println(storyJsonObject.get("Name") + " DirectChildrenCount: " + storyJsonObject.get("DirectChildrenCount")); }
QueryRequest defectTypeRequest = new QueryRequest("typedefinition"); defectTypeRequest.setFetch(new Fetch("Attributes,Name,AllowedValues,StringValue")); defectTypeRequest.setQueryFilter(new QueryFilter("TypePath", "=", "defect")); QueryResponse queryResponse = restApi.query(defectTypeRequest);
QueryRequest testSetRequest = new QueryRequest("TestCases"); testSetRequest.setFetch(new Fetch(new String[] { "Name","FormattedID"})); testSetRequest.setQueryFilter(new QueryFilter("TestFolder.Parent.Name", "=", "TestFolderParent1"));
storyRequest.setFetch(new Fetch(new String[] {"Name", "FormattedID", "ScheduleState", "State", "PlanEstimate", "TaskRemainingTotal", "CreationDate"})); storyRequest.setLimit(1000); storyRequest.setScopedDown(false);
testCaseRequest.setProject(projectRef); testCaseRequest.setFetch(new Fetch(new String[] {"FormattedID","Name","TestFolder"})); testCaseRequest.setQueryFilter(new QueryFilter("FormattedID", "=", "TC47")); testCaseRequest.setScopedDown(false);
RallyRestApi restApi = new RallyRestApi(new URI("https://rally.rallydev.com/"), "_apogjlfdkjglfjlksr23rfdlj"); String wsapiVersion = "v2.0"; String workspaceRef = "/workspace/01245"; String projectRef = "/project/6757552"; if(restApi!=null){ restApi.setWsapiVersion(wsapiVersion); QueryRequest queryRequest = new QueryRequest("TestFolders"); queryRequest.setFetch(new Fetch(new String[] { "Name","FormattedID","TestFolder"})); queryRequest.setWorkspace(workspaceRef); queryRequest.setProject(projectRef); queryRequest.setScopedDown(true); queryRequest.setLimit(Integer.MAX_VALUE); queryRequest.setPageSize(Integer.MAX_VALUE); QueryResponse queryResponse = null; JsonArray jsonarr = new JsonArray(); queryResponse = restApi.query(queryRequest); int responseTotalResultsCount = queryResponse.getTotalResultCount(); jsonarr.addAll(queryResponse.getResults()); int jsonArrSize = jsonarr.size(); for (int i=0; i<queryResponse.getResults().size();i++){ JsonObject testCaseJsonObject = queryResponse.getResults().get(i).getAsJsonObject(); System.out.println(testCaseJsonObject.getAsJsonObject().get("FormattedID")+": "+testCaseJsonObject.getAsJsonObject().get("Name")); } }
QueryRequest testsetRequest = new QueryRequest("TestSet"); //no spaces testsetRequest.setFetch(new Fetch("FormattedID","Name")); //No need to specify type again testsetRequest.setQueryFilter(new QueryFilter("Name", "=", "TestSetName")); QueryResponse testSetQueryResponse = restApi.query(testsetRequest); if(testSetQueryResponse.wasSuccessful()) { for (JsonElement result : testSetQueryResponse.getResults()) { //handle results } } else { //See what error occurred for (String err : testSetQueryResponse.getErrors()) { System.err.println("\t" + err); } }
// Query for Test Case to which we want to add results QueryRequest testCaseRequest = new QueryRequest("TestCase"); testCaseRequest.setFetch(new Fetch("FormattedID","Name")); testCaseRequest.setQueryFilter(new QueryFilter("FormattedID", "=", "TC4")); QueryResponse testCaseQueryResponse = restApi.query(testCaseRequest); JsonObject testCaseJsonObject = testCaseQueryResponse.getResults().get(0).getAsJsonObject(); String testCaseRef = testCaseQueryResponse.getResults().get(0).getAsJsonObject().get("_ref").toString(); String testCaseFormattedID = testCaseQueryResponse.getResults().get(0).getAsJsonObject.get("FormattedID").toString(); // Query for Test Case Results that are associated to this particular Test Case QueryRequest testCaseResultsRequest = new QueryRequest("TestCaseResult"); testCaseResultsRequest.setFetch(new Fetch("Build","TestCase","Verdict","FormattedID")); testCaseResultsRequest.setQueryFilter(new QueryFilter("TestCase.FormattedID", "=", testCaseFormattedID)); QueryResponse testCaseResultResponse = restApi.query(testCaseResultsRequest); int numberTestCaseResults = testCaseResultResponse.getTotalResultCount();
queryRequest.setFetch(new Fetch(new String[] {"ObjectID", "CreationDate", "LastUpdateDate", "FormattedId"})); queryRequest.setQueryFilter(new QueryFilter("CreationDate", ">=", "2013-01-01T07:00:00.000Z")); queryRequest.setLimit(Integer.MAX_VALUE);