[Koha] need help in report using XML

[Bernardo Gonzalez Kriegel]

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 at gmail.com



On Sat, Oct 20, 2012 at 11:52 AM, zalabany <mh_zalabany at 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.html
> Sent from the Koha-general mailing list archive at Nabble.com.
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>