EBMS Tickets

Issue Number 128
Summary [Reports] New report - Articles Without Responses
Created 2013-12-10 11:21:24
Issue Type Improvement
Submitted By Juthe, Robin (NIH/NCI) [E]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2014-01-10 15:55:16
Resolution Fixed
Path /home/bkline/backups/jira/oceebms/issue.115873
Description

We would like to have a report to help us get a better handle on articles that have received NO reviews back from Board members. In other words, they were assigned for review but have not moved past that point and therefore may have fallen through the cracks.

I am actually not 100% sure this needs to be a new report. We may be able to get the information we need by making changes to the citations by status report, but this is a summary of what we are looking to accomplish.

Articles Without Responses Report

Select 1 Board (required)
Select 1 or more topics (optional)
Select 1 or more reviewers (optional)
Select 1 or more review cycles (optional)
Enter date range (optional) - this refers to the date a packet was created.

The output for this report should be limited to articles that have been assigned for review but have not moved past that state.

The columns for the report are as follows (left to right):

Article
Topic
Reviewer
Date Assigned

The article column should contain the full bibliographic information for the article with a link to the full citation page (as on other reports).

Please alphabetize the report output by the first author's last name first, then by topic. Ideally, both the article and topic columns would be sortable if we wanted to adjust the sorting as we're reviewing the report.

We would like each citation-topic combination to appear once on the report. (In other words, there may be multiple reviewers listed in a single row for that citation-topic combination on the report. Please list each reviewer on a separate line.) I've attached a sample report output to show you what I mean.

Comment entered 2013-12-16 15:24:30 by Kline, Bob (NIH/NCI) [C]

Using the Drupal table and database APIs I can either:

  • totally control the sort order myself, in which case I would be able to implement sub-sorting of topics within an article; or

  • allow the user to control which column the report is sorted by

... but not both. Which approach would you like me to use?

Comment entered 2013-12-17 03:51:36 by Kline, Bob (NIH/NCI) [C]

I solved the problem by avoiding Drupal's sort. Instead of ordering the report by clicking on column headers, the user clicks a sorting selection in the report request form.

Comment entered 2013-12-17 07:56:17 by Kline, Bob (NIH/NCI) [C]

Ready for user review on DEV.

Comment entered 2014-01-06 00:47:03 by Kline, Bob (NIH/NCI) [C]

Promoted to QA.

Comment entered 2014-01-08 13:55:54 by Juthe, Robin (NIH/NCI) [E]

Please add a RESET button to the left of the SUBMIT button. The primary action (triggered by hitting enter) should be to submit the report.

Comment entered 2014-01-09 13:18:01 by Juthe, Robin (NIH/NCI) [E]

Since we're unable to add the reset button on the left and keep the default action of submit, we'd like to just add the reset button on the left (recognizing that it will become the default). This will be consistent with other reports. Thanks.

Comment entered 2014-01-09 13:21:45 by Juthe, Robin (NIH/NCI) [E]

Please remove the reviewer field as a parameter for the report (but keep it in the report output). We've decided this won't be needed for this report. Thanks.

Comment entered 2014-01-09 13:27:07 by Juthe, Robin (NIH/NCI) [E]

Please change the mouseover for the date fields to "Assigned date (defaults to no start date)" and "Assigned date (defaults to no end date)".

Comment entered 2014-01-10 10:24:17 by Kline, Bob (NIH/NCI) [C]

New enhancements added on DEV; please review.

Comment entered 2014-01-17 10:25:13 by Juthe, Robin (NIH/NCI) [E]

As discussed yesterday, we've noticed a light gray horizontal line between every OTHER line on the report output. Would it be possible to have this line between every result? Thanks.

Comment entered 2014-01-17 11:25:09 by Kline, Bob (NIH/NCI) [C]

Extra gray line added. All new enhancements are on DEV and QA.

Comment entered 2014-01-17 12:47:56 by Juthe, Robin (NIH/NCI) [E]

Verified on QA. Thank you!

Comment entered 2014-02-25 15:44:02 by Juthe, Robin (NIH/NCI) [E]

Verified on prod.

Attachments
File Name Posted User
Articles Without Responses Report.doc 2013-12-10 11:21:24

Elapsed: 0:00:00.000544