[Koha] Title/Subtitle List Report

[Ma. Victoria H. Silva-Manuel]

Hi, Alvaro.

Thank you for your insight.
I have found another SQL report that can generate the data that I need.
I'm not into programming, all I can do is copy ready-made SQL and edit some
parts.

Again, thank you and have a nice day.



On Fri, Aug 16, 2019 at 9:53 AM Alvaro Cornejo <cornejo.alvaro at gmail.com>
wrote:

> Hi Ma. Victoria
>
> Some tables has been modified in the latest version of koha. Al marc data
> has been moved to an especific table outside the rest of reccord
> information. The new table is biblio_metadata
>
> xml strucure is the same though.
>
> You can check the tables structure for your specific version in:
>
> http://schema.koha-community.org/
>
> Therefore, you need to edit your query using a join of the biblio table
> and biblio_metadata
>
> Regards,
>
> Alvaro
>
>
>
> |-----------------------------------------------------------------------------------------------------------------|
> Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
> celular y Nextel
> en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS
> y GPRS online
>               Visitenos en www.perusms.com
>
>
> Le jeu. 15 août 2019 à 19:33, Ma. Victoria H. Silva-Manuel <
> mavicsilva at gmail.com> a écrit :
>
>> Hi.
>>
>> I got the SQL report below from wiki.koha-community.org, however it is
>> not
>> working.
>>
>>
>> SELECT concat(b.title, ' ', ExtractValue((
>> >     SELECT marcxml
>> >     FROM biblioitems b2
>> >     WHERE b.biblionumber = b2.biblionumber),
>> >       '//datafield[@tag="245"]/subfield[@code="b"]')) AS title,
>> >     b.author, i.itemcallnumber FROM biblio b LEFT JOIN items i ON
>> > (i.biblionumber=b.biblionumber)
>> >
>>
>> It shows the following error:
>>
>> The following error was encountered:
>>
>> The database returned the following error:
>>
>> Unknown column 'marcxml' in 'field list'
>>
>> Please check the log for further details.
>>
>> Return to previous page
>>
>>
>> Does anyone knows what went wrong?
>>
>> Thank you.
>>
>> --
>> Ma. Victoria H. Silva-Manuel
>> Registered Librarian, 3892
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>

-- 
Ma. Victoria H. Silva-Manuel
Registered Librarian, 3892