Hi.
I noticed that on the website Koha reports
(https://wiki.koha-community.org/wiki/SQL_Reports_Library) gone wrong
formatting SQL reports.
All reports now look like this:
SELECT biblioclass="sy0">.title, biblioclass="sy0">.author, issuesclass="sy0">
Any chance to correct this?
Ah yes, someone edited it today and messed it all up. Ill roll it back
Chris
On 08/03/17 21:11, Przemek Kosiński wrote:
> Hi.
>
> I noticed that on the website Koha reports
> (https://wiki.koha-community.org/wiki/SQL_Reports_Library) gone wrong
> formatting SQL reports.
> All reports now look li
Hello Rebecca,
I work in a small library in a govermental institution, and we have adopted
just now Koha. I must say that once it is implemented it is very easy to
work with.
The most difficult part is that you really need to have someone with very
good knowledge of Linux language, otherwise you
HI
I have compiled Date wise daily transactions/circulation report which I had
asked in my previous mails. Thanks to Barton Chittenden and Mark Alexander
for quick response.
Please also advice me, how to add this in the sql wiki library.
1. Date wise daily Transactions (Issue, Renewal, Return) sta
Try this:
SELECT biblioitems.biblionumber, biblio.copyrightdate, biblioitems.marcxml
FROM biblioitems
JOIN biblio
ON biblioitems.biblionumber=biblio.biblionumber
WHERE ExtractValue( marcxml, '//datafield[@tag="505"]/*' ) = "" and
biblio.copyrightdate is null and ExtractValue( marcxml,
'//datafield
Hi Vanda,
If you haven't found what you were looking for yet, have a look under
"Tools > Notices & slips". You'll also want to look at "Tools > Overdue
notices/status trigger". You may have to set up a couple of cronjobs on
your server as well (overdue_notices.pl, advance_notices.pl,
gather_p
At that time, I can chair, for about 45 minutes.
El mar., 7 mar. 2017 a las 20:33, Nick Clemens ()
escribió:
> HI All!
>
> Just a reminder that tomorrow at 19 UTC is the next Koha Developers IRC
> meeting.
>
> Conversion to local time here:
>
> https://www.timeanddate.com/worldclock/fixedtime.htm
François,
Mercy beaucoup! Thanks!
I had already set everything in Tools > Overdue notices/status trigger.
Maybe as you wrote, it has something to do with the cronjobs on our server.
I will ask my computer colleagues to see if that is the case.
Best regards,
Vanda
2017-03-08 12:37 GMT+00:00 Fra
Hi everybody,
Does anyone know how to do a SQL Report in order to get a list of all the
authority records we have already created in a period of time? And can we sort
it by alphabetical order?
Many thanks.
Vanda
___
Koha mailing list http://koha-commu
That looks to have fixed the issue – thank you!
SELECT biblioitems.biblionumber, biblio.copyrightdate, biblioitems.marcxml
FROM biblioitems
JOIN biblio
ON biblioitems.biblionumber=biblio.biblionumber
WHERE ExtractValue( marcxml, '//datafield[@tag="505"]/*' ) = "" and
biblio.copyrightdate is null
On 08/03/17 01:29, Rebecca Shtasel wrote:
Hello
We are a small group of volunteers (one of whom is a retired school
librarian) who run our synagogue's library in the UK. We would like to
produce an online catalogue and are interesting in using Koha for this
purpose as we haven't much money.
Not
Hello all,
We are facing a problem in Facets show more link with elastic search,
Selecting facets show more link doesn't show more results of (Authors,
Topics, ...etc) except (Home an Holding branches work perfectly), Instead
of this, It shows the following messages
*No results found!*
You did n
12 matches
Mail list logo
