[Koha] New patron restrictions data

2014-03-20 Thread Nicole Engard
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 ...

Re: [Koha] New patron restrictions data

2014-03-20 Thread Heather Braum (NEKLS)
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 hbr...@nekls.org

Re: [Koha] New patron restrictions data

2014-03-20 Thread Nicole Engard
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) hbr...@nekls.org wrote: If it's the old restrictions data (from before

Re: [Koha] New patron restrictions data

2014-03-20 Thread Jonathan Druart
Hello Nicole, It is in the borrower_debarments table. Regards, Jonathan 2014-03-20 15:00 GMT+01:00 Nicole Engard neng...@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

Re: [Koha] New patron restrictions data

2014-03-20 Thread Heather Braum (NEKLS)
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

Re: [Koha] New patron restrictions data

2014-03-20 Thread Nicole Engard
Thank you all! Nicole On Thu, Mar 20, 2014 at 9:55 AM, Heather Braum (NEKLS) hbr...@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