cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

Override Product level OIR with Organisation level OIR

prathi
1-Newbie

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.

1 ACCEPTED SOLUTION

Accepted Solutions
prathi
1-Newbie
(To: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

View solution in original post

2 REPLIES 2
prathi
1-Newbie
(To: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

yinjin
14-Alexandrite
(To:prathi)

Thanks 

Top Tags