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" <[email protected]> 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 <[email protected]>
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 <[email protected]>
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 <
[email protected]> 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
[email protected]
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
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
