►
Description
Is your holds queue not getting the attention it deserves? Are the holds piling up? Well, unless you want to add 'Policing the Queue' to your list of duties, you might want to consider watching this week's episode. We even have a special guest! Here's a hint: he likes sharks!
Contents:
0:00 - Title
0:27 - Intros
2:32 - What are we talking about today?
6:00 - George's Approach
7:32 - George's SQL Reports
10:32 - George's jQuery
13:00 - Jason's Approach
18:21 - Jason's CSS
19:53 - The Animista Animation
20:58 - Jason's jQuery
22:14 - Jason's SQL Report
24:44 - Accessing the Emoji Keyboard
25:38 - The Confetti
27:12 - Wrap Up
Supplemental links:
https://hopperdietzel.org/koha_notes/holds_queue_count
https://github.com/jsonks/Koha-Modifications/tree/main/Staff/HoldsQueueTweaks
https://animista.net/
https://github.com/loonywizard/js-confetti
Music: https://bensound.com
Audio Effects: https://zapsplat.com
Visual Effects: https://flexclip.com
C
A
Jason,
we
are
sponsored
by
koha
us,
you
can
find
kohai
us
at
koha-us.org
and
you'll
find
all
of
our
resources
that
we
share
out
to
the
koha
community,
whether
you're
in
the
U.S
or
not,
also
a
reminder
you
will
find
all
of
our
videos,
these
videos
that
we
record
we
keep
them
stored
under
learn
and
video.
Playlists
you'll
find
all
of
our
videos
there,
as
well
as
other
videos
that
we
have
curated
and
taken
from
other
sources,
but.
D
A
Because
if
you
want
to
be
notified,
when
we
post
our
new
videos,
you
can
subscribe
to
our
Channel,
you
can
also
subscribe
to
our
playlist.
If
you
specifically
want
these
videos,
you
can
like
the
videos
that
you
enjoy
and
let
us
know
what
floats
your
boat
and
you
can
also
comment
on
our
videos.
Let
us
know
your
thoughts.
A
A
Well,
today,
we're
going
to
be
talking
well,
okay,
I
have
to
say
this.
This
came
to
mine
for
me
when
we
were
going
over
some
items
where
we
were
modifying
the
koha
homepage
Dash
and
adding
elements
that
aren't
usually
there
and
I
actually
thought
it
would
be
a
great
idea
if
we
could
have
something
there
to
notify
us
when
you
know
we
have
holds
that
are
that
are
waiting
rather
than
having
to
go
to
a
different
page
and
go
search
and
find
out
whether
or
not
there
are
holds
waiting.
A
B
For
it
yeah,
so
what
happened
to
me
is
that
there
was
a
somebody,
one
of
our
staff
at
one
of
our
51
libraries,
brought
to
my
attention
that
there
was
a
title
out
there
that
had
three
items
attached
to
it
at
three
different
libraries
and
they
thought
that
all
three
of
those
items
might
be
different
than
the
bibliographic.
They
might
not
all
go
with
that
bibliographic
record.
B
They
think
that
maybe
there
was
somebody
added
a
wrong
type
added,
a
wrong
item
to
that
title
and
then
maybe
it
got
merged
with
something
else
anyway,
back
in
this
happened
back
in
August
and
I.
Put
requests
item,
requests
on
all
three
of
those
items
and
two
of
them
arrived
at
my
office
pretty
quickly
and
I
was
able
to
determine
yes,
those
are
two
different
titles
they're
on
the
same
bibliographic
record
and
one
of
them
didn't
come.
It.
D
B
In
August-
and
it
was
like
a
week
ago
that
I
realized
you
know,
I've
still
got
these
things
sitting
on
my
desk
because
I'm
waiting
for
the
third
one
to
come
in
and
I
thought.
Well,
okay,
maybe
it's
checked
out
and
so
I
looked
it
up
and
it
hasn't
checked
out
in
the
last
five
years,
which
actually
makes
it
a
good
candidate
for
weeding.
But
that's
another
story
but
I.
So
I
looked
at
the
library's
whole
list
at
their
holds
queue
and
they
had.
B
B
Handy
it
would-
and
you
know-
and
we
talked
about
it
at
some
point
in
the
past-
about
it-
would
be
nice
to
have
something
there
and
then,
oddly
enough,
the
next
day
I
was
at
a
kohai
us
meeting
and
Jason
was
there
and
he
has
a
similar
issue
and
he
came
up
with
a
different
Solution.
That's
why
I
thought
it'd
be
fun
to
have
him
here
to
show
his
solution.
B
His
solution
is
more
fun
quite
frankly,
so
let
me
share
my
screen
and
show
you
what
I
came
up
with,
though,
is
on
the
home
page.
Here,
I
put
a
little
box
up
here
and
I
put
a
big
huge
button
in
it.
That
says,
holds
Q
one
item
in
the
holds
q
and
I'm
currently
logged
in
at
Northeast
Kansas
library
system.
If
I
switch,
my
library
to
let's
go
to
Ottawa
is
one
of
our
bigger
libraries,
Ottawa
Kansas.
If
I
switch
to
Ottawa,
they
have
41
items
and
their
holds
Q
nice.
B
If
I
switch
to
baser
is
another
one
of
our
bigger
libraries,
they
have
30
items
in
their
whole
excuse
so
no
matter
which
Library
you
log
into
it's
going
to
populate
that
counter,
with
the
number
of
items
that
are
on
hold
currently
at
that
Library
they're
in
the
holds
queue.
This
is
our
holds.
Queue
gets
rebuilt
every
hour
at
52
minutes
past
the
hour,
so
eight
minutes
till
so
this
you
know
when
the
holds
Q
gets
rebuilt.
Let's
rebuild
this
will
update.
D
A
B
I
have
this
other
report
that
we
run
at
some,
especially
at
our
bigger
libraries
called
priority
holds
queue,
and
so,
if
I
click
on
this
big
button,
that's
actually
what
it
does
is.
It
runs.
The
priority
holds
report
for
the
library
that
you're
logged
in
at
So.
Currently,
these
are
the
30
items
that
are
on
hold,
and
this
report
will
designate
something
as
highest.
Priority
is
something
that
is
on
hold
to
be
picked
up
at
that
Library.
B
D
B
B
B
B
B
This
is
the
report
that
generates
the
button
and
what
I
did
is,
instead
of
using
a
whole
bunch
of
jQuery,
to
create
the
button
and
then
use
the
the
report
to
populate
it.
I
actually
use
the
concatenation
features
in
the
report
to
make
the
report
create
the
button.
So,
when
I'm
grabbing
the
data
from
the
Json
report,
the
Json
report
has
got
all
of
the
HTML
in
it
to
actually
create
the
button.
Okay,
that
way
it's
just
less
stuff
in
the
in
the
jQuery
and
then.
B
D
B
So
it's
actually
pretty
simple
and
what
it's
doing
but
I
think
you
know
we
just
turned
this
on
last
week
and
so
far
people
are
liking.
It
because
you
know
you
know
how
you
know
exactly
how
many
holds
your
you
have
in
your
pulse
queue
without
having
to
go
run.
It
it'll
tell
you
there
on
the
home
page
and
then,
instead
of
having
to
go
to
the
circulation
page
and
click
on
another
link
to
run
the
report,
you
just
click
on
that
button
and
it's
right
there
and.
B
A
little
it's
the
exact
same
data,
it's
just
in
a
different
order.
It's
just
saying
it's
at
the
top
of
the
page
or
the
things
that
are
highest
priority
and
then
underneath
those
are
the
high
priority
and
then
underneath
those
of
the
other
things
currently
right
now
at
baser
they've
only
got
30
items
on
their
holds
Cube,
but
this
morning
they
had
over
a
hundred
because
they
they've
already.
B
You
know
it's
11
o'clock
here
so
they've
already
gone
in
and
done
their
holds
queue
for
the
day,
but
some
of
the
bigger
libraries
it's
not
uncommon
to
regularly
have
over
100
items
in
their
holds
Q
just
kind
of
depending
on
the
workflow
and
which
Library
it
is.
You
know
some
of
our
libraries
if
they
had
100
things
on
the
holds
queue.
That's
like
10
of
the
library
practically
so,
but
you
know
baser
and
Leavenworth
are
bigger
libraries.
B
C
C
C
So
at
this
library
that
I'm
logged
in
at
they
have
three
bolts
on
the
hold
cue.
If
I
switch
over
to
a
library,
that's
got
more
than
20
holds.
It
turns
red
if
they
don't
have
any
holds,
there's
a
zero.
The
the
glow
is
controlled
by
the
age
of
the
oldest
hold
on
the
Queue.
So
if
the
the
hold
is
oh,
if
there's
a
hold
on
the
cue
that's
over
a
week
old,
then
it
starts
glowing
because
I'm.
This
is
like
passive,
aggressive
pestering
with
my
Michael.
C
D
C
One
other
thing
that
I
did
the
the
just
to
add
to
the
convenience
factor
is
like
when
you
clicked
on
this.
Usually
you
have
to
run
it
again.
So,
like
you
click
it,
and
then
you
have
to
pick
your
filters
and
click.
It
again,
I
just
swapped
the
link
out
so
that
it
runs
it
directly,
because
my
libraries
are
never
filtering
things
anyways.
So
I
want
to
go
to
you.
B
C
C
The
link
and
go
directly
to
the
queue-
that's
one
left
click,
so
what
I
was
trying
to
do
is
reduce
clicks.
The
discussion
that
came
up
during
the
users
group
was
the
some
libraries
got
out
of
the
habit
of
running
the
queue
because
they
don't
have
things
on
there.
Very
often
my
smallest
libraries
often
don't
have
things
on
their
queue.
C
So
if
there's
a
zero
there,
then
they
know
they
don't
have
to
run
it.
But
if
there's
a
number
there,
then
they
run
it.
So
it's
supposed
to
improve
workflows
as
well,
once
you
get
over
to
the
queue
I've
added
these
again,
trying
to
be
passively
aggressive,
obnoxious,
these
little
emojis
that
shake
and
rattle
the
and
there's
three
different
ones.
So
if
it's
over
a
week
it
gets
an
alarm
clock
and
it's
yellow
it's
over
a
month.
C
A
C
C
B
C
So
we've
talked
about
confetti
a
lot
lately
and
it's
like
it
gives
you
dopamine
I,
think
like,
and
we
found
this
chrome
add-on
as
well.
If
you
it's
just
bad
I'm
becoming
desensitized
to
confetti,
though
but
yeah
once
they
know
it's
here,
they
can
just
sit
here
and
refresh
the
page
and
yeah
so
yeah.
How
did
I
do
that?
There's
a
few
different
pieces
to
this.
The
first
is
the
CSS
so
and
I
I'm
lazy,
so
I
I
did
one
CSS
class
that
does
the
sort
of
striping
the
striping.
C
In
the
background
there
and
I
already
had
that
in
there
I
was
just
I
was
using
it
for
something
else,
a
piggybacked
off
of
that
and
then
for
and
that's
the
same
class.
That's
here
so
I'm
using
the
same
glow,
same
class,
same
everything
and
then
for
the
orange
and
the
yellow
I
just
added
some
Hue
filters
to
separate
classes,
so
I
didn't
have
to
rewrite
all
of
this.
I
I
just
changed
the
Hue
so
that
when,
when
you
apply
this
class
in
conjunction
with
this
class,
you.
C
C
Maybe
not
oh
yeah
I,
don't
remember
how
I
did
that
it's
I've
slept
since
then,
but
I'll
show
you
down
below
where
we're
using
the
classes,
but
this
is
what's
causing
the
glow.
This
is
what's
causing
the
shake
on
the
emoticons
and
I
got
oh
right
right.
So
the
class
is
up
here
and
we're
calling
belowing
to
you,
which
is
the
animation.
So
the
animation
is
here
the
classes
here
calling
the
animation
there.
C
C
Yeah,
so
this
is
what
makes
it
move
and
then
this
is
what
I'm
applying
to
the
div
to
to
call
the
animation,
okay,
nice
and
then
down
in
the
jQuery
I.
Think
that
that's
it
I
think
this
is
where
that
ends
first,
for
what
I
did.
This
is
a
different
again
stripy
background
that
I'm
using
for
something
else.
C
D
A
C
It's
good
user
experience,
feedback
type
of
thing
the
and
then
here
I'm
pulling
the
count
from
a
report
just
like
George,
was
doing
I'm
handling
everything
outside
of
the
report.
So
this
is
what
the
report
looks
like
it's
very
basic,
so
I'm
getting
the
total,
that's
the
number
that
goes
in
the
badge
and
then
I'm
pulling
the
oldest
hold
on
the
Queue
there
as
well,
which
is
what's
calculating
whether
it
needs
a
flash
or
not.
C
So
the
count
is
just
the
total
of
temporary
holds
on
whatever
Branch
you're
logged
in
at
and
then
the
oldest
hold
is
calculated
here
with
the
mat
that
took
me
way
too
long
to
figure
out
because
they
always
take
me
too
long
to
figure
out.
But
basically
it's
it's
saying
that
the
oldest
hold
on
the
cue
for
Iola
is
322
days
and
everything's
old
in
my
my
test
server.
So
right
don't
be
alarmed
by
that
and
then
again
we're
just
we're
pulling
out
information
into
a
span.
C
C
More
fun
date
calculations,
so
this
took
way
too
long
as
well.
So
this
is
for
these
things
these
badges
here,
but
we're
looking
at
the
date
the
whole
Q
day.
So
we're
pulling
the
state
here
and
then
I
also
needed
to
calculate
eight
days
ago,
because
I
was
I
was
wanting
things
that
were
more
than
seven.
C
So
that's
the
alarm
clock
date:
22
is
my
8
plus
22
30
357
Plus
8
is
365,
so
this
is
my
month
and
my
year
you
can
see
that
I've
just
put
the
Emojis
right
in
there,
which
is
really
simple.
I
learned
this
on
the
slack
Channel.
Actually,
if
you
hold
the
Windows
key
and
press
period,
you
get
your
emoji
keyboard
and
you
can
just
pick
whatever
you
want
didn't
even
know
that
I
know
it's
so
cool
and
then
I'm,
adding
the
the
failed
class.
C
So
the
sale
class
is
what
what
makes
it
glow
or
something.
I.
Don't
know
it's
a
lot
of
moving
Parts
here,
but
basically
it's
it's
saying
that
if,
if
you
subtract
the
whole
student
from
eight
eight
days
old,
if
that
difference
is
in
these
ranges
that
I
calculated,
then
it's
applying
the
different
classes
and
it's
appending
the
different
divs
so
that
we
get
those
annoying
placards.
B
C
C
C
C
Then
it's
triggering
the
confetti
and
you
can
customize
the
confetti
quite
a
bit.
You
can
customize
the
size.
How
much
shows
up
I
did
find
that
if
you
do
too
much
confetti
it
really
like
bogs
down
the
browser
and
like
lags
really
bad
so
like
a
100
was
pretty
good
and
again
you
can
use
that
emoji
keyboard
to
insert
different
things
into
that.
So
I
did
some
sharks
and
fishes
Pizza.
You
know
stuff
that
felt
rewarding
things
that
people
care
about.
A
A
D
A
Well,
that
is,
that
is
awesome.
I
I
love.
How
flashy
things
are
you
really
Dressed
things
up?
That's
that's
very
cool.
Both
of
your
modifications
are
awesome.
You
know
I
like
George's,
because
it
puts
it
right
there
on
the
the
front
page
and
yours,
you
give
incentives
and
you
you
bring
attention
to
certain
things.
Basically,.
A
B
You
know
there's
a
lot
of
room
for
modification
like
you
know
the
one
that
I
did.
Instead
of
linking
to
that
priority
holds
report,
it
could
just
as
easily
link
to
the
built-in
bolts
queue
it
could
link
to
anything.
You
wanted
yeah
so
and
there's
probably
a
way
if
I
sat
down
and
worked
on
some
more
I
could
probably
add.
B
C
A
Well,
that's
great!
Thank
you.
Jason
I
appreciate
you
sharing
that
and
I
want
to
thank
you
again
for
for
joining
us
today
on
this
episode
and
before
we
sign
off
I
just
want
to
remind
everyone
again
to
make
sure
that
you
go
to
our
YouTube
page
and
make
sure
that
you
subscribe
so
you're
notified
when
we
post
new
videos
and
also
to
like
and
comment
where
you
can.
We
want
to
hear
back
from
you
so
until
next
time.
Thank
you
and
we'll
see
you
again
in
two
weeks
see
you
later.