need help in report using XML

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

need help in report using XML

zalabany
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
Reply | Threaded
Open this post in threaded view
|

Re: need help in report using XML

David Nind
Hi.

I don't have any reports experience with Koha (yet), so can't help with
your specific questions.

You may wish to check out the reports library to see if there is anything
similar to what you require:
http://wiki.koha-community.org/wiki/SQL_Reports_Library


David Nind | [hidden email]
PO Box 12367, Thorndon, Wellington, New Zealand 6144
h. +64 4 9720 600 | m. +64 21 0537 847 | w. +64 4 8906 098
_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
http://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: need help in report using XML

Bernardo Gonzalez Kriegel-2
In reply to this post by zalabany
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
[hidden email]



On Sat, Oct 20, 2012 at 11:52 AM, zalabany <[hidden email]> 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
> [hidden email]
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
http://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: need help in report using XML

zalabany
In reply to this post by zalabany
Thank you very much it works very good