[Koha] Report generation

[zen zenitram]

Hello

Any one know how to create report in sql, of your collection that has Tag
521 and 526 in your output.

Thank you!
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Report Generation

[geromoselle]

Hello everyone,
Please, can anyone help me with dB query code to generate a report from my koha 
database from October last year till date with full list of bibliography 
entries. Thanks
George Eromosele
Systems Librarian


Sent from Samsung Mobile.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Report generation

[zen zenitram]

We need cataloging report thats shows Tag 521 or Tag 526.

On Tue, Mar 28, 2023 at 12:54 PM Ketan Kulkarni  wrote:

> What kind of report are you trying to generate ?
> You can get many here
> https://wiki.koha-community.org/wiki/SQL_Reports_Library
>
> Ketan
>
> On Tue, Mar 28, 2023 at 9:47 AM zen zenitram 
> wrote:
>
>> Hello
>>
>> Any one know how to create report in sql, of your collection that has Tag
>> 521 and 526 in your output.
>>
>> Thank you!
>> ___
>>
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Report generation

[Barbara Johnson]

Hi Zen,

This should provide you with a list of bibs with those two MARC tags:

SELECT i.dateaccessioned, b.biblionumber, i.permanent_location AS 'location', 
i.itemcallnumber AS 'call#', b.title, 
ExtractValue(metadata,'//datafield[@tag="521"]/subfield[@code>="a"]') AS 
'audience', 
ExtractValue(metadata,'//datafield[@tag="526"]/subfield[@code>="a"]') AS 'note'
FROM biblio b
LEFT JOIN biblio_metadata m using (biblionumber)
LEFT JOIN items i using (biblionumber)
GROUP BY b.biblionumber

Hope this helps,
Barbara

--
Barbara Johnson
Technical Services Manager
Bedford Public Library
2424 Forest Ridge Drive, Bedford, TX 76021-4667
Office: 817-952-2360 | Fax: 817-952-2396 | 
barbara.john...@bedfordtx.gov


From: Koha  on behalf of zen zenitram 

Sent: Monday, March 27, 2023 11:17 PM
To: koha@lists.katipo.co.nz 
Subject: [Koha] Report generation

EXTERNAL SENDER


Hello

Any one know how to create report in sql, of your collection that has Tag
521 and 526 in your output.

Thank you!
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
CONFIDENTIALITY NOTICE: This City of Bedford (CoB) email transmission is 
intended only for the use of the individual to whom it is addressed and may 
contain information that is confidential, privileged, and exempt from 
disclosure. Any use, copying, retention or disclosure by any person other than 
the intended recipient or the intended recipient's designees is strictly 
prohibited. If you have received this email in error, please notify the sender 
immediately by return email and destroy all electronic and paper copies of the 
original message and any attachments immediately.
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Report generation

[Elaine Bradtke]

Warning: what I don't know about SQL queries would fill a book, but I've
adapted one that works for us.

SELECT biblionumber, ExtractValue(`metadata`,'//datafield[@tag="521"]/*')
FROM `biblio_metadata` WHERE
ExtractValue(`metadata`,'count(//datafield[@tag="521"])>0')

If that works you could also do a similar thing for 526 by changing the tag
numbers
Elaine
VWML 



On Tue, Mar 28, 2023 at 12:54 AM zen zenitram  wrote:

> We need cataloging report thats shows Tag 521 or Tag 526.
>
> On Tue, Mar 28, 2023 at 12:54 PM Ketan Kulkarni 
> wrote:
>
> > What kind of report are you trying to generate ?
> > You can get many here
> > https://wiki.koha-community.org/wiki/SQL_Reports_Library
> >
> > Ketan
> >
> > On Tue, Mar 28, 2023 at 9:47 AM zen zenitram 
> > wrote:
> >
> >> Hello
> >>
> >> Any one know how to create report in sql, of your collection that has
> Tag
> >> 521 and 526 in your output.
> >>
> >> Thank you!
> >> ___
> >>
> >> Koha mailing list  http://koha-community.org
> >> Koha@lists.katipo.co.nz
> >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> >>
> >
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha