need help in report using XML
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.
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 | david.nind@gmail.com PO Box 12367, Thorndon, Wellington, New Zealand 6144 h. +64 4 9720 600 | m. +64 21 0537 847 | w. +64 4 8906 098
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
Thank you very much it works very good -- View this message in context: http://koha.1045719.n5.nabble.com/need-help-in-report-using-XML-tp5730388p57... Sent from the Koha-general mailing list archive at Nabble.com.
participants (3)
-
Bernardo Gonzalez Kriegel -
David Nind -
zalabany