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

Override Product level OIR with Organisation level OIR

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.

prathiAnswer
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

View in thread

2 replies

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

Translate
    yinjin14-Alexandrite
    14-Alexandrite
    August 16, 2018

    Thanks 

    Translate
    Terms & ConditionsAccessibility statement