Re: [Koha] need help in report using XML

21 Oct 2012


      You need to rephrase your query, like

select
  ExtractValue(marcxml,'//datafield[@tag="880"]/subfield[@code>="a"]') as
AR
from
  biblioitems
where
  biblionumber between 100 and 110;

In case that you need more tags, you could add them like
select
  ExtractValue(marcxml,'//datafield[@tag="100"]/subfield[@code>="a"]') as
ONE,
  ExtractValue(marcxml,'//datafield[@tag="245"]/subfield[@code>="a"]') as
TWO,
  ExtractValue(marcxml,'//datafield[@tag="250"]/subfield[@code>="a"]') as
THREE,
  ExtractValue(marcxml,'//datafield[@tag="260"]/subfield[@code>="a"]') as
FOUR,
  ExtractValue(marcxml,'//datafield[@tag="880"]/subfield[@code>="a"]') as
FIVE
from
  biblioitems
where
  biblionumber between 100 and 110;

Hope that helps,
Bernardo

-- 
Bernardo Gonzalez Kriegel
bgkriegel@gmail.com


On Sat, Oct 20, 2012 at 11:52 AM, zalabany <mh_zalabany@hotmail.com> wrote:
...
i need to make report including the main data of the books
and i have data in 880 field i want to include this field in the report
the report
note(880 is vernacular field that i put the title and author and publisher
and statement with Arabic )
SELECT
  ExtractValue((
    SELECT marcxml
    FROM biblioitems
    WHERE biblionumber
    = '520'),
      '//datafield[@tag="880"]/subfield[@code>="a"]') AS AR
then i make the next report to premit to user to add the number of biblio
number
SELECT
  ExtractValue((
    SELECT marcxml
    FROM biblioitems
    WHERE biblionumber
    = <<>>),
      '//datafield[@tag="880"]/subfield[@code>="a"]') AS AR
i have tow problem now
i want to run this report to display range from biblionumber to another one
i try to use between but it doesn't work
this was the statement
WHERE biblionumber BETWEEN <<>> AND <<>>),
 WHERE biblionumber BETWEEN 100 AND 150),
and there is no result
the second problem
i need to make bibliographic report with the field 100 245  250  260 and
880
fields
how to insert 880 field in to the same record
thanks
--
View this message in context:
http://koha.1045719.n5.nabble.com/need-help-in-report-using-XML-tp5730388.ht...
Sent from the Koha-general mailing list archive at Nabble.com.
_______________________________________________
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha