Contributions
Re: Can you map phaseId from database to Phase State
Hi Mel, Thanks for your response. Currently the data I'm working with is just a set of XML files dumped from the SQL database, so I'm not sure how I'd go about accessing the Views. Is this something I'd have to reach out to my DB administrator for? Thanks1.2KViews0likes1CommentCan you map phaseId from database to Phase State
I'm currently working with XML files containing dumps of the database. One of the things I want to do is link Reviews with their phase state. The ReviewData table has an attribute called phaseId, and the Database Schema on the site indicates there's a phase table, though there isn't one among the dumped tables I'm working with. I've also tried checking a reviewId from the table against that review in the browser gui and matching the state seen there to the phaseId value. However, I've noticed that the phaseId isn't consistently one value or another for that state. phaseId = 2 is listed for several reviews, even though each review is in a different phase state than the other. I saw Cancelled, Inspection and Completed. Phase 1 seemed more consistent, always being either Planning or Inspection, but I don't know if that's always the case or coincidence. Is there a Phase table? Or some reliable way to map the phaseId in the database to the actual state of the review?Solved1.2KViews0likes3CommentsRe: What is ClientBuild?
Thanks, this at least clears up my confusion over the clientbuild value and the example is very helpful. Unfortunately it still isn't working for me, I just keep getting a NullPointerException error, but it looks like other people have had a similar issue with this due to some confusion in the documentation, so I'll see if I can figure out the source of the error. Appreciate the help!1KViews0likes0CommentsWhat is ClientBuild?
I'm trying to write a JSON script to get information about specific reviews, however the command ReviewService.getReviewsummary requires both the review ID and a 'clientBuild' for the parameters. I'm not sure what the clientBuild is supposed to be though. I thought maybe it was the collaborator server version, but no luck there. How am I supposed to find/know this number?Solved1KViews0likes2Comments