Skip to main content
1-Visitor
February 27, 2014
Question

Windchill new CREO item Name=Number=File Name

  • February 27, 2014
  • 0 replies
  • 465 views

Has anyone found a way to set Name and Number equal to File Name for new Creo items? In our old windchill install we had triggers in the data base that did this. I know this did not come from PTC, I asked. I would think there should be a way to do this with attributes. For anyone that would like to know what the triggers are here you go.


create or replace
TRIGGER EPM_RENAME
BEFORE UPDATE OR INSERT ON EPMDOCUMENTMASTER
FOR EACH ROW
begin
:new.name := lower(:new.cadname);
:new.documentnumber := upper(:new.cadname);
end;

create or replace
TRIGGER DOC_RENAME
BEFORE UPDATE OR INSERT ON WTDOCUMENTMASTER
FOR EACH ROW
begin
:new.wtdocumentnumber := upper(:new.name);
update applicationdata set filename =:new.name where filename =:old.name;
update wtdocument set title =:new.name where title =:old.name;
end;