Time |
Nick |
Message |
00:34 |
|
eady joined #evergreen |
01:02 |
|
eady joined #evergreen |
01:11 |
|
agoben joined #evergreen |
02:50 |
|
sandbergja joined #evergreen |
06:00 |
pinesol |
News from qatests: Testing Success <http://testing.evergreen-ils.org/~live> |
06:38 |
|
Dyrcona joined #evergreen |
06:59 |
|
agoben_ joined #evergreen |
07:19 |
|
rfrasur joined #evergreen |
07:34 |
|
rjackson_isl_hom joined #evergreen |
07:59 |
Dyrcona |
Hm... So, taking a brick out of rotation, doesn't take the brick out of rotation.... |
08:10 |
|
alynn26 joined #evergreen |
08:26 |
|
Stompro joined #evergreen |
08:39 |
|
mmorgan joined #evergreen |
08:43 |
Dyrcona |
Is it just me or is the Internet slow today? |
08:43 |
|
mantis joined #evergreen |
08:43 |
mmorgan |
kmlussier++ |
09:03 |
|
remingtron joined #evergreen |
09:07 |
csharp |
Dyrcona: things have been squirrely all week |
09:08 |
csharp |
"Lemon, it's Wednesday" |
09:10 |
Dyrcona |
Muddy... |
09:10 |
Dyrcona |
Maybe it really is a DDOS. |
09:25 |
|
jvwoolf joined #evergreen |
09:34 |
jeff |
libraries with 3600 items on the hold pull list, we're breaking it up to be either 1/6 or 1/3 the size. |
09:35 |
jeff |
essentially, adding this to the WHERE clause for our report: (ahopl.usr % 6) + 1) = extract(dow from now() |
09:36 |
jeff |
(the + 1 because otherwise the modulo is between 0 and 5, and we're pulling holds Mon - Sat which extract() indexes as 1 - 6. |
09:36 |
jeff |
) |
09:38 |
jeff |
During our "soft launch" of curbside service, we limited the hold pull list to items for holds where the hold user already had a hold on the shelf ready for pickup. |
09:39 |
jeff |
with AND EXISTS (SELECT 1 FROM action.hold_request AS ahr WHERE ahr.cancel_time IS NULL and ahr.fulfillment_time IS NULL AND ahr.shelf_time IS NOT NULL AND ahr.usr = ahopl.usr AND ahr.pickup_lib = ahopl.pickup_lib) |
09:39 |
Dyrcona |
Uh-huh. |
09:49 |
jeff |
in theory you could update the IDL view, I think ahopl is what the web client uses at least for the pull list, but I'd have to check my notes/code. |
09:49 |
jeff |
the above are just us adjusting SQL in Jasper. |
09:51 |
Dyrcona |
jeff: I'm not so sure of that any more. There are two or three different pull list codes in the Perl, at least one of which does not use ahopl. I forget which on the web staff client uses.... Actually, yeah, since some updates in 3.3 or 3.4, I don't think ahopl is used any more. |
09:52 |
jeff |
there's the newer "wide" hold implementation that gets used in a few places, at least the browse hold shelf feature, i think. |
09:58 |
Dyrcona |
Yes. Too many different implementations of the same code, IMHO. |
09:59 |
Dyrcona |
I could also be confusing the hold targeter code, too. I'm actually focusing on something else and not this conversation. |
10:09 |
Dyrcona |
Y'know, if you have a spreadsheet of the stuff you want me to update, then why don't you attach that to the ticket when you open it? |
10:29 |
csharp |
Dyrcona: +1 |
11:18 |
|
jwoodard joined #evergreen |
12:01 |
|
jihpringle joined #evergreen |
13:07 |
|
collum joined #evergreen |
13:17 |
|
Dyrcona joined #evergreen |
13:20 |
|
remingtron_ joined #evergreen |
13:21 |
|
mrisher joined #evergreen |
13:31 |
|
remingtron__ joined #evergreen |
13:32 |
|
jvwoolf joined #evergreen |
13:36 |
|
remingtron joined #evergreen |
13:46 |
|
remingtron_ joined #evergreen |
13:54 |
|
remingtron joined #evergreen |
13:56 |
|
remingtron_ joined #evergreen |
13:57 |
|
remingtron__ joined #evergreen |
13:59 |
|
collum_ joined #evergreen |
14:02 |
|
remingtron joined #evergreen |
14:05 |
|
mrisher_ joined #evergreen |
16:09 |
|
annagoben joined #evergreen |
16:10 |
* mmorgan |
remembers that the curbside development is on a test server, but can't seem to locate the info. Did I dream that? |
16:11 |
|
troy___ joined #evergreen |
16:12 |
|
dluch_ joined #evergreen |
16:14 |
|
jonadab joined #evergreen |
16:14 |
|
jeff__ joined #evergreen |
16:17 |
jihpringle |
mmorgan: https://docs.google.com/document/d/13DmNCqasfTTPud4Hl5i91UPf_7NGda0bgtimJWc21Vw/edit |
16:17 |
jihpringle |
it was in an email to the dev list |
16:18 |
mmorgan |
jihpringle++ |
16:18 |
mmorgan |
Thought it was an email but couldn't locate it. |
16:20 |
* mmorgan |
always gets into trouble when trying to clean out and organize mail ;-) |
17:02 |
|
mmorgan left #evergreen |
17:11 |
|
rjackson_isl_hom joined #evergreen |
18:00 |
pinesol |
News from qatests: Failed Installing Evergreen pre-requisites - Expected 1 errors but encountered 2. <http://testing.evergreen-ils.org/~live//archive/2020-06/2020-06-17_16:00:03/test.27.html> |
18:12 |
|
rjackson_isl_hom joined #evergreen |
22:56 |
|
sandbergja joined #evergreen |
23:01 |
|
sandbergja joined #evergreen |