New patron restrictions data
Hi all, I'm wondering where in the DB the new restrictions data is stored for patrons. I have a patron with 2 restrictions on her account and when I look at borrowers.debarred I only see 1 of them. The other shows when I view the record in the staff client so the data has to be somewhere ... where is it? :) Thanks Nicole
If it's the old restrictions data (from before the library upgraded to 3.14) the data is located in the borrowers table, in the borrowers.debarred and borrowers.debarred comment fields. Heather Braum NExpress Coordinator Resource Sharing Librarian Northeast Kansas Library System hbraum@nekls.org "The illiterate of the 21st century will not be those cannot read and write, but those who cannot learn, unlearn, and relearn." ~Alvin Toffler, *Rethinking the Future* On Thu, Mar 20, 2014 at 9:00 AM, Nicole Engard <nengard@gmail.com> wrote:
Hi all,
I'm wondering where in the DB the new restrictions data is stored for patrons. I have a patron with 2 restrictions on her account and when I look at borrowers.debarred I only see 1 of them. The other shows when I view the record in the staff client so the data has to be somewhere ... where is it? :)
Thanks Nicole _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Yup, and 1 of the restrictions is stored there, but I have 2 restrictions on the patron record and the other isn't anywhere in the borrowers table that I can see. Nicole On Thu, Mar 20, 2014 at 9:49 AM, Heather Braum (NEKLS) <hbraum@nekls.org> wrote:
If it's the old restrictions data (from before the library upgraded to 3.14) the data is located in the borrowers table, in the borrowers.debarred and borrowers.debarred comment fields.
Heather Braum NExpress Coordinator Resource Sharing Librarian Northeast Kansas Library System hbraum@nekls.org
"The illiterate of the 21st century will not be those cannot read and write, but those who cannot learn, unlearn, and relearn." ~Alvin Toffler, *Rethinking the Future*
On Thu, Mar 20, 2014 at 9:00 AM, Nicole Engard <nengard@gmail.com> wrote:
Hi all,
I'm wondering where in the DB the new restrictions data is stored for patrons. I have a patron with 2 restrictions on her account and when I look at borrowers.debarred I only see 1 of them. The other shows when I view the record in the staff client so the data has to be somewhere ... where is it? :)
Thanks Nicole _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hello Nicole, It is in the borrower_debarments table. Regards, Jonathan 2014-03-20 15:00 GMT+01:00 Nicole Engard <nengard@gmail.com>:
Hi all,
I'm wondering where in the DB the new restrictions data is stored for patrons. I have a patron with 2 restrictions on her account and when I look at borrowers.debarred I only see 1 of them. The other shows when I view the record in the staff client so the data has to be somewhere ... where is it? :)
Thanks Nicole _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Thank you Jonathan for correcting me. I completely misread Nicole's question as the data she had was in the borrower_debarments table and she was asking where was the other data was. :) I need much more coffee this morning! Heather Braum NExpress Coordinator Resource Sharing Librarian Northeast Kansas Library System hbraum@nekls.org "The illiterate of the 21st century will not be those cannot read and write, but those who cannot learn, unlearn, and relearn." ~Alvin Toffler, *Rethinking the Future* On Thu, Mar 20, 2014 at 9:51 AM, Jonathan Druart < jonathan.druart@biblibre.com> wrote:
Hello Nicole,
It is in the borrower_debarments table.
Regards, Jonathan
2014-03-20 15:00 GMT+01:00 Nicole Engard <nengard@gmail.com>:
Hi all,
I'm wondering where in the DB the new restrictions data is stored for patrons. I have a patron with 2 restrictions on her account and when I look at borrowers.debarred I only see 1 of them. The other shows when I view the record in the staff client so the data has to be somewhere ... where is it? :)
Thanks Nicole _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Thank you all! Nicole On Thu, Mar 20, 2014 at 9:55 AM, Heather Braum (NEKLS) <hbraum@nekls.org> wrote:
Thank you Jonathan for correcting me. I completely misread Nicole's question as the data she had was in the borrower_debarments table and she was asking where was the other data was. :) I need much more coffee this morning!
Heather Braum NExpress Coordinator Resource Sharing Librarian Northeast Kansas Library System hbraum@nekls.org
"The illiterate of the 21st century will not be those cannot read and write, but those who cannot learn, unlearn, and relearn." ~Alvin Toffler, *Rethinking the Future*
On Thu, Mar 20, 2014 at 9:51 AM, Jonathan Druart <jonathan.druart@biblibre.com> wrote:
Hello Nicole,
It is in the borrower_debarments table.
Regards, Jonathan
2014-03-20 15:00 GMT+01:00 Nicole Engard <nengard@gmail.com>:
Hi all,
I'm wondering where in the DB the new restrictions data is stored for patrons. I have a patron with 2 restrictions on her account and when I look at borrowers.debarred I only see 1 of them. The other shows when I view the record in the staff client so the data has to be somewhere ... where is it? :)
Thanks Nicole _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
Heather Braum (NEKLS) -
Jonathan Druart -
Nicole Engard