| Issue Number | 3435 |
|---|---|
| Summary | [Media] adhoc queries for rejected audio files |
| Created | 2011-10-18 11:20:42 |
| Issue Type | Improvement |
| Submitted By | Osei-Poku, William (NIH/NCI) [C] |
| Assigned To | alan |
| Status | Closed |
| Resolved | 2011-10-18 15:38:26 |
| Resolution | Duplicate |
| Path | /home/bkline/backups/jira/ocecdr/issue.107763 |
BZISSUE::5129
BZDATETIME::2011-10-18 11:20:42
BZCREATOR::William Osei-Poku
BZASSIGNEE::Alan Meyer
BZQACONTACT::William Osei-Poku
We need two adhoc queries that will list audio files that have been
reviewed and marked as rejected;
one for English pronunciation files and the other for Spanish
pronunciation files.
For each (language) query, the display should include the total count
of rejected
pronunciations per zip file as well as a total of all rejected
pronunciations across all
zip files for a language. It should also include the date each
pronunciation was marked as rejected.
If you store information about the user who performs the approval,
please include that as
another column.
Example (assuming user information is stored):
REJECTED ENGLISH AUDIO PRONUNCIATIONS - ENGLISH:
Week_030_.Zip
TERMS | DATE REJECTED | USER
Term 1 2011-10-15 Akuhlmann
Term 2 2011-10-16 Akuhlmann
Subtotal - English = 2
Week_031_.Zip
TERMS | DATE REJECTED | USER
Term 1 2011-10-20 Akuhlmann
Term 2 2011-10-21 Akuhlmann
Term 3 2011-10-22 Akuhlmann
Subtotal - English = 3
TOTAL ENGLISH PRONUNCIATIONS = 5
BZDATETIME::2011-10-18 15:38:08
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::1
This task is being performed as part of OCECDR-3434.
BZDATETIME::2011-10-18 15:38:26
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::2
closing bug
Elapsed: 0:00:00.001421