[OPEN-ILS-DEV] Reshelving Complete

[Mike Rylander]

On Wed, Nov 18, 2009 at 10:32 AM, Doug Kyle <dkyle at grpl.org> wrote:
> [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.
>

Finally committed.  Thanks, Doug, and sorry for the extreme delay.
It'll be in 1.6.0.1!

-- 
Mike Rylander
 | VP, Research and Design
 | Equinox Software, Inc. / The Evergreen Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  miker at esilibrary.com
 | web:  http://www.esilibrary.com