Hello, all!
In my previous experience with SQL, case did not matter, but here it
does?
I've been tearing out my hair -- and I'm bald -- for the last several
hours over a reported syntax error in a SQL statement I have been
composing. It turns out that it wasn't a syntax error, per se --
Dear all,
I need a help. I have problems with Koha's Hold feature. Patron can place a
hold but cannot cancel it.
For cancelling a hold the message is: "Sorry, the requested page is not
available. Error 500"
Staff can check in a hold, bu cannot:
- check out a hold
- suspend a hold
- delete a
Hi, Katrin!
In our latest exchange, on 1 Oct. 2021 at 8:00 [JST], I received the
following:
can you give an example for a report that still shows the deleted records?
>
> Katrin
>
How's this sample from the report:
Bib. Record Number Author Main
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
Hi Charles,
can you give an example for a report that still shows the deleted records?
Katrin
On 30.09.21 04:27, Charles Kelley wrote:
Hi, all!
Some months ago, I deleted several records. None of the deleted records
shows up in a regular search of the catalog. However, all three show up
Salut Julien,
'Easily' I don't know. But quite easily with a small script.
0. Have 2 frameworks, FwA with your subfield linked to paidfor and FwB
with no DB link
1. loop over the items
2. Retrieve the item and save it using FwB (C4::Items::ModItemFromMarc)
Haven't tried, but it should work. If
Hi everyone,
Do you know if there is a method, a script or a tool to easily migrate a linked
(koha db) item subfield to an unlinked item subfield (ie :
items.more_subfields_xml).
We will soon upgrade koha from 18.11 to 20.11and we are trying to find a
solution to the removal of items.paidfor
7 matches
Mail list logo