[Koha] Framework Reports

[Elaine Bradtke]

ODS worked for me, I haven't tried the other two.  Which version of Koha
are you using?
Elaine
VWML <https://vwml.org>



On Sun, Oct 3, 2021 at 7:03 PM Charles Kelley <cmkelleymls at gmail.com> wrote:

> Hi, all!
>
>     In our latest exchange, on 3 Oct. 2021 at 08:01 [JST], I received this
> through the Koha Discussion Group:
>
> for the existing runtime parameters you can refer to the manual:
> >
> >
> >
> https://koha-community.org/manual//21.05/en/html/reports.html#report-from-sql
> >
> > The one for frameworks is <<Framework list|biblio_framework>>
> >
>
>     Thank you for the advisement. My report works properly now excepting
> for one problem: While I now get a proper list, when I press the Download
> button, I get only the header. The actual downloaded report is empty
> excepting for the header. Worse, the downloaded report is empty only when
> the selected framework is the default. The reports for the other
> frameworks, e.g., BK (for textual materials), do indeed download the
> biblionumber, author, and title.
>
>     Here's the SQL instruction in its entirety:
>
> SELECT biblio.biblionumber AS 'Bib. Record No.', biblio.author AS 'Author',
> > biblio.title AS 'Title'
> >     FROM biblio
> >     WHERE biblio.frameworkcode = <<Which framework?|biblio_framework>>
> >     ORDER BY biblio.biblionumber ASC
> >
>
>     This happens to all three download file options: CSV, TAB, and ODS.
>
>     Any advice on fixing this? Is this a bug? I didn't see such a bug on
> Bugzilla, so I submitted one, by the way.
>
> --
>
>     気を付けて。 /ki wo tukete/ = Take care.
>
>     -- Charles.
>
>     Charles Kelley, MLS
>     PSC 704 Box 1029
>     APO AP 96338
>
>     Charles Kelley
>     Tsukimino 1-Chome 5-2
>     Tsukimino Gaadenia #210
>     Yamato-shi, Kanagawa-ken
>     〒242-0002 JAPAN
>
>     +1-301-741-7122 [US cell]
>     +81-80-4356-2178 [JPN cell]
>
>     mnogojazyk at aol.com [h]
>     cmkelleymls at gmail.com [p]
>
>     linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls>
>     Meeting Your Information Needs. Virtually.
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>