[Koha] Framework Reports

[Charles Kelley]

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.