►
From YouTube: TTEOT Training Video - S1E5 - SQL: Links in Reports
Description
Excite your noodle on this fantastic episode, where George adds links to reports (Not the Jimmy Dean kind).
Referenced code: https://wiki.koha-community.org/wiki/SQL_Reports_Library
Music: https://www.bensound.com
A
A
Yeah,
I
use
these
a
lot
in
a
lot
of
reports
like
we
have
a
report
for
weeding
that
I
just
call
shelf
list
that
allows
you
to
on
one
side
of
the
of
the
output.
There's
a
link
that'll,
take
you
to
the
bibliographic
record
and
on
the
right
side
of
the
screen.
There's
a
link
that'll.
Take
you
to
edit
that
individual
item
data
and
I've
got
a
lot
of
reports
that
link
to
different
pages
in
coho.
A
B
A
So
all
these
different
links
can
take
you
all
over
the
place
and
there's
link
for
links
for
patrons
for
bibs,
for
baskets
in
the
acquisitions
module
all
kinds
of
stuff
all
over
the
place
so
great.
So
what
I've
got
here
is
a
really
simple
report
that
I
honestly
don't
remember
why
I
created
this
report.
I
have
no
idea
what
the
purpose
of
it
was,
but
if
I
run
this
report,
I'm
gonna
pop
it
open
in
a
new
window.
A
This
is
a
report
that
has
links
in
it
this
if
I
go
to
the
list
module
and
get
the
number
id
number
from
a
list.
If
I
put
that
list
id
number
in
there
and
run
this
report,
it's
just
going
to
give
me
the
author
of
the
title
in
a
list
and
the
title
of
the
item
in
the
list
and
the
title
over
here
is
a
link,
and
so
this
is
a
very
cheerful
looking
list
about
the
holocaust,
all
titles
about
the
holocaust.
A
So
if
we
click
on
this
link,
gilbert
or
martin
gilbert
the
holocaust,
if
I
click
on
this
link,
it'll
take
us
right
to
that
to
the
bibliographic
record.
For
that
title
there
you
go
now
the
way
that
you
create
those.
If
I
go
in
here
and
edit
the
link,
this
is
all
the
data.
This
is,
you
know
the
information
straight
from
the
co-op
wiki,
but
what
you're
going
to
do
in
these
is
you're
doing
something
in
sql
called
a
concatenation,
and
so
what
the
concat
command
does
is.
A
Yeah,
so
if
I
click
on
any
of
those
results,
it
pops
the
result
open
in
the
new
window,
which
is
really
convenient
and
then
over
here,
I'm
adding
in
the
title
and
then
I'm
finishing
the
html
anchor
command
with
that
final
a
and
then
this
parentheses
over
here
corresponds
with
this
one
over
here.
So
it's
the
concatenating.
B
B
One
other
thing
I
wanted
to
I'd
like
to
point
out
here
is
when
you're
doing
the
link,
especially
linking
to
something
on
the
website.
It's
a
good
idea
to
not
include
the
domain
in
the
link,
because
things
change
over
time.
You
may
rename
your
domain
at
some
point
and
doing
so.
It
locks
this
report
into
that
particular
domain,
whereas
if
you,
if
you
omit
the
domain
in
the
link,
it
will
default
to
the
site
that
you're
on
yeah.
A
Normally,
let
me
just
put
this
up
here
in
the
notes.
The
the
full
length,
the
full
length
link
is
http,
slash,
staff
next
kansas.org,
but
cohort
knows
when
you
run
it.
If
you
just
do
everything
after
the
cgi,
it
knows
that
it's
gonna,
it's
gonna,
go
to
that
link
on
the
server
that
you're
starting
from
so
you
don't
have
to
include
unless
you,
unless
you've
got
a
link,
that's
going
somewhere
outside
of
cohab.
B
All
right,
so
you
know
this.
This
is
great.
You
can
link
to
lots
of
information
from
within
the
report.
Now
I
want
to
ask
you
what
does
this
look
like,
for
example,
if
I
wanted
to
export
this
into
an
excel
file
and
massage
the
data
a
little
bit,
what
what
ends
up
happening
there?
Well,
let's
look
at
that.
Okay,.
A
A
A
A
B
A
A
A
B
B
A
Yeah
there
are
a
couple
of
cases
where
I
learn
quite
a
few
cases
where
I
leave
the
links
alone,
because
I've
got
the
whole
report
style
to
be
read
on
the
page
yeah,
as
opposed
to
being
read
as
opposed
to
being
downloaded
so
cool,
but
like
with
anything
with
coho.
If
you
can,
you
know
with
the
reports
pretty
much
anything
you
can
do
in
html
you
can
you
can
do
that
awesome.