| Issue Number | 3106 |
|---|---|
| Summary | Genetics Professional documents ad hoc query |
| Created | 2010-03-08 14:28:05 |
| Issue Type | Improvement |
| Submitted By | Osei-Poku, William (NIH/NCI) [C] |
| Assigned To | Englisch, Volker (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2010-03-09 14:57:02 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.107434 |
BZISSUE::4782
BZDATETIME::2010-03-08 14:28:05
BZCREATOR::William Osei-Poku
BZASSIGNEE::Volker Englisch
BZQACONTACT::William Osei-Poku
As we complete the cleanup of the Genetics documents, we need to identify all Genetic professional documents that we have not reviewed since they were converted (Bach) on 01/27/2010.
Please write an ad hoc query and include it in the ad hoc query report menu for
1. All Genetic Professional person records
2. That do NOT have their GENETICS directory include value set to “Do Not Include”
3. OR have their directory include value set to “Include”
4. That do NOT have a publishable version by any of the following users [ woseipoku, jmorris, lhoward], since the conversion on 01/27/2010.
Report the CDR ID, Name of the Person and the publishability [Y OR NO] and their directory status [Include or Do not include]
CDR ID | Name of Professional | Publishable| Directory Status
BZDATETIME::2010-03-08 18:27:30
BZCOMMENTOR::Volker Englisch
BZCOMMENT::1
(In reply to comment #0)
> 1. All Genetic Professional person records
Done.
> 3. OR have their directory include value set to “Include”
Done.
> 4. That do NOT have a publishable version by any of the
following users [
> woseipoku, jmorris, lhoward], since the conversion on
01/27/2010.
Done.
I'm not sure if this is what you had in mind. The query might need some
tweaking.
BZDATETIME::2010-03-08 18:50:20
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::2
(In reply to comment #1)
> (In reply to comment #0)
> > 1. All Genetic Professional person records
> Done.
> > 3. OR have their directory include value set to
“Include”
> Done.
> > 4. That do NOT have a publishable version by any of the
following users [
> > woseipoku, jmorris, lhoward], since the conversion on
01/27/2010.
> Done.
> I'm not sure if this is what you had in mind. The query might need
some
> tweaking.
Actually, I was not looking for multiple queries. The numbering may have been confusing. I was just enumerating the criteria for the query. Is it possible to combine them into one query?
The All Genetics Professional person records w/'include'' is what I am looking for. If you can exclude all the ones that we [the three users) have already made publishable and leave the ones that we [the three users) have not made publishable, that would be great. Generally, we want to know how many we have not reviewed yet.
BZDATETIME::2010-03-08 19:01:04
BZCOMMENTOR::Volker Englisch
BZCOMMENT::3
(In reply to comment #2)
> The numbering may have been confusing.
Indeed.
> Generally, we want to know how many we have not reviewed yet.
That question is answered with the last query.
BZDATETIME::2010-03-08 19:06:14
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::4
(In reply to comment #3)
> (In reply to comment #2)
> > The numbering may have been confusing.
> Indeed.
> > Generally, we want to know how many we have not reviewed
yet.
> That question is answered with the last query.
The problem with the last query is that it does contain persons with a directory valude of "Do not include". For examples CDR0000664947.
BZDATETIME::2010-03-09 09:53:39
BZCOMMENTOR::Volker Englisch
BZCOMMENT::5
(In reply to comment #4)
> The problem with the last query is that it does contain persons
with a
> directory valude of "Do not include". For examples
CDR0000664947.
Not anymore.
BZDATETIME::2010-03-09 14:57:02
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::6
(In reply to comment #5)
> (In reply to comment #4)
> > The problem with the last query is that it does contain
persons with a
> > directory valude of "Do not include". For examples
CDR0000664947.
>
> Not anymore.
Looks good. Thank you!
Issue closed.
Elapsed: 0:00:00.001716