[Koha] Name on the table Biblioitem

[Radek Šiman]

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 at 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 at 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 at 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 at 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 at 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 at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha