Difference between the biblioitems.url field and the actual MARC 856 (in the xml)? I don't know what makes biblioitems.url get populated, but I suspect if you load data in bulk (outside the Tools import) it doesn't happen. Somebody had a neat trick on the IRC (chris_n?) for reading the actual MARC fields out of the XML. That might work better. Jane Wagner Library Systems Analyst PTFS Inc. Content Management and Library Solutions 6400 Goldsboro Road, Suite 200 Bethesda, MD 20817 (301) 654-8088 x 151 jwagner@ptfs.com -----Original Message----- From: koha-devel-bounces@lists.koha.org [mailto:koha-devel-bounces@lists.koha.org] On Behalf Of David Schuster Sent: Wednesday, January 27, 2010 8:32 AM To: koha-devel@lists.koha.org Subject: Re: [Koha-devel] SQL for 856 tag in marc record Well I'm getting closer, but that only provided me with a response of 40 and I know I have well over 3000 urls in records. Wonder why the rest didn't populate? They show up in the catalog... David Schuster Frederic Demians wrote:
Anyone have a suggestion on how to get at least a count of these 856's in the MARC record in my database?
SELECT COUNT(url) FROM biblioitems;
will give you the number of biblio records having at least one 856. A biblio record with several 856 tags will be count as 1 url.
If you want something more efficient, you could try to add an index named 'url' to your zebra configuration pointing to 856$t (and even other MARC subfields containing URLs). Then re-index. This PQF search will return exactly all records having something in 'url' field:
@attr 1=url @attr 2=103 ""
But same problem than with MySQL alternative. Maybe a zebra scan command could help. Don't know how exactly.
-- Frédéric
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
-- View this message in context: http://old.nabble.com/SQL-for-856-tag-in-marc-record-tp27329118p27339116.htm... Sent from the Koha - Dev mailing list archive at Nabble.com. _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel