Overdue location in mysql

View: New views
3 Messages — Rating Filter:   Alert me  

Overdue location in mysql

by Scott Owen :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi all,

I'm doing a few custom reports for Koha 2.2.9, and can't seem to find an
"overdue" field in the Koha MySQL database anywhere??
Am I just not seeing it or does it use different terminology ?
Thanks ,

-Scott Owen
Alma Public Schools

_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: Overdue location in mysql

by Jesse Weaver-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message



On Fri, Oct 31, 2008 at 9:18 AM, Scott Owen <sowen@...> wrote:
Hi all,

I'm doing a few custom reports for Koha 2.2.9, and can't seem to find an
"overdue" field in the Koha MySQL database anywhere??
Am I just not seeing it or does it use different terminology ?
Thanks ,

-Scott Owen
Alma Public Schools

_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

Technically, there is none. You would have to compare the due date to today (or the due date to the return date, if you're working with returned books in old_issues).

--
Jesse Weaver
Software Developer, LibLime

_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: Overdue location in mysql

by Scott Owen :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Well good......
At least it's not just me overlooking the obvious....thanks!



Jesse Weaver wrote:

>
>
> On Fri, Oct 31, 2008 at 9:18 AM, Scott Owen <sowen@...
> <mailto:sowen@...>> wrote:
>
>     Hi all,
>
>     I'm doing a few custom reports for Koha 2.2.9, and can't seem to
>     find an
>     "overdue" field in the Koha MySQL database anywhere??
>     Am I just not seeing it or does it use different terminology ?
>     Thanks ,
>
>     -Scott Owen
>     Alma Public Schools
>
>     _______________________________________________
>     Koha mailing list
>     Koha@... <mailto:Koha@...>
>     http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> Technically, there is none. You would have to compare the due date to
> today (or the due date to the return date, if you're working with
> returned books in old_issues).
>
> --
> Jesse Weaver
> Software Developer, LibLime

_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha
LightInTheBox - Buy quality products at wholesale price!