►
From YouTube: System Administration Special Interest Group - 11/8/2022
Description
00:19:04 Andrew Fuerste-Henry: I can't unmute :(
00:19:12 Andrew Fuerste-Henry: mean ol' host won't let me
00:21:08 Andrew Fuerste-Henry: mysterious. brb
00:21:24 Andrew Fuerste-Henry: I clicked the unmute and it didn't do anything. weird. par for week.
00:23:29 Rebecca Coert: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29719Here's the bug I mentioned - fixed in 22.05
00:26:17 Jason - SEKLS: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29792
00:28:53 Andrew Fuerste-Henry: I believe it didn't use to show at all
00:29:01 Andrew Fuerste-Henry: the status, I mean
00:32:50 Jason - SEKLS: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22827
00:33:25 Andrew Fuerste-Henry: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28640
00:39:13 Christie: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31092
00:41:36 Andrew Fuerste-Henry: related to Christie's bug: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28486
00:49:11 Juliet Heltibridle: SELECT
CONCAT_WS('',LEFT(surname,1),RIGHT(cardnumber,5)) AS 'Patron',
-- action_logs.interface,
CASE
WHEN action_logs.interface='opac' THEN 'patron'
WHEN action_logs.interface='cron' THEN 'automatic'
WHEN action_logs.user = '264555' THEN 'self check'
WHEN action_logs.user = '264556' THEN 'self check'
WHEN action_logs.user = '264557' THEN 'self check'
WHEN action_logs.user = '264558' THEN 'self check'
ELSE 'staff'
END AS 'Canceled By',
biblio.title,
author,
itemcallnumber,
barcode,
ifnull(r.holds_count,'None') AS holds_count,
old_reserves.reservedate
FROM action_logs
LEFT JOIN old_reserves ON (action_logs.object=old_reserves.reserve_id AND action_logs.module='holds')
LEFT JOIN biblio USING (biblionumber)
LEFT JOIN items ON (old_reserves.itemnumber=items.itemnumber)
LEFT JOIN borrowers USING (borrowernumber)
LEFT JOIN (SELECT biblionumber, count(reserve_id) AS holds_count FROM reserves WHERE found IS NULL GROUP BY
00:49:34 Juliet Heltibridle: This is my canceled holds report
00:50:24 Juliet Heltibridle: I wanted it to tell me when someone canceled from the self check
00:51:36 Michael Adamyk (CKLS): CASE is my favorite
01:03:05 Juliet Heltibridle: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26591
01:03:26 Andrew Fuerste-Henry: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26591
01:04:43 Ann Flournoy: I have to go work the info desk. Thanks everyone!
A
B
C
B
C
C
C
If
you
use
images
cover
images
from
synthetics,
you
will
now
be
able
to
see
those
on
the
staff
interface,
which
is
nice,
because
you
can
see
DVD
covers
and
thing
it
like.
If
you
use
another
vendor
like
we
use
playaway,
and
so
we
can
see
our
playways
and
our
launch
pads
and
and
all
of
those
things,
that's
kind
of
neat
and
nice
Jason
you're,
you
have
it
on
your
test
site.
A
C
B
A
A
C
C
A
C
E
C
A
D
A
But
now
it's
got
a
little
like
CSS
to
it.
So
it's
pretty
obvious.
It's
a
report
ID.
They
also
grouped
the
editor
buttons
together
so
like
before
big
groups
and
buttons
together
in
that
toolbar.
So
before
you
had
like
edit
and
duplicate
and
I,
think
those
are
in
like
a
grouped
edit
button.
Now
that
has
a
drop
down.
C
So
another
one
we
came
across
is
on
the
add
item
page
all
of
the
different
drop
down
menus.
The
cursor
is
not
automatically
in
the
drop
down.
You
have
to
go
and
put
it
there
and
I
think
that's
supposed
to
be
fixed
in
like
22
.05.07,
or
something
like
that.
So
probably
by
the
time
most
people
get
there.
I
bet
that'll
be
fixed
already.
A
D
You
know
we
don't
use
the
Kohan
OPAC,
so
I
was
wondering
if
it
was.
It
was
something
that
we're
going
to
have
to.
We
can
just
ignore,
but
it
sounds
like.
If
it's
on
the
staff
side,
then
I'll
probably
have
to
set
up
the
the
notice,
just
in
case
some
of
our
our
search
staff,
get
you
know
motivated
to
use
it
so
yeah.
A
D
A
Another
sort
of
big
big
one
is
the
hold
history
in
the
OPEC,
so
patrons
didn't
have
control
over
that
in
the
past.
Now
they
do
in
the
Privacy
tab
of
the
opacity
there's
a
separate
button
to
delete
the
whole
history
separate
from
the
checkout
history
and
then
there's
like
a
third
button.
Now
that
deletes
both.
At
the
same
time,
foreign.
A
B
C
So
we
had
like
on
one
view
of
a
record
like
in
the
patron
record.
It
would
maybe
show
it
had
been
turned
in.
But
if
you
went
over
to
like
the
ad
item
page,
it
still
showed
it
was
checked
out
and
they
looked
at
stuff
and
just
said
that
you
know
something
had
gotten
a
little
bit
out
of
sync
and
it
all
caught
up.
So
I,
don't
know
if
that
was
just
us
or
whether
that's
you
know
a
wider
issue.
D
D
E
A
A
A
With
the
ability
to
use
the
webcam
directly
within
cohort
upload,
Patron
images
I've
done
that
a
little
bit
on
my
test
server
and
it's
like
it
works,
but
it
doesn't
work
like
once.
You
go
to
upload
Android
once
you
go
to
like.
So
it
takes
the
picture
and
then,
when
you
click
upload
it
it
errors
out
or
something
and
I
I
wonder
if
it
has
to
do
with
like
the
size
of
the
picture.
It's
capturing
or
something
I
haven't
had
a
chance
to
like
poke
around
at
it.
G
For
this
stuff,
that's
showing
up
in
your
catalogs
as
both
available
and
checked
out,
is
that
that
old,
dumb
data
problem,
where
it's
it's
the
item,
dot
issues
field
ends
up
with
a
value
in
it
that
didn't
get
deleted.
It's
it's
that
mismatch
where
the
item
number
isn't
in
an
actual
entry
in
the
issues
table,
but
the
place
in
the
items
table
is
supposed
to
be
kept
in
sync
to
Remember
If,
an
item
is
checked
out,
gets
messed
up,
which
is
it's
where
we've
seen
that
before,
where
it
says
both
available
and
checked
out.
G
D
A
B
G
A
A
Things
that'll
like
transfers,
that'll
get
initiated
but
not
completed,
and
then
they
get
stuck
so
they'll
show
up
on
that
transfers
to
send
report,
even
though
they
don't
actually
need
to
set
anywhere,
and
this
bug
was
like
had
to
do
with
the
the
modal
like
when
you
pop
up
to
transfer
it.
If
you
don't
click
any
of
the
buttons
in
it,
then
the
transfer
sort
of
does
this
little
toggle
thing
where
it's
like
I'm
in
transit,
I'm
out
of
Transit
I'm
in
transit,
I'm
out
of
Transit.
A
So
if
you
push
the
button,
it
always
forced
it
back
into
Transit,
but
if
you
didn't
push
the
button,
which
is
what
some
of
my
libraries
are
used
to,
it
would
flip
back
and
forth
and
become
ambiguous
on
how
its
Transit
status
really
should
have
been
so
this.
This
bug
fixes
that
specific
problem,
but
that
would
be
my
guess.
It's
that
whole,
like
toggling
of
the
transfer
status
that
is
giving
you
these
weird
situations.
F
It'll
now
say:
I'll
show
you
one
where
it's
correct.
Where
see
I
don't
know
what
this
is
either.
It's
supposed
to
tell
you
like
what
day
it
was
ordered,
oh
opened
on
831,
so
EDI
says
it
was
ordered
on
this
date.
So
essentially
this
function's
supposed
to
work,
and
then
invoicing
is
supposed
to
be
coming
in
as
well
as
we
do
it
FTP
invoicing,
but
again
on
those
baskets
where
it
says
not
ordered
it
doesn't
seem
like
the
functionality.
F
I
I
think
maybe
that
EDI
status,
it's
meant
to
only
be
updated
when
the
order
is
actually
generated,
and
it's
to
let
you
know
that,
although
you
might
have
created
the
order
on
one
day,
it
wasn't
transmitted
until
you
know
a
separate
date,
but
then
I
think
it
stays
at
that
date.
I
don't
think
it
gets
updated.
F
Yeah
I
think
you're
correct,
but
the
problem
is:
is
that
all
of
the
orders
I
usually
place
the
same
day
as
I,
create
the
basket
and
what's
happening
it's
not
all
of
the
baskets
are
showing
some
of
them
are
still
saying,
not
ordered
when
in
fact,
the
vendors
receive
the
order.
So
there's
some
kind
of
glitch
and
I
I
did
open
a
ticket
with
buy
water
on
that
and
they're
they're
also
may
or
may
not
be
the
connection
that.
H
F
A
I
I
A
A
F
I
was
deleting
those
once
the
order
was
sent
through
to
the
vendor,
but
Kyle
had
said
with
this
new
functionality
that,
if
I
deleted
those
messages
after
submission
that
that
functionality
would
not
work,
it
reverts
back
to
saying
not
ordered.
So
he
wanted
me
to
keep
all
of
those
in
our
system
till
the
end
of
the
fiscal
year,
in
which
case
I
can
contact
Bywater,
and
they
could
do
like
a
batch
solution
because,
right
now
you
can
only
delete
one
at
a
time
which
is
very
time
consuming.
F
G
So
the
book
that
I
posted
is
just
the
one
that
added
that
field
to
that
page
that
made
that
status
visible
on
the
basket
page
I
am
not
a
coder,
but
I
can
sometimes
muddle
through
some
code.
This
looks
like
it
is
just
checking
the
status
of
the
basket
like
I,
don't
see
anything
here
that
should
impact
invoices,
and
it
really
does
seem
like
it.
G
F
F
Some
of
them
still
say,
processing,
which
is
weird
because
again,
oh
that's
for
the
invoices,
sorry,
the
orders
say
sent
so
they're
all
incense
status
and
the
invoices
that
I
haven't
received,
still
say
processing.
But
again
it's
only
on
two
of
my
accounts
same
vendor,
I
can
I
can
I
can
show
you
guys
so
so
see
for
some
of
them.
They're
getting
received.
Orders
are
all
sent
but
like
for
this,
like
this
broader
trust
that
they're
still
in
processing
but
I've
confirmed
with
the
vendor
that
the
EDI
invoices
have
been
posted.
F
G
I,
don't
specifically
know
what
that
means.
My
best
guess
would
be
that
it's
something
with
the
credentials
you're
using
to
get
into
the
the
FTP
site,
but
if
you've
grabbed
the
invoice
like
if
the
invoice
has
made
it
into
koha,
you
obviously
connected
to
the
FTP,
so
I
I
don't
know
what
other
credentials
would
would
come
into
play.
There.
G
G
G
G
So
I
went
back
and
tested
this
after
we
met
last
time
and
that
transfer
does
not
get
canceled.
Koha
just
leaves
it
there.
It
continues
to
try
to
cancel
or
transfer
that
item.
Somebody
suggested
that
they
thought
automatic
item
return
might
play
into
how
that
plays
out.
How
Koh
handles
that
transfer
that
canceled
hold
with
a
transfer.
It
has
no
impact,
it
just
sort
of
transfers
the
item,
and
then
the
item
is
at
that
new
Branch.
With
no
reason
to
be
there.
G
K
F
There's
another
bug
actually
Andrew
was
working
on
it
for
me
before
he
left
by
water.
He
was
helping
out,
but
again
it's
Acquisitions
and
it
was
a
matter
of
when
we
get
I
I
put
a
bug
in
for
it,
and
apparently
Bywater
is
working
on
something
like
it,
but
it
seems
like
easy
script
to
write
for
all
of
the
poha
community
and
it's
a
matter
of
when
you
order
items.
F
If
you
have
a
full
Mark
record
already
in
your
system,
and
you
don't
want
the
batch
item
records
that
come
in
to
override
or
overlay
those
records.
Rather
it
would
look
at
the
leader
on
each
marked
record
and
decide.
Is
this
the
complete
record
or
an
incomplete
record,
and
then
it
would
override
if
it
was
incomplete
or
not
not
override
or
overlay?
Rather,
if
it
was
complete
and
apparently
other
ILS
systems
utilize
this,
but
I
just
wanted
to.
F
Let
everyone
know
that
as
an
Acquisitions
person,
it's
been
frustrating
because
we've
had
to
set
up
not
just
myself,
but
other
libraries
have
had
to
set
up
separate
accounts
with
vendors
for
those
that
are
like
added
items.
So
we
did
get
sent
records
that
will
not
over
or
we
don't
get
something
records.
Rather,
we
could
set
the
item
record
to
add
to
our
ILS,
but
anyway,
it's
in
the
works
and
I
put
kind
of
a
detailed
description
of
how
it
might
be
solved.
D
G
G
J
G
A
G
I
know
there's
a
bug
out
there
somewhere.
That
would
let
you
match
on
blanks
like
match
to
where
collection
code
is
null
or
and
also
like,
set
things
to
Blanks
and
nulls,
which
would
be
another
nice
move,
because
right
now,
there's
no
way
to
say,
like
anything,
that's
in
the
new
collection
after
three
months
put
it
in
no
collection.
If
you
just
don't
use
collection
codes.
B
G
F
We
have
some
of
those
that
they
get
canceled
in
transit
and
then
they're
in
that
limbo
stage.
But
when
you
do
check
in
the
book,
I
think
it
corrects
itself
and
then
like
Andrew,
you
mentioned,
there's
a
revert
status
but
yeah.
Sometimes
you
can't
change
it
like
one
time.
I
I
I
check
in
a
book
and
it
triggered
the
hold,
and
so
it
was
in
now
it
was
in
transit.
But
then
I
realized
that
it
was
an
item.
F
K
K
A
The
problem
I
think
the
biggest
problem
we
run
into
is
like
it
gets
put
into
Transit
the
whole
gets
transferred,
but
it
doesn't
actually
get
where
it's
going
and
then,
when
you
check
it
in
it
still
wants
to
go
where
it's
going.
So
you
have
to
go
in
and
cancel
the
transfer
from
like
the
transfers
to
receive
report
or
something
or
send
it
so
that
it
can
come
back,
get
checked
in
at
the
other
library
and
come
back
which
is
excessively
unneeded
so
yeah.
It
is
a
it's
a
messy
situation
for
us.
H
I've
also
found
that
it
causes
some
problems
with
libraries
who
are
trying
to
clean
up
their
transfers
to
receive,
and
we've
had
some
issues
with
the
Courier
and
things
getting
lost
and
so
they're
trying
to
clean
that
up.
But
there's
a
lot
of
things
they
can't
check
in
and
it
gets
kind
of
frustrating
for
them
to
not
be
able
to
clear
those
things
off
that
are
lost
for
a
long
time
so
I'm.
It
would
be
helpful
to
move
them
to
a
loss
status
so
they're
not
still
on
the
report.
B
G
A
A
Like
a
way
to
batch,
cancel
the
transfer
and
then
batch
add
the
item
based
on
date
right
so
like
you're
looking
at
things
that
have
a
set
date,
but
no
receive
date,
you
have
to
Target
those
and
then
Mark
them
off
I
mean
you
could
do
that
with
a
report
and
batch
item
modification,
but
they
still
have
those
transfers
hanging
out.
So
if
you
want
those
the
status
to
fully
change,
you'd
have
to
resolve
the
transfer
somehow.
A
F
Kind
of
along
those
lines
does
anyone
have
a
an
efficient
way
of
working
with
holds
that
have
not
been
pulled
from
the
shelf
that
have
been
canceled
so
again,
they're
kind
of
in
limbo.
So
what
what
we
do
right
now
is
we
have
to
look
at
it.
You
know
with
our
own
eyes
and
say:
okay,
which
dates
have
already
expired
until
these
books,
but
does
anyone
else
have
an
easier
way
to
do
that.
G
F
F
G
E
I
was
trying
to
explain
it
in
the
chat
and
then
I
thought
I
should
probably
say:
I
wanted
it
to
tell
me
who
was
canceling
the
hold,
whether
it
was
a
patron
or
if
it
was
automatically
canceled
or
if
it
was
done
at
the
self-check.
So
it's
got
some
of
those
in
there
and
then
it
also
just
gives
me
the
information.
I
I
G
B
D
B
G
J
That
question
sort
of
related
to
reading
history-
a
patron
asked
me
just
this
week
if
it
was
possible
to
have
the
system,
warned
them
that
they've
checked
out
something
before
you
know,
because
they
don't
want
to
check
it
out
again.
If
they've
already
read
it
I'm,
not
aware
of
any
sitting
like
that.
Does
anybody
know
of
anything.
A
G
G
G
J
G
A
J
G
G
F
G
K
G
G
G
Basically,
you
have
to
tell
koha
whether
or
not
to
save
it
and
whether
or
not
you
give
your
patrons
the
ability
to
stop
it
from
saving
it.
But
then,
if
that's
getting
retained
when
they
log
into
the
OPAC
see
I'm
logged
in
as
Henry
here
he's
got
his
check
out
history
visible
and
then
there's
a
whole
bunch
of
settings
of
like
how
long
do
you
want
to
keep
that
again?
Do
you
want
people
to
be
able
to
opt
out
of
it,
or
do
you
just
want
it
all
enough
for
everybody,
good,
a
thousand
choices.