Re: [Koha] Wiki down?

upport: t...@nekls.org > > 4317 W 6th St, Lawrence, KS, 66049 > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > -- Joe Sikowitz Collaborative Serv

Re: [Koha] Adding pre-defined Manual Invoice Types

e cannot dodge the > consequences of dodging our responsibilities." Josiah Charles Stamp, > 1880-1941, former director of the Bank of England > > > > ___ > Koha mailing list http://koha-community.org > Koha@lists.kati

Re: [Koha] Need a little help with an SQL query

> ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > -- Joe Sikowitz Collaborative Services Librarian Fenway Library Organization (617) 989-5031 j...@flo.org

Re: [Koha] Need a little help with an SQL query

ernumber) INNER JOIN old_issues o ON (b.borrowernumber = o.borrowernumber) WHERE i.issuedate or o.issuedate BETWEEN <> AND <> GROUP BY b.cardnumber Joe On Wed, Feb 20, 2019 at 11:35 AM Joe Sikowitz wrote: > Something like this may work: > > SELECT b.cardnumber, b.surname, b.firstnam

Re: [Koha] Need a little help with an SQL query

ON (b.borrowernumber = o.borrowernumber) WHERE i.issuedate BETWEEN <> AND <> OR o.issuedate BETWEEN <> AND <> GROUP BY b.cardnumber On Wed, Feb 20, 2019 at 12:11 PM Joe Sikowitz wrote: > You could also add in old issues which you probably would want so that you > get

Re: [Koha] Need a little help with an SQL query

a way to avoid that? (It's not a big deal as we won't be > running the report very often) > > Thanks again, > > Chris Brown > > > On Wed, Feb 20, 2019 at 5:20 PM Joe Sikowitz wrote: > >> Ignore the last one. This one will work better. Hope this is helpfu

Re: [Koha] Need a little help with an SQL query

t; There's a piece of terminology that we use at ByWater ... we call >> >> '<<' and '>>' >> >> 'hungry alligators' (because '<<' and '>>' look like the open mouths of >> alligators)... it&#