[OPEN-ILS-DEV] Reshelving Complete

[Doug Kyle]

[snip]
>> It appears this query is missing items that have never transited.  I'm
>> thinking that is because the left join on action.transit_copy returns nulls
>> where no transit exists, and the HAVING clause
>>
>> MAX(circ.checkin_time) > MAX(trans.dest_recv_time)
>>
>> does not return true for NULL (unknown) values, so instead we need
>>
>> ( MAX(circ.checkin_time) > MAX(trans.dest_recv_time) or
>> MAX(trans.dest_recv_time) IS NULL )
>>
>> Sound correct?
>>
>>     
>
> Indeed.  Would you like to send a trunk-targeted patch, and I'll
> backport from there?
>
>   
Yep, here it is.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: complete_reshelving.patch
Type: text/x-patch
Size: 3072 bytes
Desc: not available
Url : http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20091118/0ba44383/attachment-0001.bin 
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: DCO-1.1.txt
Url: http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20091118/0ba44383/attachment-0001.txt