| Issue Number | 3130 |
|---|---|
| Summary | Board Member not listed on Mailer Reports |
| Created | 2010-04-16 15:15:33 |
| Issue Type | Improvement |
| Submitted By | Englisch, Volker (NIH/NCI) [C] |
| Assigned To | Englisch, Volker (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2010-04-28 14:41:20 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.107458 |
BZISSUE::4807
BZDATETIME::2010-04-16 15:15:33
BZCREATOR::Volker Englisch
BZASSIGNEE::Volker Englisch
BZQACONTACT::William Osei-Poku
The board member Paul Bunn is missing from the output when running the SummaryMailer Report.
BZDATETIME::2010-04-16 15:26:13
BZCOMMENTOR::Volker Englisch
BZCOMMENT::1
Adding dependency.
It turns out that the person 'Paul Bunn' has two PDQBoardMember records, an active one and a blocked one. The blocked record had been entered at some time in error, however, the queries selecting the board member information didn't take into account that a BoardMember record could be listed multiple times.
I've modified the program
SummaryMailerReport.py
to limit the selection to only include active documents (not blocked)
which should work until the invalid record is being deleted as is
suggested for OCECDR-3113.
This is ready for review on MAHLER and FRANCK.
BZDATETIME::2010-04-16 16:14:38
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::2
(In reply to comment #1)
> Adding dependency.
>
> It turns out that the person 'Paul Bunn' has two PDQBoardMember
records, an
> active one and a blocked one. The blocked record had been entered
at some time
> in error, however, the queries selecting the board member
information didn't
> take into account that a BoardMember record could be listed
multiple times.
>
> I've modified the program
> SummaryMailerReport.py
> to limit the selection to only include active documents (not
blocked) which
> should work until the invalid record is being deleted as is
suggested for Bug
> 4789.
>
> This is ready for review on MAHLER and FRANCK.
Verified on Franck. It is picking up both documents. Would it be possible to rather exclude a blocked document from the report instead of picking up both the blocked one and the active one?
BZDATETIME::2010-04-16 16:21:03
BZCOMMENTOR::Volker Englisch
BZCOMMENT::3
How do you identify that the report is picking up both records?
I was running the 'Summary Mailer Report' but I don't see any record that would identify one of the records to come from the blocked document.
BZDATETIME::2010-04-16 16:29:34
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::4
(In reply to comment #3)
> How do you identify that the report is picking up both
records?
> I was running the 'Summary Mailer Report' but I don't see any
record that would
> identify one of the records to come from the blocked document.
You're right. I assumed that since it had two rows, one of them was coming from the blocked record and the other one was coming from the active record. Sorry about that...
Please promote to Bach.
BZDATETIME::2010-04-16 16:34:48
BZCOMMENTOR::Volker Englisch
BZCOMMENT::5
The following program has been copied to FRANCK and BACH:
SummaryMailerReport.py - R9589
Please verify on BACH and close this bug.
BZDATETIME::2010-04-16 16:49:29
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::6
(In reply to comment #5)
> The following program has been copied to FRANCK and BACH:
> SummaryMailerReport.py - R9589
> Please verify on BACH and close this bug.
Verified on Bach. Victoria may want to take a look before the issue is closed.
BZDATETIME::2010-04-28 14:41:20
BZCOMMENTOR::Volker Englisch
BZCOMMENT::7
Victoria had confirmed that Mr. Bunn is now displayed on her reports.
Closing issue.
Elapsed: 0:00:00.001444