[Evergreen-reports] Cancelled Holds Report Template

[Willis, Beth]

HI Rogan,

I wasn't quite sure how to articulate what I want but, yes, I think what I
want is to compare two values: one from the action.hold_request table and
one from the asset.copy.  I want to include on my report only cases where
those two values match.  Impossible?

Thanks!
Beth

On Mon, Dec 21, 2020 at 9:35 AM Rogan Hamby <rhamby at equinoxinitiative.org>
wrote:

> Hi Beth,
>
> I'm not sure I'm following.  You can't have a per row default but it
> sounds like what you really want to do is compare two values per row of the
> report.
>
> For this report it might be simpler to just look at the capture time
> versus the cancel time both on the holds source.
>
>
>
> On Mon, Dec 21, 2020 at 9:30 AM Willis, Beth <willis at noblenet.org> wrote:
>
>> Hi everyone,
>>
>> I am trying to create a report template that includes a filter with a
>> default value, but where that default value references the value of a
>> different field.
>>
>> For example, I am working on a template to show holds that have been
>> cancelled after the targeted items have been put on the hold shelf.  I want
>> to include the action.hold_request.shelf_time as a filter and set its
>> default value to that of the asset.copy.status_chhnged_time.
>>
>> Does anyone know how to do this?  Is it possible in the reporter?
>>
>> Does anyone have a template for  a cancelled holds report like this?
>>
>> Thanks in advance!
>> Beth
>> --
>> Beth Willis
>> Digital & Catalog Librarian
>> NOBLE, Inc.
>> 42 Cherry Hill Drive
>> Danvers, MA 01923
>> _______________________________________________
>> Evergreen-reports mailing list
>> Evergreen-reports at list.evergreen-ils.org
>> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports
>>
>

-- 
Beth Willis
Digital & Catalog Librarian
NOBLE, Inc.
42 Cherry Hill Drive
Danvers, MA 01923
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20201221/d64511f2/attachment.html>