Re: [Koha] issuingrules from 19.11 to 20.05

3 Aug 2022

      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@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@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@inLibro.com
    <mailto:caroline.cyr-la-rose@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@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@inLibro.com <mailto:caroline.cyr-la-rose@inLibro.com>

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