When I made a SQL report on Koha LMS by using Extract Value, the server goes down (Hmmm. can't reach this page)!.
The query is correct.
Note: the server running on Virtual Machine.
the query:
SELECT biblionumber,
concat (ExtractValue(metadata,'//datafield[@tag="245"]/subfield[@code="a"]')," ",
ExtractValue(metadata,'//datafield[@tag="245"]/subfield[@code="b"]')," ",
ExtractValue(metadata,'//datafield[@tag="245"]/subfield[@code="c"]')) as "245",
concat (ExtractValue(metadata,'//datafield[@tag="260"]/subfield[@code="a"]')," ",
ExtractValue(metadata,'//datafield[@tag="260"]/subfield[@code="b"]')," ",
ExtractValue(metadata,'//datafield[@tag="260"]/subfield[@code="c"]')) as "260"
FROM biblio_metadata where ExtractValue(metadata,'//datafield[@tag="650"]/subfield[@code="x"]') like "%Perio%" or ExtractValue(metadata,'//datafield[@tag="650"]/subfield[@code="v"]') like "%Perio%"
