[Koha] Framework Reports : The Next Iteration

[Elaine Bradtke]

I gather from this that
a) there are biblios in the catalogue without a framework
b) this causes the report without the null statement to fail.
Interesting.
Elaine
VWML <https://vwml.org>



On Tue, Oct 5, 2021 at 9:08 PM Charles Kelley <cmkelleymls at gmail.com> wrote:

> Hi again, all!
>
>     I found a workaround for my library's problem with the empty downloads
> of bib. records compiled by
>
> 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
>>
>
>     In a duplicate of the report above, I changed the WHERE clause to
>
> WHERE biblio.frameworkcode = '' OR biblio.frameworkcode IS NULL
>>
>
>     The new report becomes
>
> SELECT biblio.biblionumber AS 'Bib. Record No.', biblio.author AS
>> 'Author', biblio.title AS 'Title'
>>     FROM biblio
>>     WHERE WHERE biblio.frameworkcode = '' OR biblio.frameworkcode IS NULL
>>     ORDER BY biblio.biblionumber ASC
>>
>
>     While it is not ideal, it works well enough for my library's purposes
> (counts, identification of bib. records, etc.).
>
>     We still welcome suggestions on how to exterminate this bug if you
> have any. But for the time being, the interim solution above will do.
>
> -
>
>     -- 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.
>