Thanks Alot David. You Saved my Time. A colleague of mine wrote a sql quicky based on your input and we achieved the result.
select D.id,D.status,A.source_file from diffviewer_filediff A , diffviewer_diffset B , diffviewer_diffsethistory C,reviews_reviewrequest D where A.diffset_id = B.id and B.history_id = C.ID and D.diffset_history_id = C.id and D.id = 57; (57 is the review id) On Thursday, May 5, 2016 at 5:59:06 AM UTC+5:30, David Trowbridge wrote: > > There are many different tables that have foreign key relations to each > other. > > The FileDiff has a foreign key to DiffSet, which represents a single > revision of a diff on a review request. DiffSet in turn has a foreign key > to DiffSetHistory, which is all revisions. The ReviewRequest model has a > foreign key to DiffSetHistory (a 1:1 relationship). > > Therefore, if you want to relate a FileDiff to its ReviewRequest, you'll > have to join all the relevant tables together. > > -David > > On Wed, May 4, 2016 at 6:37 AM john levin <[email protected] > <javascript:>> wrote: > >> Could Someone answer my question please ? >> >> >> On Wednesday, May 4, 2016 at 12:39:54 PM UTC+5:30, john levin wrote: >>> >>> Hi, >>> >>> I could see that diffviewer_filediff Table doesnt Holds the review id >>> rather the id is incremental mode whenever the change is happens. So i'm >>> Wondering how to Map the Filelist with particular review ID. Any Idea ? >>> >>> Note :- I dont have an idea about django, so connecting the DB directly >>> to validate some informations. >>> >>> Thanks ! >>> >>> /BR >>> John >>> >> -- >> Supercharge your Review Board with Power Pack: >> https://www.reviewboard.org/powerpack/ >> Want us to host Review Board for you? Check out RBCommons: >> https://rbcommons.com/ >> Happy user? Let us know! https://www.reviewboard.org/users/ >> --- >> You received this message because you are subscribed to the Google Groups >> "reviewboard" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > -- Supercharge your Review Board with Power Pack: https://www.reviewboard.org/powerpack/ Want us to host Review Board for you? Check out RBCommons: https://rbcommons.com/ Happy user? Let us know! https://www.reviewboard.org/users/ --- You received this message because you are subscribed to the Google Groups "reviewboard" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
