[Koha] Report help

2018-02-21 Thread Katharina Penner
Dear all, I need to create a report to extract all metadata on all authors. I want to have each aspect - surname, name (or initials), dates, expansion of initials, other possible fields - appear in a separate field/column, in a delimited way. We're using UniMarc so these would be fields 700 a, b,

Re: [Koha] Report help

2018-02-21 Thread Katharina Penner
We use 17.05, and so I have tried to substitute "marcxml" with "biblio_metadata", like recommended at the Wiki page: https://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC. But I keep getting the following error message: The following error was encountered: The database returned the f

Re: [Koha] Report help

2018-02-21 Thread Jonathan Druart
Hello Katharina, Do you see the "Update SQL" button on the report list? Did you try it? It is supposed to update the query with the new table structure. Regards, Jonathan On Wed, 21 Feb 2018 at 13:24 Katharina Penner wrote: > We use 17.05, and so I have tried to substitute "marcxml" with > "bi

Re: [Koha] Report help

2018-02-21 Thread Katharina Penner
Yes, sorry, I had done this before for other reports and now forgot to return to it. That did the trick!! Thank you! Katharina On Wed, Feb 21, 2018 at 6:16 PM, Jonathan Druart < jonathan.dru...@bugs.koha-community.org> wrote: > Hello Katharina, > > Do you see the "Update SQL" button on the repor