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.html 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
