Hi Luis, maybe this SQL will help you to build your own query: SELECT ExtractValue(marcxml,'//datafield[@tag="260"]/subfield[@code="a"]') AS f260a, ExtractValue(marcxml,'//datafield[@tag="651"]/subfield[@code="a"]') AS f651a FROM biblioitems HAVING f260a = f651a Regards, Radek Dne 06.02.17 v 23:58 Luis Moises Rojas napsal(a):
Yes
El feb 6, 2017 6:46 PM, "Joy Nelson" <joy@bywatersolutions.com> escribió:
Luis- When you say "When user select the 260a fields" are you talking about cataloging an item or searching for an item?
joy
On Mon, Feb 6, 2017 at 2:14 PM, Luis Moises Rojas <lmoisesrojas@gmail.com> wrote:
Yes, more o less
The 651a field is the biblioitems.place on the table But, the 260a i can not find a fields on the table.
This is 'cos we want to have this: When user select the 260a fields, that field must be 651a and have to be saved in the biblioitem,place field on the table
On Mon, Feb 6, 2017 at 4:07 PM, Joy Nelson <joy@bywatersolutions.com> wrote:
If I'm understanding you correctly Luis, you want the value in the 651a to be found in the biblio.place field.
You could adjust your Koha keyword mapping and/or frameworks to map the 651a to the biblio.place field.
On Mon, Feb 6, 2017 at 2:03 PM, Luis Moises Rojas < lmoisesrojas@gmail.com> wrote:
Hi, I want to know the name of this fields on the table.
260a
I mean, if you see the fields 651a the name is place on biblioitems table.
This is because we want make something like this
260a=651a
So when a user select the Place of publication, have to be the geographic name.
Any help?
-- *Luis Moisés Rojas P.* _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Joy Nelson Director of Migrations
ByWater Solutions <http://bywatersolutions.com> Support and Consulting for Open Source Software Office: Fort Worth, TX Phone/Fax (888)900-8944 What is Koha? <http://bywatersolutions.com/what-is-koha/>
-- *Luis Moisés Rojas P.*
-- Joy Nelson Director of Migrations
ByWater Solutions <http://bywatersolutions.com> Support and Consulting for Open Source Software Office: Fort Worth, TX Phone/Fax (888)900-8944 What is Koha? <http://bywatersolutions.com/what-is-koha/>
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha