NOTICE: Our Community is moving. Get more information.
I'm looking for a way to make a call through the API to query the Starteam DB and have the query return a list of CRs that have a matching value in a Usr_ defined field.
For example, for each CR we have a Usr_ReleaseNumber text field defined for the CR. I would like to send a query that basically says, "Please return a list of CR's that contain Usr_ReleaseNumber equal to "1234". I'd like to see the work done on the database side, rather than have to walk a list of CR's in the folder and interrogate each one to see if it has a matching release number.
Is this something I can do using the ViewMemberListManager? If so, still not sure how to construct the query through the API to return just the relevant CRs.
the simplest query you can write is one using the CommandProcessor class, which encapsulates viewmemberlistmanagers, folderlistmanagers, sorting, querying, filtering etc. a pseudo query would look like this Server s = new Server("host", port); Project p = s.findProject("projectname"); View v = p.findView("viewname); CommandProcessor cp = new CommandProcessor(v); String results = cp.execute("select viewmemberid from changerequest where Usr_ReleaseNumber = "1234""); // do something with the results s.disconnect(); I hope this helps anil
In reply to Anil Peres-da-Silva:
In reply to jlynch:
In reply to mzrousar:
Yes, you can execute any query through the CommandProcessor which is supported by the stcmd/stcmdEx engine. The entire syntax of the select statement is available here community.microfocus.com/.../stql-the-select-command-a-generalized-starteam-query-generation-language You have the flexibility to provide the date format of your choice, per the rules of the grammar (-pattern) in the link above. (though for what its worth, the format is validated using the java SimpleDateFormat pattern matcher) Take care anil