►
Description
A day late but not short on content. Today George dazzles us with a clever way to limit parameters in SQL reports AND bib frameworks using Authorized Values. You are authorized to use this in whatever way it works best for you. Really. You don't need our permission. Unless you want it. Then yes, we permit you to do this.
Referenced code: https://wiki.koha-community.org/wiki/SQL_Reports_Library#Runtime_Parameters
Music: https://www.bensound.com
A
A
And
so
that's
what
we're
going
to
talk
about
today,
because
I
do
that
all
the
time
and
it's
pretty
simple
and
we've
actually
already
talked
about
it.
So
briefly,
so
if
you
go
to
our
website
for
koha
us
visit
kohaiu
at
coho
dash
us.org
and
if
you
click
on
learn,
you
get
this
list
of
educational
resources
and
all
of
the
videos
are
under
watch
quahog
us
original
training
videos
and
if
you
scroll
down
to
episode
number
seven
like
versus
equal,
we
touched
on
this
topic
in
that
episode
back.
A
A
And
that
can
be
found
on
the
cohort
wiki
under
tips
in
section
1.2.7,
runtime
parameters,
there's
instructions
there
for
how
to
use
the
different
authorized
values
categories
plus.
You
can
also
use
branches,
item
types
and
date
and
category
code,
including,
and
then
any
authorized
value
category
that
you've
got
in
coho.
A
A
A
So
I
thought
I
would
just
walk
through
this
really
quickly.
Again,
you
know
here's
a
basic
report:
it's
a
home
branch,
an
account
of
item
numbers
each
at
each
branch,
and
if
we
look
at
that
report,
I
mean
that's
all
there
is
there's
nothing
there.
It's
just
select
items
home
branch
and
count
items,
item
number
from
items,
and
so
there's
no
variables
there
at
all
and
the
when
you're
learning.
B
B
B
A
If
you've
only
got
one
library,
then
then
you
don't
even
need
to
you,
don't
even
need
to
put
a
limiter
in
there
at
all.
For
my
situation,
where
we've
got,
you
know,
50
plus
libraries,
the
next
thing
that
you
kind
of
learn
how
to
do
when
you're
writing
reports
is,
you
can
just
enter
a
value.
We
could
say
you,
but
then
you
have
to
type
it
in
each
time,
which
means
you
have
to
spell
everything
correctly.
A
But
the
way
you
do
that
is
you
do
the
items
home
branch
and
here
you
can
use
a
like
or
an
equals,
and
you
do.
The
double
angle
brackets
enter
a
value
and
when
you
run
that
that's
what
gives
you
this
place
where
it
says,
enter
a
value,
but
you
know
the
reason
that
I
don't
write.
Those
kinds
of
reports
for
staff
here
is
that
they're
they're
going
to
say
it
doesn't
work
right.
A
B
And
that's
a
good
example
of
you
know.
If,
if
the
system
doesn't
do
something
you
want
ask
for
it,
because
that
was
something
that
I
did
ask
for.
I
said
we
need
a
way
to
be
able
to
select
everything
in
the
list,
not
just
one
thing
or
so.
You
know
that
that's
a
step
in
the
right
direction.
There
you
can't
you
can
use
this
select
certain
ones
from
that
list,
but
you
can
select
all
now
yeah.
A
I
said:
hey
if
it's,
if
all
is
always
there,
I've
got
some
reports
that
are
going
to
time
out
and
they're
going
to
crash,
because
somebody's
going
to
accidentally
select
all
and
there's
going
to
be
so
much
data
there
that
the
report's
going
to
crash-
and
there
is
never
going
to
be
a
result.
So
is
there
a
way
you
can
make
all
optional
and
so
he's
added
the
he
made
it
optional.
You
have
to
add
the
colon
all
in
order
for
it
to
work.
A
A
So
if
we
were
to
just
run
this
report
for
them-
and
they
wanted
to
get
data
for
all
four
of
their
libraries,
just
their
four
libraries,
they
would
have
to
run
a
report.
They
would
have
to
run
this
for
elwood
then
run
it
for
highland
and
run
it
for
troy
or
run
for
and
then
run
it
for
wathena
or
they
could
run
it
for
all
and
then
just
chop
out
the
data
that
they
don't
want.
A
I
don't
know
why
I
chose
l,
but
I
put
an
l
in
front
of
any
authorized
values
categories
I
create
just
to
keep
them
all
in
one
place
in
the
authorized
values
table.
I
think
at
the
time
I
was
thinking.
L
nothing
begins
with
l
in
the
authorized
values
and,
of
course,
there's
like
10
things.
That
begin
with
l.
A
A
A
Yeah,
I
can,
I
can't
recreate
it
because
there's
one
that
already
exists,
but
that's
all
I
had
to
do
was
I
had
to
go
in
and
I
created
one
separate
entry
for
each
library,
so
I've
got
the
authorized.
Value
is
the
branch
code,
but
then
at
the
top
I've
got
the
authorized
value
for
all.
Libraries
is
a
wild
card
and
then,
if
we
go
down
here
to
doniphan
county,
all
four
of
those
branch
codes
start
with
don.
I
so
I've
got
donovan
county
all
is
d-o-n-I
wild
card
and
for
prairie
hills.
A
A
A
B
A
The
places
where
there's
a
difference
between
my
lloc
table
and
my
loc
table
right.
So
that's
you
know
how
you
can
use
these
in
reports
and
creating
them,
like
I
said,
is
really
easy.
You
just
gotta
go
to
authorized
values,
create
a
new
category
which,
to
do
that,
all
you
have
to
do.
Is
click
on
create
a
new
category.
A
A
B
B
A
B
A
A
A
A
That's
that's
just
one
example,
but
this
happened
all
the
time
where
people
would
you
know
go
in
and
even
though
they
were
told
and
trained
to
not
do
this.
They
would
still
manage
to
attach
physical
copies
to
hoopla
records.
So
what
I
did
is
I
started
out
by
creating
some
values
that
these
are
a
match.
This
one
is
called
framework
hoopla,
952
8,
and
it's
just
my
list
of
item
types
that
we
use
only
for
hoopla
items.
A
A
A
A
A
A
A
I
have
one
of
these
set
up
so
that
you
know
most
of
those
shelving
locations
like
I
said
adult
children
and
young
adults
are
the
primary
ones
we
use.
Everything
else
is
a
temporary
shelving
location
so
to
keep
people
from
putting
temporary
shelving
locations
at
the
bibliographic
level.
I
have
a
list.
I
have
a
an
authorized
value
list
that
just
has
adult
children
and
young
adult
in
there
so
that
nobody
can
accidentally
put
the
wrong
shelving
location
at
the
bib
level
on
an
item
on
a
title,
and
the
same
is
true
for
collection
code.
A
I've
got
that
same
list
of
collection
codes
that
are
only
available
in
this
frame
that
are,
that
should
only
be
used
for
this
framework.
They're
part
of
the
they're
just
part
of
the
of
the
way
that
the
bible
graphic
record
is
built
from
the
framework,
and
the
same
is
true.
If
we
go
back
to
this
framework
and
look
at
the
952.
A
Then
the
c,
which
is
the
shelving
location,
gets
its
gets
its
data
from
drop
down
from
another
place
and
the
y
and
the
eight
get
them
from
those
different
values
that
I've
set
up.
So
nobody
can
accidentally
add
an
item.
This
is
this
is
what
happened
after
I
started
using
this
people
would
call
me
and
then
say,
I'm
trying
to
add
an
item
and
my
only
choice
for
a
home
library
is
digital
content.
A
Why?
Why
is
this
broken
and
I
would
have
to
say
to
them:
it's
not
broken.
You
shouldn't
be
adding
an
item
to
that
record,
and
so
here
you
know
in
the
in
the
item
level,
we
can
pick
any
of
those
temporary.
We
can
pick
those
main
three
or
any
of
the
temporary
ones,
because
I'm
not
modifying
the
shelving
location
but
the
home
library,
the
item
type
and
the
collection
code
are
just
limited
to
those
few
choices
that
I
want
them
to
be
limited
to
just
for
this
framework.
So
I'm.
A
It's
less
important
now
because
we're
not
using
this
framework
anymore,
we're
not
adding
the
hoopla
records.
If
we
go
forward
and
move
to
use
the
cloud
library
plugin,
then
I'll
probably
have
to
start,
but
I
probably
could
it
wouldn't
be
that
hard
so,
but
that's
just
another
way
to
use
the
authorized
values.
There's
a
ton
of
things
that
you
can
do
with
the
authorized
values.
There's
probably
other
ways
that
that
you
can
use
them
that
I
just
haven't
thought
of
yet.
A
Yeah
we
use
them
for
patron
attributes,
we
use
them,
for
we
use
them
in
a
ton
of
different
places,
and
so
there's
just
a
ton
of
different
ways.
You
can
use
them
and
those
are
the
two
that
you
know
when
I
saw
the
comment
from
james
mitchell,
I
figured
we
hadn't
done
a
really
in-depth
video
about
using
authorized
values.
So
I
thought
it
would
be
something
good
to
talk
about
so.
B
A
B
I
really
like
that,
and
I
just
wanted
to
to
point
out,
while
you're
on
this
page,
I
had
revamped
the
the
video
list
a
little
bit
we're
putting
highlighting
the
the
most
current
video
up
at
the
top,
the
latest
episode
and
then
the
rest.
I
did
in
reverse
order
because
you
know
usually
it
would
start
from
the
beginning
and
go,
and
you
have
to
scroll
all
the
way
down
this
way
you
don't
have
to
do
as
much
scrolling
if
you're,
just
keeping
up
with
with
our
videos.
B
A
B
A
B
Exactly
yeah,
I
noticed
the
other
day
too.
The
I
think
I
don't
know.
I
think
it's
just
the
koha
newsletter
that
goes
out.
They
mentioned
our
hoopla
and
cloud
library,
plug-in
videos
that
we've
we've
done
recently
so
cool.
Thank
you
for
for
including
us
in
your
your
newsletter
and
just
a
reminder
to
everybody.
We
love
feedback
and
questions.
If
you
have
questions
or
things
that
you
would
like
to
see
in
in
upcoming
videos,
please
let
george
or
I
know
or
please
make
comments
on
the
videos.