►
From YouTube: Batch Modify through SQL Report
Description
In this tutorial, Kelly and Jessie will show you how to batch modify items directly from an SQL report in the Reports Module
A
B
B
Ok,
today,
we're
going
in
1805
release
in
regards
to
reports
and
this
thing's,
probably
something
that
people
notice
what
we
wanted
to
give
you
just
a
quick
outline
of
how
this
works.
I
can
show
you
the
ability
to
once
you
run
a
report
in
Co
to
go
right
straight
to
that
item.
Modification.
An
item
though
edit
those
items,
you've
just
run
a
record
for
Jessie.
Isn't
this
great
now
that
we
can
do
this
straight
from
reports?
Yes,.
A
B
Okay,
so
we're
gonna
go
over
to
reports
and
we
are
actually
going
to
use
one
of
the
reports
that
I
set
up,
but
let's
look
at
that
report
because
the
important
to
utilize-
this
is
the
fact.
You
include
item
number:
it's
not
that
reports.
Okay
here
it
is
so
let's
go
ahead
and
show
this
report,
so
the
most
important
item
number
field,
so
you
do
need
to
have
in
the
select
column
item
number
that's
going
to
allow
batch
item
modification,
because
that
is
what
we
use
for
batch
item
modification.
B
So
this
is
looking
for
any
lost
books
and
mailmouse
long.
So
let's
go
ahead
and
run
this
if
they
were
to
edit
this
Jessie.
This
is
another
just
a
small
feature
and
1805
is
now.
If
you
update
the
SQL
at
this
point,
you
are
not
going
to
go
to
that
blank
screen.
You
still
can
continue
editing.
That
was
another
feature
in
the
1805
I,
like
that.
You
stay
in
this
same
screen.
Okay,.
B
B
A
B
A
Now
Kelly,
as
for
doing
this,
let
me
ask
a
question
so
when
a
staff
member
would
go
into
batch
item
modification,
they
have
the
option
to
also
enter
in
barcodes
now
if
they
only
have
barcode
in
the
report,
it's
not
going
to
give
them
that
item
I'm.
Just
we
specified
that
people
do
need
to
have
that
item
number
in
the
report
and
in
order
for
this
to
work.
Yes,.
B
A
B
A
B
Match
modified
I
see
thee,
oh
and
there
we
go
so
they
still
see
it.
They
can't
go
any
further
because
I
don't
have
access
to
the
tools.
I
cannot
go
and
use
that
tool.
It's
so
that's
pretty
cool,
I
love!
This
feature,
I,
think
that
you
know
my
children
actually
were
just
talking
about
number
of
clicks
to
go
to
certain
places
and
I
think
that's
the
time
period
we
live
in
yeah.