java - How to find the list of user stories under a given iteration and a given project using rally rest api -


i able iterations under project object. how iteration need under project , drill down stories in iteration using java toolkit?

https://sandbox.rallydev.com/slm/webservice/v2.0/project/7191194697/iterations

given project:

string projectref = "/project/1234";

you may scope requests follows:

iterationrequest.setproject(projectref);

or

storyrequest.setproject(projectref);

if scoped story request project, may query on stories traversing iteration.name if know iteration already:

storyrequest.setqueryfilter(new queryfilter("iteration.name", "=", "my iteration 1"));

here more complex example returns stories assigned iterations fall within timbox of specific release. if, example, have 4 iterations per release, code return stories assigned 4 iterations.

if code against sandbox, replace value in host variable accordingly.

public class finditerationsbyreleasedateandstories {      public static void main(string[] args) throws urisyntaxexception, ioexception {           string host = "https://rally1.rallydev.com";             string username = "user@co.com";             string password = "secret";             string projectref = "/project/12352608219";             string applicationname = "find iterations release dates , stories";              rallyrestapi restapi = null;          try {                 restapi = new rallyrestapi(                         new uri(host),                         username,                         password);                 restapi.setapplicationname(applicationname);                   system.out.println(restapi.getwsapiversion());                   queryrequest  releaserequest = new queryrequest("release");                 releaserequest.setfetch(new fetch("releasestartdate", "releasedate"));                 releaserequest.setscopeddown(false);                 releaserequest.setscopedup(false);                 releaserequest.setproject(projectref);                 releaserequest.setqueryfilter(new queryfilter("name", "=", "r1"));                  queryresponse releasequeryresponse = restapi.query(releaserequest);                 int numberofreleasesinproject = releasequeryresponse.gettotalresultcount();                 system.out.println(numberofreleasesinproject);                 jsonobject releasejsonobject = releasequeryresponse.getresults().get(0).getasjsonobject();                 system.out.println(releasejsonobject.get("releasestartdate"));                 system.out.println(releasejsonobject.get("releasedate"));                  string rsd = releasejsonobject.get("releasestartdate").getasstring();                 string rd = releasejsonobject.get("releasedate").getasstring();                  queryrequest  iterationrequest = new queryrequest("iteration");                 iterationrequest.setfetch(new fetch("name","startdate","enddate"));                 iterationrequest.setscopeddown(false);                 iterationrequest.setscopedup(false);                 iterationrequest.setproject(projectref);                 iterationrequest.setqueryfilter(new queryfilter("startdate", ">=", rsd).and(new queryfilter("enddate", "<=", rd)));                  queryresponse iterationqueryresponse = restapi.query(iterationrequest);                 int numberofiteraitons = iterationqueryresponse.gettotalresultcount();                 system.out.println("numberofiteraitons " + numberofiteraitons);                 if(numberofiteraitons >0){                     (int i=0;i<numberofiteraitons;i++){                         jsonobject iterationjsonobject = iterationqueryresponse.getresults().get(i).getasjsonobject();                         string iterationname = iterationjsonobject.get("name").getasstring();                         system.out.println("iteration: " + iterationname);                         queryrequest storyrequest = new queryrequest("hierarchicalrequirement");                         storyrequest.setproject(projectref);                         storyrequest.setfetch(new fetch(new string[] {"name", "formattedid","schedulestate"}));                         storyrequest.setlimit(1000);                         storyrequest.setscopeddown(false);                         storyrequest.setscopedup(false);                         storyrequest.setqueryfilter(new queryfilter("iteration.name", "=", iterationname));                          queryresponse storyqueryresponse = restapi.query(storyrequest);                         system.out.println("number of stories in " + iterationname + " :" + storyqueryresponse.gettotalresultcount());                          (int j=0; j<storyqueryresponse.getresults().size();j++){                             jsonobject storyjsonobject = storyqueryresponse.getresults().get(j).getasjsonobject();                             system.out.println("name: " + storyjsonobject.get("name") + " formattedid: " + storyjsonobject.get("formattedid") + " schedulestate: " + storyjsonobject.get("schedulestate"));                         }                     }                 }                }         finally{             if (restapi != null) {                 restapi.close();             }         }      } }

update: far question in comment, code above equivalent of

https://rally1.rallydev.com/slm/webservice/v2.0/hierarchicalrequirement?query=((iteration.name = i1) , (project = /project/12352608219))

there other ways achive same result. iteration name may not unique, hence second condition project ref. in code request's project set first, that's why query uses 1 condition, there two. if know iteration's ref, or objectid same result returned (iteration = /iteration/123456789), , there no need filter project since reference or objectid unique.

ws api doc interactive.test queries in ws api , copy resulting query urls address bar if want see how queries formed:

-query in context of intended object: click on work item type in object model, e.g. defect or hierarchicalrequirement before typing query in query box.

-enter query in box, e.g (iteration.name = i1)

-click on query button

-results displayed in window can copy query url address bar of browser.


Comments

Post a Comment

Popular posts from this blog

commonjs - How to write a typescript definition file for a node module that exports a function? -

consider, toml node module can use: // toml.d.ts declare module toml { export function parse(value:string):any; } declare module "toml" { export = toml; } then: /// <reference path="../../../../../defs/toml/toml.d.ts"/> import toml = require('toml'); toml.parse(...); however, node module export single function, such 'glob' ( https://github.com/isaacs/node-glob ). the node usage of module be: var glob = require("glob") glob("*.js", {}, callback(err, files) { ... }); you'd naively expect this: // glob.d.ts declare function globs(paths:string, options:any, callback:{(err:any, files:string[]):void; ...but because typescripts 'import' semantics bit strange, seems can use 'import .. = require()' statement alias modules . trying call: /// <reference path="../../../../../defs/glob/glob.d.ts"/> import blog = require('glob'); results in: error ts2072: mod...
Read more

openid - Okta: Failed to get authorization code through API call -

i'm integrating okta own idp server using okta's api. i'm implementing authorization code flow following steps below: in own server, use /api/v1/authn endpoint sessiontoken. use sessiontoken obtain authorization calling endpoint: /oauth2/v1/authorize?client_id=" + clientid + "&sessiontoken=" + sessiontoken + "&response_type=code&response_mode=query&scope=openid&redirect_uri=" + redirecturl + "&state=evanyang&nonce=" it's supposed return response status code 302 , location header containing redirect url code value. however, keep getting response status code 200 , without location header, html body saying "you using unsupported browser." , "javascript disabled on browser." according api documentation: http://developer.okta.com/docs/api/resources/oidc.html#authentication-request , sessiontoken parameter sufficient this: an okta one-time sessiontoken. allows api-based ...
Read more

ios - Change Storyboard View using Seague -

i have following code checks connection server, , depending on want change views if no connection found. nsstring *connect = [nsstring stringwithcontentsofurl:[nsurl urlwithstring:@"http://myserver.com"] encoding:nsutf8stringencoding error:nil]; if (connect == null) { [self performseguewithidentifier:@"network_failure" sender:self]; } else { // other code here } my problem not change views. have added storyboard segue between 2 views identifier of network_failure . not have navigation controller or that, problem? thanks help! no not problem. first of all, in objectivec exists nil object oriented null . must use that. so: if(connect == nil) or better: if(!connect) so due fact nil not same of null , probably code does't enter in if scope . you have been able discover breakpoint. anyway: be sure set trigger segue (line) 2 view controller , , name network_failure (that not best name. should instead view1toview2 ) as, m...
Read more