Re: [Koha] Framework Reports : The Next Iteration

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 On Tue, Oct 5, 2021 at 9:08 PM Charles Kelley wrote: > Hi again, all! > > I found a workaround for my

Re: [Koha] Framework Reports

Hi again, Elaine! In our latest exchange, on 7 Oct. 2021 at 02:00 [JST], you wrote: We're on 21.05 > Elaine > VWML > Hmmm. This gives me pause and reconsider migrating to 21.05 instead of 20.05. Maybe my bug was spotted earlier than I reported and fixed. Or it

Re: [Koha] Framework Reports

We're on 21.05 Elaine VWML On Tue, Oct 5, 2021 at 6:31 PM Charles Kelley wrote: > Hello, Elaine, et al! > > In our latest exchange, on 6 Oct. 2021 at 05:50 [JST], I received the > following through the Koha Discussion Group: > > Thank you for your reply. > > ODS

Re: [Koha] Framework Reports : The Next Iteration

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 = <> > ORDER BY

Re: [Koha] Framework Reports

Hello, Elaine, et al! In our latest exchange, on 6 Oct. 2021 at 05:50 [JST], I received the following through the Koha Discussion Group: Thank you for your reply. ODS worked for me, I haven't tried the other two. Which version of Koha > are you using? > Elaine > VWML

Re: [Koha] Framework Reports

ODS worked for me, I haven't tried the other two. Which version of Koha are you using? Elaine VWML On Sun, Oct 3, 2021 at 7:03 PM Charles Kelley wrote: > Hi, all! > > In our latest exchange, on 3 Oct. 2021 at 08:01 [JST], I received this > through the Koha Discussion

Re: [Koha] Framework Reports

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

Re: [Koha] Framework Reports

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 <> Hope this helps, Katrin On 01.10.21 01:51, Charles Kelley wrote: Hi, all! I frequently use the

[Koha] Framework Reports

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 = <> This serves us well, but as you might guess, one must