[Koha] issuingrules from 19.11 to 20.05

[Caroline Cyr La Rose]

Hi Vinod,

If you look at the existing rules in circulation_rules, you'll notice 
the rule name is in the rule_name column and the value is in rule_value.

If you need to insert via SQL, you can do something like

INSERT INTO circulation_rules (branchcode, categorycode, itemtype, 
rule_name, rule_value) VALUES ("BRANCHCODE", "CATEGORYCODE", "ITEMTYPE", 
"issuelength", "21");

I would suggest doing it via the administration interface 
(Administration > Circulation and fines rules) however, just because 
there are so many different rules. I'm not sure what the consequences 
are if only a few rules are filled in.

Regards,

Caroline

On 2022-08-03 01:17, vinod mishra wrote:
> Hello Rose
>
> Actualy i wish to incorporate new codes/columns in place of following 
> in existing RFID middleware:
>
> issuelength
> maxissueqty
> renewalsallowed
>
> Can anyone help which new columns / code can be substituted for?
>
>
>
> On Tue, 2 Aug, 2022, 19:42 Caroline Cyr La Rose, 
> <caroline.cyr-la-rose at inlibro.com> wrote:
>
>     Hi Vinod,
>
>     This table was replaced by circulation_rules. The structure is quite
>     different, as you'll notice.
>
>     Caroline
>
>     On 2022-08-02 01:34, vinod mishra wrote:
>     > Hello
>     >
>     > Can anyone help to know "issuingrules" table contents moved to
>     which table
>     > from Version 20.05? as it was there up to 19.11 and what tables
>     columns
>     > could be used in place of issuingrules if similar does not exist?
>     >
>     > With Regards,
>     >
>     > Vinod Kumar Mishra,
>     > Assistant Librarian,
>     > Biju Patnaik Central Library (BPCL),
>     > NIT Rourkela,
>     > Sundergadh-769008,
>     > Odisha,
>     > India.
>     > Mob:91+9439420860
>     > URL:http://vinod.itshelp.co.in/
>     > ORCID ID:http://orcid.org/0000-0003-4666-7874
>     > Scopus ID: 57223138343
>     >
>     > *"Spiritual relationship is far more precious than physical.
>     Physical
>     > relationship divorced from spiritual is body without soul" --
>     Mahatma
>     > Gandhi*
>     > _______________________________________________
>     >
>     > Koha mailing listhttp://koha-community.org
>     <http://koha-community.org>
>     > Koha at lists.katipo.co.nz
>     > Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
>     Caroline Cyr La Rose, M.L.I.S.
>     Librarian | Product Manager
>
>     Phone: 1-833-465-4276, ext. 221
>     Caroline.Cyr-La-Rose at inLibro.com
>     <mailto:caroline.cyr-la-rose at inLibro.com>
>
>     INLiBRO | Document Technologies Specialists | www.inLibro.com
>     <http://www.inLibro.com>
>     <http://www.inLibro.com <http://www.inLibro.com>>
>     _______________________________________________
>
>     Koha mailing list http://koha-community.org
>     Koha at lists.katipo.co.nz
>     Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
-- 
Caroline Cyr La Rose, M.S.I.
Bibliothécaire | Responsable de produit

Tél. : 1-833-465-4276, poste 221
Caroline.Cyr-La-Rose at inLibro.com <mailto:caroline.cyr-la-rose at inLibro.com>

INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com 
<http://www.inLibro.com>