►
From YouTube: Circulation Special Interest Group - 5/3/2022
Description
00:22:28 Christie: Can you provide the link you are looking at?
00:22:37 George Williams: https://koha-community.org/koha-21-11-released/
00:40:42 George Williams: https://pastebin.com/N9V2tP3A
00:41:54 George Williams: Select your branch|LBRANCH
00:51:26 George Williams: https://pastebin.com/z0AGtpmQ
00:56:19 George Williams: https://pastebin.com/CgmjZSmA
00:58:49 Jason (SEKLS):
SELECT branchcode, count(*)
FROM old_reserves r
WHERE date(timestamp) BETWEEN *date parameter* AND *date parameter*
AND found='F'
GROUP BY branchcode
A
B
B
We
we
skipped
over
all
those
things
that
nobody
cares
about,
like
cataloging
and
acquisitions,
those
things
circulation,
people
never
use.
So
when
we
get
down
to
the
circulation
suggestion
or
section,
the
first
enhancement
says
highlight
patrons
from
logged
in
library
in
patreon
searches.
So
it
looks
like
when
you
do
a
search
like
if
you
search
for
the
name
smith
and
you're
logged
in
at
your
library.
B
All
of
the
results
that
are
at
this
that
have
the
same
home
library
will
be
highlighted
in
green,
so
you
can
more
easily
pick
out
the
ones
that
belong
to
the
library
that
you're
currently
logged
in
at
man.
The
question
is:
do
you
have
a
link
and
so
I'll
put
the
link
in
the
chat
box?
That's
where
the
2111
release
notes
are
and
I'm
down
in
the
circulation
section.
B
The
next
one
says
add
digital
scan
as
an
optional
format
for
article
requests.
I
think
when
you
do
an
article
request,
we
don't
have
it
set
up.
So
this
is
just
a
guess
here,
but
there
you
have
an
option
of
how
you
want
the
article
delivered
and
they're
adding
a
there's
new
option
for
digital
copy.
So
when
you
do
an
article
request,
you
can
say
you
out
of
these
options:
they're,
adding
a
new
option
to
that
drop
down
for
digital
copy.
B
B
B
B
B
B
B
B
B
A
They
were
in
the
bug,
squashing
event.
They
were
doing
some
stuff
this
morning
on
that
page
it
adds
check
boxes
along
the
left
line
of
the
table
and
then
there's
like
a
cancel
hold
button
at
the
top.
Next
to
the
update
holds
button.
That's
dangerous
yeah.
Is
there
a
select
all
button?
I
don't
think
so.
I'm
not
sure.
A
B
A
B
B
B
C
B
Yeah,
I
do
a
report
because
for
the
longest
time,
particularly
at
the
library
I
started
with
koha
at
we
would
have
volunteers
come
in
and
we
would
print
off
the
holds
queue
for
them
to
go,
pull
those,
but
it
had.
It
would
have
patron
names
on
it,
and
so
I
didn't
want
to
pre.
I
don't
want
to
be
giving
something
that
had
people's
names
on
it
to
a
volunteer.
B
So
I
wrote
a
report
that
omitted
the
the
borrower
names
and
just
used
card
numbers
that
has
changed,
but
I
was
able
to
do
a
lot
of
things
that
I
liked
better
with
the
report
than
with
the
built-in
holds
key
report.
You
I
put
barcode
numbers
bar
scannable
barcodes
on
there,
so
that
if
people
didn't
find
things,
they
didn't
have
to
look
it
up.
They
could
just
scan
the
barcode
to
go
right
to
the
item
and
the
market
is
missing.
B
B
A
B
About
that,
okay,
yeah
and
that's
why
I
have
a
version
with
barcodes
and
without
I
have
a
couple
of
libraries
that
they
like
the
barcodes
on
there,
because
if
they
don't
find
things,
it's
a
lot
easier
for
them
to
mark
them
as
missing.
But
there
is
that
potential
to
to
accidentally
check
something
in
or
accidentally
check
something
out
directly
from
the
sheet.
B
B
B
B
B
B
B
B
B
A
So
I've
used
jquery
to
remove
that
from
the
the
holds
queue.
The
core
holds
queue,
but
I
have
some
libraries
that
use
the
print
button.
The
data
tables
print
button
to
to
actually
print
from
that
which
just
creates
a
print
dialogue
page
which
doesn't
know
which
library
logged
in
to
which
means.
I
can't
hide
that
so
I
was
playing
around
with
the
idea
of
adding
fish
to
the
health.
Cue
I'll
show
you
my
screen
and
we've
decided.
A
This
is
just
a
dead
end
and
I
don't
need
to
do
it
but
interesting
because
I
could
I
learned
you
could
use
emojis
and
pre-open
them.
So
there's
my
fish
to
indicate
that
this
hole
doesn't
actually
need
pulled
because
those
the
fish
library
doesn't
share
their
new
stuff.
So
we
restrict
strength
to
everyone
else's
and
stuff,
so
I've
been
playing
with
that,
but
it
breaks
some
things.
So
I
was
like
trying
to
rebuild
the
table.
A
It
breaks
the
column
settings
buttons,
but
I
think
I'm
gonna
give
up
on
that
anyways,
but
I
think
I
will
file
that
bug
because
it's
I
don't
it
didn't
used
to
work
that
way.
It
used
to
not
populate
those
holes
on
the
whole
skew
because
they
obviously
can't
be
triggered.
So
I
think
there
is
a
bug
in
there
somewhere.
B
A
B
B
Yeah
it's
the
barcodes.
Are
there
and
actually
there's
there
is
in
the
sql
library
there
is.
There
are
instructions
on
how
to
do
not
only
the
barcode
three
of
nine,
but
you
can
do
and
there's
like
five
four
or
five
different
fonts
built
into
cohort
directly.
So
so,
if
you
don't
like
that,
barcode
font
you
can
use,
you
can
turn
them
into
qr
codes.
B
C
So
actually
I
do
have
a
circulation
question
and
throw
it
out
to
you
folks.
I
have
I
have
staff
checking
in
newspapers
and
in
this
just
because
with
the
serial
module
and
just
because
it's
we've
been
having
trouble
with
them
being
delivered
and
so
far
I've
set
up
through
the
opac
to
be
notified
when
they
come
in,
but
does
anybody
know
have
have
any
other
way
of
being
notified
of
the
serial
being
received.
B
D
C
C
When
was
the
last
time
we
got
a
paper
in,
and
so
I
had
to
have
them
start
checking
stuff
in
and
it's
it's
been
good
to
track
when
we
don't
get
our
papers-
and
I
can
take
that
back
to
the
publisher,
but
I
also
have
to
be
notified
when
we
get
them
and
when
we
don't,
because
you
know
it's,
I
can
set
up
a
google
reminder,
but
that's
kind
of
my
google
reminder
or
google
calendar
is
packed
right
now.
So.
C
B
A
B
B
B
B
And
there's
that
if
anybody
wants
it
then,
but
that's
the
issue
with
it-
is
each
one
of
those
columns
is
a
separate
sub
query.
It's
a
pretty
simple
sub
query.
It's
you
know
all
it's
doing
is
counting
the
number
of
library
cards
that
were
used
in
the
I
believe
in
the
statistics
table
unique
cards
and
statistics
where,
where
the
type
is
issue
or
renew.
B
B
B
B
C
B
C
B
B
So
and
the
numbers,
the
the
thing
that
that
the
that
the
library
directors
here
always
have
trouble
with
his
request
placed
last
month,
is
how
many
requests
did
people
place.
Last
month
they
sat
down
and
the
request
was
placed
during
the
month
and
the
request
filled
last
month
that
number's
always
different
and
the
reason
it's
always
different
is
it
it's
always
substantially
lower
is
because
that's
how
many
were
actually
checked
out
last
month.
It's
not
it
doesn't
matter
when
they
were
placed.
They
could
have
been
placed
a
year
ago.
B
B
Yeah
the
reason
that
I
have
it
so
that
it
puts
all
this
down
in
a
spreadsheet
is
because
I've
had
all
these
questions
in
the
last
few
years
where
people
you
know-
and
I
had
this
question
before
right
before
the
quahog
conference
last
september-
is
somebody
said
I
need
to
know
circulation
by
zip
code
for
the
last.
You
know
back
to
2008
and
we
don't
keep
data
far
enough
back
to
do
that.
I
actually
one
of
the
things
I
was
able
to
say
to
them.
B
A
C
Yeah
thanks
a
lot
guys
it's
coming
up
to
an
hour
now,
so
I
think
we
can
call
this
a
day
thanks
for
everybody
for
showing
up,
and
hopefully
everything
will
be
back
to
kind
of
normal
next
month.
So
yeah
good
luck
on
that
yeah
everybody
take
care
and
see
you
around
the
quahog
us
groups
bye
still
literally.