Re: diffviewer_filediff Table in DB

2016-05-06 Thread john levin
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

Re: diffviewer_filediff Table in DB

2016-05-04 Thread David Trowbridge
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

Re: diffviewer_filediff Table in DB

2016-05-04 Thread john levin
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