Issue Number | 3083 |
---|---|
Summary | [Adhoc Query] Need adhoc query for transfer contact logs |
Created | 2010-02-05 16:51:30 |
Issue Type | Improvement |
Submitted By | Grama, Lakshmi (NIH/NCI) [E] |
Assigned To | Kline, Bob (NIH/NCI) [C] |
Status | Closed |
Resolved | 2010-02-18 15:11:11 |
Resolution | Fixed |
Path | /home/bkline/backups/jira/ocecdr/issue.107411 |
BZISSUE::4759
BZDATETIME::2010-02-05 16:51:30
BZCREATOR::Lakshmi Grama
BZASSIGNEE::Bob Kline
BZQACONTACT::William Osei-Poku
I need a query that counts the number of InscopeProtocolstrials that have a CTGOVOwnershipTransferContactLog element and lists Protocol ID, and the value in the CTGOVOwnershipTransferContactResponse element, Date, Comment. I don't believe there is a query that already does this.
BZDATETIME::2010-02-05 18:36:07
BZCOMMENTOR::Bob Kline
BZCOMMENT::1
(In reply to comment #0)
> I need a query that counts the number of InscopeProtocolstrials
that have a
> CTGOVOwnershipTransferContactLog element and lists Protocol ID, and
the value
> in the CTGOVOwnershipTransferContactResponse element, Date,
Comment. I don't
> believe there is a query that already does this.
No there isn't. In fact there can't be until those element are added to the query_term table. I'll start the re-indexing after the weekly publishing job is done.
BZDATETIME::2010-02-05 22:47:24
BZCOMMENTOR::Bob Kline
BZCOMMENT::2
Query installed on Bach as "Transfer log info."
BZDATETIME::2010-02-08 10:03:26
BZCOMMENTOR::Lakshmi Grama
BZCOMMENT::3
Can you post the link to the CDRQuery interface. I don't have a bookmark on my home computer
BZDATETIME::2010-02-08 11:38:22
BZCOMMENTOR::Bob Kline
BZCOMMENT::4
BZDATETIME::2010-02-08 16:20:00
BZCOMMENTOR::Lakshmi Grama
BZCOMMENT::5
This is helpful. Just want to have Kim or Andrea take a look to make sure numbers look OK to them.
BZDATETIME::2010-02-08 21:07:09
BZCOMMENTOR::Kim Eckley
BZCOMMENT::6
(In reply to comment #5)
> This is helpful. Just want to have Kim or Andrea take a look to
make sure
> numbers look OK to them.
This looks OK - but I have one question about the query parameters.
Inscope trials is specified. If a trial converted to CTGov doc type, it should be counted/listed as well. Are those trials reflected on this query?
Thanks!
BZDATETIME::2010-02-08 23:54:21
BZCOMMENTOR::Bob Kline
BZCOMMENT::7
(In reply to comment #6)
> Inscope trials is specified. If a trial converted to CTGov doc
type, it should
> be counted/listed as well. Are those trials reflected on this
query?
No, those wouldn't match the original request for the report, which asked for InScopeProtocol documents.
BZDATETIME::2010-02-09 09:12:05
BZCOMMENTOR::Lakshmi Grama
BZCOMMENT::8
We know the number of trials that we have transferred from other reports. I wanted the number of trials that we have called and not yet transferred as well as trials that contacts have said do not need to be transferred. That should be obtainable from Inscope trial logs. Are there other parameters that I am missing?
BZDATETIME::2010-02-09 09:33:21
BZCOMMENTOR::Kim Eckley
BZCOMMENT::9
(In reply to comment #8)
> We know the number of trials that we have transferred from other
reports. I
> wanted the number of trials that we have called and not yet
transferred as well
> as trials that contacts have said do not need to be transferred.
That should be
> obtainable from Inscope trial logs. Are there other parameters that
I am
> missing?
If that is all you are interested in, then you should be fine. Just remember to NOT look at the bottom line for a count, as one of the call responses is equivalent to being transferred. 🙂
BZDATETIME::2010-02-09 13:41:33
BZCOMMENTOR::Kim Eckley
BZCOMMENT::10
I actually have a minor request to this one...
Would it be possible to add a date parameter based on the date in the transferCallLog block?
This would help us with tracking attempts to transfer for monthly reporting.
Thanks!!
BZDATETIME::2010-02-09 15:21:12
BZCOMMENTOR::Bob Kline
BZCOMMENT::11
Sure. It'll have to be later (we've been told we're not allowed to work while the government offices are closed).
BZDATETIME::2010-02-16 08:17:24
BZCOMMENTOR::Bob Kline
BZCOMMENT::12
(In reply to comment #10)
> I actually have a minor request to this one...
>
> Would it be possible to add a date parameter based on the date in
the
> transferCallLog block?
I assumed (since you characterized the request as 'minor') that you wanted the query itself modified with a WHERE clause which restricted the results to a specific date range, which you could then edit by hand and run. Re-implementing the report with a custom request interface which would allow the person running the report to enter the date range in form fields would be possible, but not a minor modification to the ad-hoc query. I have made the modification and saved the query so that the date range matches all of this month. You can change the dates (with or without saving the changes to the query) and submit the query to get results matching the date range you specify. Is this what you had in mind?
BZDATETIME::2010-02-16 08:26:49
BZCOMMENTOR::Kim Eckley
BZCOMMENT::13
(In reply to comment #12)
> (In reply to comment #10)
> > I actually have a minor request to this one...
> >
> > Would it be possible to add a date parameter based on the date
in the
> > transferCallLog block?
> I assumed (since you characterized the request as 'minor') that you
wanted the
> query itself modified with a WHERE clause which restricted the
results to a
> specific date range, which you could then edit by hand and
run.
> Re-implementing the report with a custom request interface which
would allow
> the person running the report to enter the date range in form
fields would be
> possible, but not a minor modification to the ad-hoc query. I have
made the
> modification and saved the query so that the date range matches all
of this
> month. You can change the dates (with or without saving the changes
to the
> query) and submit the query to get results matching the date range
you specify.
> Is this what you had in mind?
Bob, I'm so glad you use your powers for good not evil.
Yes, this is exactly what I wanted! Thank you!
BZDATETIME::2010-02-16 08:27:20
BZCOMMENTOR::Kim Eckley
BZCOMMENT::14
(In reply to comment #12)
> (In reply to comment #10)
> > I actually have a minor request to this one...
> >
> > Would it be possible to add a date parameter based on the date
in the
> > transferCallLog block?
> I assumed (since you characterized the request as 'minor') that you
wanted the
> query itself modified with a WHERE clause which restricted the
results to a
> specific date range, which you could then edit by hand and
run.
> Re-implementing the report with a custom request interface which
would allow
> the person running the report to enter the date range in form
fields would be
> possible, but not a minor modification to the ad-hoc query. I have
made the
> modification and saved the query so that the date range matches all
of this
> month. You can change the dates (with or without saving the changes
to the
> query) and submit the query to get results matching the date range
you specify.
> Is this what you had in mind?
Bob, I'm so glad you use your powers for good not evil.
Yes, this is exactly what I wanted! Thank you!
BZDATETIME::2010-02-18 15:11:11
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::15
Closing this issue since all work on the issue has been completed.
Elapsed: 0:00:00.001235