►
From YouTube: System Administration Special Interest Group - 11/9/21
Description
Chat logs -
00:09:52 Lisette Scheer: https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix
00:40:36 Lisette Scheer: SELECT tobranch AS "Send item to", items.location, items.itemcallnumber, biblio.title,barcode,homebranch, holdingbranch, daterequested, stockrotationrotas.title AS "Stock rotation rota",branchcode_id AS "Stock rotation stage", items.datelastseenFROM branchtransfersJOIN items USING (itemnumber)JOIN biblio USING (biblionumber)LEFT JOIN stockrotationitems ON items.itemnumber=itemnumber_idLEFT JOIN stockrotationstages USING (stage_id)LEFT JOIN stockrotationrotas USING (rota_id)LEFT JOIN reserves ON items.itemnumber=reserves.itemnumberWHERE datearrived IS NULL AND frombranch=BRANCHCODE AND ((branchtransfers.reason="StockrotationRepatriation") OR (branchtransfers.reason="StockrotationAdvance")) AND items.onloan IS NULL and items.itemlost='0' and items.damaged ='0' AND datesent IS NULL AND reserves.waitingdate IS NULL AND holdingbranch=BRANCHCODE AND homebranch != holdingbranchGROUP BY items.barcodeORDER BY items.itemcallnumber
A
D
B
D
B
B
I'm
still
working
on
updating
making
like
a
dashboard
like
christopher,
showed
off
last
month
that
works
for
us,
but
we're
still-
or
I
guess
two
months
ago
now
at
the
conference
in
september,
we're
still
trying
to
launch
our
new
website
so
hopefully
next
week,
maybe
we're
getting
pretty
close,
and
so
I
haven't
been
doing
like
as
much
coho
stuff
because
we're
trying
to
get
that
launched
sooner
rather
than
later
and
there's
just
been
a
lot
to
get
done.
So
I
haven't
been
doing
much
reports
wise.
B
E
C
The
auto
increment
function
of
the
control
number
has
been
working
very
well
for
me
until
I
some
something
went
terribly
wrong
and
a
huge
number
got
put
into
that
field,
and
now
I've
got.
I
mean
it's
still
working,
but
I've
got
a
gap
of
couple
of
orders
of
magnitude
and
the
numbering
sequence,
which
I
would
rather
not
have
I'm
trying
to
find
out
where
that
number
is
stored
and
how
to
how
to
change
it
to
a
smaller
number.
B
B
B
D
B
D
B
D
B
B
C
C
C
I
I
haven't
been
successfully
using
that
I
have
implemented
the
this
auto
increment
fix,
that's
an
inter.
That
was
something
that
happened
you
know
years
ago,
and
it
it
resolved
that
problem
for
me,
which
I
was.
I
wasn't
even
seeing
that
problem,
but
it's
that's,
that's
long
gone
and
I'm
only
an
old
stable,
but
that's
that
was
rolled
into
that
will
be
well
before
2105
2011.
C
C
E
F
D
B
A
C
B
C
B
E
B
C
C
B
D
E
C
E
C
E
C
B
Yeah-
and
that
is
totally
the
kind
of
question
for
the
systems
group,
because
the
other
thing
is
that,
if
especially,
if
we
don't
have
stuff
to
talk
about
in
particular,
which
usually
is
mostly
around
like
the
updates
or
if
someone
has
like
something
they're
working
on
that,
they
ask
for
help
with
a
lot
of
times.
We'll
just
sit
here
and
work
on
like.
If
someone
has
a
report,
question
we'll
just
troubleshoot
the
report
question
or
whatever.
C
B
C
C
D
D
C
B
That'll
be
a
great
resource
when
that
launches.
That's
not
a
video!
Actually,
I
have
a
here.
Let
me
turn
off
my
video
for
a
second.
I
have
a
thing
that
I've
had
that
someone
sent
me
when
I
I
mean
this
is
a
super
basic
thing,
but
I
always
like
showing
it
off
to
people
when
I
feel
like
I
have
an
opportunity
to
it's
just
pinned
up
on
my
wall
and
has
been
for
like
five
years.
B
My
phone's
not
off
okay,
it's
got
like
select
coffee
types
and
creamer
types,
and
it's
like
explaining
how
to
write
reports
really,
basically
based
on
different
coffee
orders,
which,
like
it's
super
basic,
but
I
think
it's
a
lot
of
fun,
so
I
always
like
showing
that
out.
Someone
sent
it
to
me
just
like
for
fun,
not
very
long
after
I
started
doing
cohort
reports
and
it's
just
always
fun.
It's
up
alright!
B
B
Let's
see
any
oh
okay,
actually
I
do
have
something:
that's
exciting.
That's
a
bug
that
got
fixed
that.
I
think
we
might
be
the
only
people
in
the
us
using
this
feature,
but
it
works
a
lot
better
now,
so
I'm
hoping,
maybe
more
people
will
use
it,
which
is
the
stock
rotation
feature
to
automatically
move
items
between
branches,
we're
part
of
a
district.
That's
within
a
larger
consortium.
B
And
now
what
we're
doing
is
we're
setting
up
new
they're
called
brodas
when
they
go
out
or
when
they
come
in
actually
before
they
go
upstairs
to
the
new
bookshelves,
and
so
now,
after
the
update,
they
are
requested
for
transit.
They
used
to
get
automatically
put
into
transit,
which
was
annoying
because
you
never
knew
if
it
had
actually
been
seen
or
put
in
transit
until
it
got
checked
in
at
the
home
branch.
B
It's
an
exciting
feature,
that's
actually
functional
for
how
we
use
it
now
in
theory,
so
that
part
only
got
patched.
The
second
part
where
it
wouldn't
put
things
into
transit
like
a
week
ago,
so
we're
still
like
making
sure
that
it's
actually
all
working
as
it's
supposed
to,
but
last
week,
it'll
look
good!
So
if
anyone
is
watching
this
and
is
like
how
do
you
even
get
started
doing
something
like
that?
B
Please
feel
free
to
reach
out
on
the
list
or
to
me
directly,
my
email's
all
over
the
place,
but
it's
lizette
s,
leita,
library.org
and
so
yeah,
because
last,
at
least
as
far
as
supported
customers
from
bywater
go
were
the
only
people
using
it.
But
even
when
I've
talked
to
people
on
the
list
or
irc
about
it,
it
sounds
like
we're
using
it
and
then
some
libraries
in
europe
who
are
kind
of
who,
like
their
support
company,
did
all
the
work
on
it.
Probably
for
them.
B
D
B
B
D
B
D
Right
now,
it's
all
happening
outside
of
the
system
like
we've
got
the
books
cataloged
in
koha
and
people
can
check
them
out
within
the
system,
but
I
think
it
makes
the
full
rotation.
Then
it
comes
back
to
here
and
we
check
it
in
to
reset
the
location
back
to
here,
and
then
it
goes
out
again.
So
it's
not
at
all
tracked
or
thorough,
and
we
can't
we
don't
have
like
holds
on
those
because
we
don't
know
where
they're
at
at
any
given
time.
D
Yeah
that
could
work.
It
still
seems
like
more
work
with
less
value
added.
I
think
the
only
added
value,
like
the
only
reason
we
might
want
to
consider
doing
it,
is
to
allow
those
holds
because
if
we
can
keep
track
of
where
they're
at
then
we
could
potentially
have
the
libraries
pull
them
off
off
the
shelf
and
hold
with
them.
But
at
this
point
they're,
it's
just
kind
of
a
static
sitting
in
the
library
browsing
collection.
B
D
B
We
only
our
new
new
book
stuff
is
only
about
up
to
about
50
books
a
month
for
everybody,
except
our
main
branch,
which
has
the
most
people,
and
they
just
run
the
report
twice
a
week
and
pull
it
well
at
least
twice
a
week
and
pull
them
and
check
them
checkman
and
our
for
our
courier.
Before
he
comes.
B
B
D
D
B
Which
also
it's
kind
of
annoying,
though
it
has
everything,
that's
currently
checked
out,
which
isn't
usually
helpful
if
you're
just
trying
to
pull
stuff
and
it
shows
stuff
that
has
a
lost
or
damaged
status,
and
I
have
some
jquery
to
hide
the
checked
out
stuff.
But
we
ended
up
just
use
editing
the
report
that
we
had
been
using
already
because
also
it
it
had
a
little
more
information
than
the
other
report
did.
B
B
D
B
So
what
else
did
we
do?
I
think
we
did
some
other
stuff
different,
oh
yeah,
and
we
told
it
not
to
have
holds
weighed,
in
which
I
think
the
report
also
had
items
that
were
holds
weighed
in
and
yeah
just
anything,
that's
in
a
in
a
stock
rotation
and
trying
to
transfer
four
either
advancing
or
to
go
home,
because
that's
if
it's
like
checked
out
when
it
advances
instead
of
just
saying
like
oh,
this
is
advancing.
B
B
Yeah
this
is
different
than
it
was
before,
but
because
we
were
doing
hiding
before
my
report
was
hiding
anything
that
was
last
seen
on
or
after
the
day
it
was
requested,
because
that
way
we
figured
it
would,
in
theory,
be
put
into
transit.
This
was
before
things
were
actually
getting
put
into
transit
or
when
they
were
just
automatically
getting
put
into
transit.
B
D
I
I
have
been
working
on
my
mega
menu
to
make
it
more
accessible,
so
part
of
the
reason
I've
it's
taking
me
so
long
to
update
my
opec
stuff.
It's
because
I've
been
adding
in
all
this
stuff
that
I
wanted.
I've
wanted
to
do
for
a
while,
and
one
of
those
things
was
trying
to
make
the
makeup
menu
more
friendly
for
people
with
visual
impairments
and
that
sort
of
thing.
So
I
can
show
that
off.
If
we
want
sure
we.
E
D
I
think
the
right
one,
so
I
so
before
I
can
bring
up
the
current
one,
because
we
have
an
upgrade
right
now:
the
menu
just
kind
of
flips
in
and
out
which
isn't
very
user
friendly,
especially
for
mouse
users,
because
if
you're
not
steady
with
your
mouse,
then
it
makes
it
really
hard
to
follow.
So
I
added
a
little
delay
on
on
the
hover,
which
leaves
it
up
for
a
second
and
then
same
thing
for
those
panels.
D
So
I
mean
it
is
tappable,
but
it's
in
there
right
now
it
doesn't
open
when
you
tap
to
it,
because
you
know
I
wrote
this
a
long
time
ago
and
I
didn't
know
what
it
was
doing.
So
I
fixed
that
so
on
the
current
site.
Now,
if
you
tab
to
it,
it
opens
the
menus
and
your
focus
follows
along
with
the
little
box.
D
I
do
still
have
problems
with
these
dumb
library,
aware
widgets,
because
every
one
of
those
books
is
a
link,
so
you
have
to
kind
of
tab
through
those
to
get
past
them.
I
tried
to
put
a
no
tab
on
them
and
that
didn't
work
so
for
now
they're
just
kind
of
there,
but
I
think
it's
still
an
improvement
over
how
how
it
was
functioning
before
yeah.
D
D
Oh
yeah,
so
we
were
talking
about
trying
to
use
comments
more
as
a
review
type
thing
so
I've.
So
these
links
are
usually
underneath
here
and
I
got
rid
of
those
and
that's
how
we've
had
it
and
moved
those
up
to
the
explore
menu,
but
we
we
were
talking
about
trying
to
like
maybe
do
some
more
local
vocabulary,
crowdsourcing
type
things
so
bringing
that
stuff
to
the
front
page
as
well,
for
the
reviews
I'm
I'm
wanting
to
it
does
have
star
ratings,
but
some
of
these
people
don't
star
them.
D
D
So
we
could
have
a
more
useful
tag
cloud
on
the
front
page
also
with
the
idea
that
the
patrons
would
actually
see
that
and
start
using
it,
because
right
now,
they're
not,
but
if,
if
we
can
make
it
visible
and
make
it
appealing,
maybe
we
can
start
getting
more
of
our
patrons
to
dump
things
into
that.
And
then
here
we
talked
about
curated
lists.
So
right
now
it's
just
you
hoopla,
but
the
lists
are
kind
of
awful
for
the
opec
because
you
can't
search
them.
D
B
B
B
D
A
B
D
E
B
Cool
it
can,
I
think,
that's
one
thing,
that's
hard
about
not
having
as
much
in-person
conferencing
because,
like
christopher
and
george,
and
you
definitely
convinced
me
when
we
were
in
portland
to
run
for
vice
president
and
that
would
not
have
gone
nearly
as
well.
If
we
hadn't
been
in
person-
and
I
feel
like,
maybe
we
got
rhonda
to
run
while
we
were
in
pueblo,
I
think
we
kind
of
talked
her
into
it.