►
Description
Open this report. Now open that one. Now fill in all the same info again. Now use some of the info from the last report and use it in this one. (Silent screams go through my head.) Oh, wait! I can tell this report to run another report!!!! And it can fill in all the parameters for me! (Glorious cheering now takes the place of the screams in my head.) Great! Gives me time for some coffee. Oh, wait. The coffee maker is broken. (Resume screaming.)
Contents:
0:00 - Title
0:32 - Intro
1:49 - The Previous Videos
5:44 - The Example
9:14 - How it Works
12:55 - The Notes
13:57 - Wrap Up
Referenced code:
https://hopperdietzel.org/koha_notes/sqldrilldown
Music: https://www.bensound.com
B
B
A
B
Yeah
the
thing
that
I
like
about
it
is
you
know
particularly
for
that
dashboard
report.
Is
you
know
the
whole
idea
was.
I
wanted
a
way
to
just
scan
a
barcode
and
have
information,
make
it
really
easy
to
find
out
information
about
that
item
and
because,
before
I
used
to
have
a
lot
of
the
questions
that
I
use,
that
dashboard
report
to
answer
questions
about
is:
is
it
in
transit?
You
know
how
many
times
is
it
checked
out?
B
That's
just
a
simple
item
count
by
item
type
to
run
a
report
that
goes
into
more
detail
about
what
things
are
using,
that
item
type
right
and
normally
the
quahog
community
wiki,
is
in
wiki.coha
community.org,
and
I
put
I
put
some
of
the
sequel.
I
write
some
of
the
reports
I
write
are
on
the
reports
library
there
at
the
wiki,
the
two
reports
I'm
going
to
look
at
today.
B
No,
there
was
a
different
one.
It
was
season,
one
episode,
24,
okay,
it
was
the
last
episode
of
the
first
season
right
before
we
took
that
little
break
over
the
holidays.
Okay-
and
I
specifically
talked
in
that
one
about
how
to
use
how
I
create
different
authorized
values
for
doing
different
stuff
and
I've.
Never
we've
never
talked
about
my
shelf
list
report
and
we
talked
about
it
really
really
briefly,
because
it's
full
there
isn't
a
single
there.
B
B
B
B
B
B
That's
listed,
I've
got
one
thing,
that's
listed
as
audiobook
new
and
then
this
button
over
here
runs
my
shelf
list
report
and
it
runs
it
from
a
cloud
and
it
says
show
me
all
the
things
that
have
an
item
type
that
says
audio
book,
new
okay,
and
so
I'm
using
this
button
here
to
run
this
report
over
here.
Now,
like
I
said
this
report
over
here,
has
a
mountain
of
variables
when
you
run
it.
B
B
B
Last
seen
between
these
two
dates
with
x
or
fewer
checkouts
show
me
the
checked
out
items
yes
or
no
show
me:
loss
missing
and
withdrawn
items,
yes
or
no,
with
x,
remarked
copies
of
this
library
with
x
or
more
copies
in
the
catalog.
So
it's
it's
got
a
lot
of
variables
in
there,
but
if
I
run
this
report
up
here
at
the
top
once
it
runs,
I've
got
a
url
here,
and
so
let
me
share
a
different
screen.
B
A
B
And
I've
got
the
this
is
the
part
that
runs
the
report.
It's
saying
when
I
click
on
that
button.
It's
gonna
run
guided
report.
Report
number
2731
run
this
report,
and
here
it's
got
the
parameter
name
for
the
item
home
library,
but
it's
not
putting
in
that.
That
parameter
isn't
hard
coded.
What
it's
doing
is
it's
saying
give
me
the
branch
code
that
matches
the
branch
code
for
that
line
in
the
report
right
and
then
down
here,
where
I've
got
the
parameter
for
the
item
type.
It's
saying
show
me.
B
B
So
it's
concatenating
all
those
different
parts
of
the
url
into
one
string
and
it's
filling
in
it's
filling
in
the
branch
code
based
on
what's
over
here
and
the
item
type
based
on
what's
over
here.
So
when
I
click
that
I
don't
have
to
go
to
report
number
2731
and
choose
all
of
those
different
parameters,
it's
just
filling
them
in,
as
if
I
had
already
done
all
that,
okay
and
so
that's
pretty
much
it
it's
it's
pretty
easy
to
do.
B
B
The
one
thing
I
would
say
about
the
sequel
for
the
shelf
list
is
that
you're
going
to
have
to
tinker
with
it
to
make
the
the
item
types
work
and
the
collection
codes
work,
because
they
are
using
authorized
values
that
aren't
standard,
but
but
once
you
have
a
report
that
runs
you
can
take
the
you
can
take
the
url
from
that
report
and
and
build
that
link,
because
that
link
works.
Every
time
you
go
to
that
link,
the
the
link
is
going
to
make
it's
going
to
run
the
report
the
same
way.
B
A
Yeah,
well,
that's
that's
great.
You
know!
Yeah,
I
mean
if
you
have
a
report
that
has
all
the
pieces
that
you
need
for
another
report
or
if
you
can
modify
that
report,
to
include
that
those
pieces
of
information
so
that
you
can
kind
of
drill
down
so
like
if
you
get
you
have
a
report
that
gives
you
some
generic
information,
and
you
want
to
see
more
details
about
that.
One
specific.
B
B
B
A
Well,
george,
thank
you
very
much
for
sharing
that,
and
I
hope
that
folks
will
find
that
helpful
and
handy
just
a
reminder
to
everybody.
We
we
enjoy
getting
feedback
on
our
videos
and
if
you
have
a
particular
topic
that
you
would
like
us
to
cover,
feel
free
to
comment
on
our
youtube
channel
our
website.