Re: [Koha] Unknown column 'metadata' in 'field list'

2017-08-09 Thread Jonathan Druart 
Vimal,

Koha 17.05 has been released with bug 17898.
With it you should see a new "Update" column on the report list if you have
reports using the biblioitems.marcxml columns.
There is a "Update SQL" button, when clicked a script will update the query
to use the new biblio_metadata column. This will not work in all cases but
if your query is simple it should work.

Regards,
Jonathan

On Wed, 9 Aug 2017 at 02:06 Vimal Kumar V.  wrote:

> Dear Friends,
> I am trying to generate a book list with keywords from 650$a using the
> following SQL query,
>
> SELECT ExtractValue( metadata,
> '//datafield[@tag="650"]/subfield[@code="a"]' ) AS Keyword, items.barcode,
> items.dateaccessioned, items.itemcallnumber, biblio.author, biblio.title,
> biblioitems.pages, biblioitems.publishercode, biblioitems.place,
> biblio.copyrightdate
> FROM items
> LEFT JOIN biblioitems ON
> (items.biblioitemnumber=biblioitems.biblioitemnumber)
> LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
> ORDER BY LPAD(items.barcode,40,' ') ASC
>
> After running the report, I got the following error message,
>
> The database returned the following error:
> Unknown column 'metadata' in 'field list'
> Please check the log for further details.
>
> Please review the SQL query and help me to solve the problem.
>
>
> Regards,
> --
> Vimal Kumar V.
> Librarian
> School of Indian Legal Thought
> Mahatma Gandhi University
> Kottayam, Kerala
> Web: http://www.vimalkumar.info
> Blogs: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in
> http://dspacegeek.blogspot.in
> http://moovandan.blogspot.in  
> ---
> "I forget what I was taught. I only remember what I have learnt"
> -Patrick White
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Unknown column 'metadata' in 'field list'

2017-08-09 Thread Shivendra 
Dear Vimal,

Please try with this query

SELECT biblio.biblionumber, biblio.author, biblio.title,
biblioitems.editionstatement, biblioitems.publishercode,
SUBSTRING(biblioitems.marcxml, LOCATE('',
   biblioitems.marcxml, LOCATE('', biblioitems.marcxml, LOCATE('',
   biblioitems.marcxml, LOCATE('',
biblioitems.marcxml,
   LOCATE('https://www.researchgate.net/profile/Shivendra_Singh3/contributions

On 9 August 2017 at 10:36, Vimal Kumar V.  wrote:

> Dear Friends,
> I am trying to generate a book list with keywords from 650$a using the
> following SQL query,
>
> SELECT ExtractValue( metadata,
> '//datafield[@tag="650"]/subfield[@code="a"]' ) AS Keyword, items.barcode,
> items.dateaccessioned, items.itemcallnumber, biblio.author, biblio.title,
> biblioitems.pages, biblioitems.publishercode, biblioitems.place,
> biblio.copyrightdate
> FROM items
> LEFT JOIN biblioitems ON
> (items.biblioitemnumber=biblioitems.biblioitemnumber)
> LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
> ORDER BY LPAD(items.barcode,40,' ') ASC
>
> After running the report, I got the following error message,
>
> The database returned the following error:
> Unknown column 'metadata' in 'field list'
> Please check the log for further details.
>
> Please review the SQL query and help me to solve the problem.
>
>
> Regards,
> --
> Vimal Kumar V.
> Librarian
> School of Indian Legal Thought
> Mahatma Gandhi University
> Kottayam, Kerala
> Web: http://www.vimalkumar.info
> Blogs: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in
> http://dspacegeek.blogspot.in
> http://moovandan.blogspot.in  
> 
> ---
> "I forget what I was taught. I only remember what I have learnt"
> -Patrick White
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>



-- 
Shivendra
9815526163
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Unknown column 'metadata' in 'field list'

2017-08-08 Thread Josef Moravec 
Hello Vimar,

you need to join the table biblio_metadata to your query

Best

Josef

st 9. 8. 2017 v 7:06 odesílatel Vimal Kumar V.  napsal:

> Dear Friends,
> I am trying to generate a book list with keywords from 650$a using the
> following SQL query,
>
> SELECT ExtractValue( metadata,
> '//datafield[@tag="650"]/subfield[@code="a"]' ) AS Keyword, items.barcode,
> items.dateaccessioned, items.itemcallnumber, biblio.author, biblio.title,
> biblioitems.pages, biblioitems.publishercode, biblioitems.place,
> biblio.copyrightdate
> FROM items
> LEFT JOIN biblioitems ON
> (items.biblioitemnumber=biblioitems.biblioitemnumber)
> LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
> ORDER BY LPAD(items.barcode,40,' ') ASC
>
> After running the report, I got the following error message,
>
> The database returned the following error:
> Unknown column 'metadata' in 'field list'
> Please check the log for further details.
>
> Please review the SQL query and help me to solve the problem.
>
>
> Regards,
> --
> Vimal Kumar V.
> Librarian
> School of Indian Legal Thought
> Mahatma Gandhi University
> Kottayam, Kerala
> Web: http://www.vimalkumar.info
> Blogs: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in
> http://dspacegeek.blogspot.in
> http://moovandan.blogspot.in  
> ---
> "I forget what I was taught. I only remember what I have learnt"
> -Patrick White
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Unknown column 'metadata' in 'field list'

2017-08-08 Thread Vimal Kumar V. 
Dear Friends,
I am trying to generate a book list with keywords from 650$a using the
following SQL query,

SELECT ExtractValue( metadata,
'//datafield[@tag="650"]/subfield[@code="a"]' ) AS Keyword, items.barcode,
items.dateaccessioned, items.itemcallnumber, biblio.author, biblio.title,
biblioitems.pages, biblioitems.publishercode, biblioitems.place,
biblio.copyrightdate
FROM items
LEFT JOIN biblioitems ON
(items.biblioitemnumber=biblioitems.biblioitemnumber)
LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
ORDER BY LPAD(items.barcode,40,' ') ASC

After running the report, I got the following error message,

The database returned the following error:
Unknown column 'metadata' in 'field list'
Please check the log for further details.

Please review the SQL query and help me to solve the problem.


Regards,
-- 
Vimal Kumar V.
Librarian
School of Indian Legal Thought
Mahatma Gandhi University
Kottayam, Kerala
Web: http://www.vimalkumar.info
Blogs: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in
http://dspacegeek.blogspot.in
http://moovandan.blogspot.in  
---
"I forget what I was taught. I only remember what I have learnt"
-Patrick White
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha