[Koha] Framework Reports

[Katrin Fischer]

Hi Charles,

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>>

Hope this helps,

Katrin

On 01.10.21 01:51, Charles Kelley wrote:
> Hi, all!
>
>      I frequently use the following SQL report, which I think I got from the
> Koha wiki.
>
> SELECT bib.biblionumber AS 'Bib. Record Number', bib.author AS 'Author',
> bib.title AS 'Title'
> FROM biblio bib
> WHERE bib.frameworkcode = <<Choose MARC framework (bibliographic)
> framework>>
>
>      This serves us well, but as you might guess, one must know the
> framework code in order for the report to function correctly. Moreover,
> pressing "Run the report" without entering a framework leads to an
> out-of-memory error. (An empty submission would be equivalent to the
> default framework, but this seems not to be the case.)
>
>      Is there a way to modify it so that one can select from a list, e.g.,
>
> SELECT bib.biblionumber AS 'Bib. Record Number', bib.author AS 'Author',
> bib.title AS 'Title'
> FROM biblio bib
> WHERE bib.frameworkcode = <<Choose MARC framework (bibliographic)
> framework|FRAMEWORK_CODE>>
>
>      I have looked for the name of an equivalent to my FRAMEWORK_CODE list
> in the Koha wiki but alas, for I have not found it.
>
>      So, I duplicated the description in an ad-hoc authorized list, my
> FRAMEWORK_CODE above, but that means updating the new ad-hoc list every
> time we add or rid a framework. If there isn't already access to such a
> list, I'll submit a feature request.
>
>      Many thanks.
>