Re: [Koha] Koha Digest, Vol 66, Issue 44

19 Apr 2011


      Dear Vimal ji,

Please add WHERE date(issues.issuedate) BETWEEN '2011-02-08' AND
'2011-02-09' line in your sql query and generate with date limit

SELECT issues.issuedate,items.barcode,biblio.title,
author,borrowers.firstname,borrowers.surname FROM issues LEFT JOIN borrowers
ON borrowers.borrowernumber=issues.borrowernumber LEFT JOIN items ON
issues.itemnumber=items.itemnumber LEFT JOIN biblio ON
items.biblionumber=biblio.biblionumber
WHERE date(issues.issuedate) BETWEEN '2011-02-08' AND '2011-02-09'
ORDER BY issues.issuedate

Thanks & Regards,
Nikunj Tyagi, DPL

On Tue, Apr 19, 2011 at 6:31 PM, <koha-request@lists.katipo.co.nz> wrote:
...
Send Koha mailing list submissions to
       koha@lists.katipo.co.nz
To subscribe or unsubscribe via the World Wide Web, visit
       http://lists.katipo.co.nz/mailman/listinfo/koha
or, via email, send a message with subject or body 'help' to
       koha-request@lists.katipo.co.nz
You can reach the person managing the list at
       koha-owner@lists.katipo.co.nz
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Koha digest..."
Today's Topics:
1. Authorities (martin caris)
  2. Ashik Rajbhandari invited you to Dropbox (Dropbox)
  3. Koha behind proxy server (schwitzd)
  4. Re: Accents in Irish Gaelic (Peter Lorimer)
  5. Circulation report limited with date (Vimal Kumar)
  6. Re: Accents in Irish Gaelic (Elaine Bradtke)
  7. Koha move to 3.4 (Linda Culberson)
----------------------------------------------------------------------
Message: 1
Date: Tue, 19 Apr 2011 02:44:47 +0200
From: martin caris <martin_caris@hotmail.com>
Subject: [Koha] Authorities
To: <koha@lists.katipo.co.nz>
Message-ID: <COL101-W5529B39CE3A89B2AB49BFBF7900@phx.gbl>
Content-Type: text/plain; charset="iso-8859-1"
Hello,
I have a problem with my authorities: I catalog my book in the framework
and I save my bibliographic record, but when I see my authority record, no
authorities are linked. How is it possible?
 Koha version: 3.02.05.
Another question: is it possible to create, in the field 952 (copy field),
 my own subfields?
Thank you.
Martin Caris

Nikunj Tyagi

tags

participants (1)