Skip to main content
P
prathi1-Visitor
1-Visitor
March 30, 2016
Solved

Override Product level OIR with Organisation level OIR

  • March 30, 2016
  • 1 reply
  • 1712 views

In the organisation context we have 568 products, for which Product level OIRs have been such that Numbers are auto generated for WTPart (it has final = "false" for Numbering). But now the requirement is such that for all products the numbering should be manual. I created an OIR at Org level with final = "true" value and set auto numbering off, but still numbering is auto generated only. Is there some way to override the product level OIR at Org/Site level so that we can have manual numbering, as going manually and changing OIRs for all products is a tedious job.

Best answer by prathi

We solved this issue using Database. For OIRs there is table TYPEBASEDRULE which has a column ENABLEDFLAG. If its value is 0 it means enabled and if its 1 it is disabled. So we wrote the following command to disable the OIR in all our products :

  • UPDATE TYPEBASEDRULE SET enabledFlag=1 where classnamekeycontainerreferen = 'wt.pdmlink.PDMLinkProduct' and name = 'Part_Havells';

Part_Havells is name of our OIR

1 reply

P
prathi1-VisitorAuthorAnswer
1-Visitor
April 1, 2016

We solved this issue using Database. For OIRs there is table TYPEBASEDRULE which has a column ENABLEDFLAG. If its value is 0 it means enabled and if its 1 it is disabled. So we wrote the following command to disable the OIR in all our products :

  • UPDATE TYPEBASEDRULE SET enabledFlag=1 where classnamekeycontainerreferen = 'wt.pdmlink.PDMLinkProduct' and name = 'Part_Havells';

Part_Havells is name of our OIR

    Y
    yinjin14-Alexandrite
    14-Alexandrite
    August 16, 2018

    Thanks 

    Terms & ConditionsCookie settingsAccessibility statement