Changes between Version 3 and Version 4 of PeerReviewPlugin/Reports

Timestamp:

Aug 14, 2016, 6:15:48 PM (7 years ago)

Author:

figaro

Comment:

Cosmetic changes

PeerReviewPlugin/Reports

@@ -1 +1 @@
 [[PageOutline(2-3, Categories, pullout)]]
+
 = Reports
-Instead of shipping it's own report module PeerReviewPlugin relies on Tracs reporting features by leveraging custom TracReports using data from PeerReviewPlugin. These custom reports can be accessed from the regular Trac report page but they are also shown on the report page for reviews.
+
+Instead of shipping its own report module, PeerReviewPlugin relies on Trac's reporting features by utilising custom TracReports using data from the PeerReviewPlugin. These custom reports can be accessed from the regular Trac report page but they are also shown on the report page for reviews.
 
 Note that when opening a report you are automatically redirected to the Trac report module.
 
 There are no reports created during installation. You may use the ones shown below.
+
 == Creating Reports
+
 === Displaying a report on the review report page
+
 For reports to show up on the review page you must add the following wiki comment to the reports description.
 {{{
@@ -27 +32 @@
 
 }}}
+
 === Provide links from report results
+
 It is possible to directly link from report results to a referenced review or file. You need to set the {{{realm}}} column in the report as explained in [TracReports#Automaticallyformattedcolumns TracReports: Automatically formatted columns].
 
@@ -40 +47 @@
        f.revision AS revision, f.status AS status,
        'peerreviewfile' AS _realm,
-       (SELECT COUNT(*) FROM peerreviewcomment AS c
-        WHERE f.file_id = c.file_id) AS comments 
+       (SELECT COUNT(*) FROM peerreviewcomment AS c WHERE f.file_id = c.file_id) AS comments 
 FROM peerreviewfile f
 WHERE f.status = 'approved' 
@@ -47 +53 @@
 ORDER BY f.path, f.revision
 }}}
+
 == Example Reports
+
 === All reviews grouped by author
+
 Description:
 {{{
@@ -76 +85 @@
 
 === Approved files
+
 Description:
 {{{
@@ -102 +112 @@
 
 === All files with comments
+
 Description:
 {{{
@@ -128 +139 @@
 
 === Files with comments - My reviews
+
 Description:
 {{{
@@ -140 +152 @@
  * '''disapproved'''
 * Mark files with unread comments
-  [[BR]][[BR]]Note: the status ''read/unread'' is set for each user.
+  '''Note''': the status ''read/unread'' is set for each user.
 
 Back to [/peerreviewreport Codereview reports].
@@ -168 +180 @@
 INNER JOIN peerreview AS rev ON f.review_id = rev.review_id
 WHERE (f.status IS NULL OR f.status NOT IN ('approved', 'disapproved')) 
-AND f.review_id in 
-(SELECT a.review_id FROM peerreviewer a JOIN peerreview r 
-ON a.review_id = r.review_id
-WHERE a.reviewer = $USER 
-AND r.status IS NOT 'closed')
-
+   AND f.review_id in 
+   (SELECT a.review_id FROM peerreviewer a JOIN peerreview r 
+   ON a.review_id = r.review_id
+   WHERE a.reviewer = $USER 
+   AND r.status IS NOT 'closed')
 GROUP BY f.file_id
 ORDER BY f.file_id, f.status, f.path, f.revision