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, <[email protected]> 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>
    > [email protected]
    > 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
    [email protected]
    <mailto:[email protected]>

    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
    [email protected]
    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
[email protected] <mailto:[email protected]>

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

Koha mailing list  http://koha-community.org
[email protected]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Reply via email to