在Oracle中查询CAD文档和部件间的关联关系

来源：互联网发布：外贸b2c建站编辑：程序博客网时间：2024/09/21 09:20

EPMBUILDHISTORY

select em.documentnumber, e.versionida2versioninfo||'.'||e.iterationida2iterationinfo as epmversion, pm.wtpartnumber, p.versionida2versioninfo||'.'||p.iterationida2iterationinfo as partversion, ebh.buildtypefrom epmdocumentmaster em, epmdocument e, wtpartmaster pm, wtpart p, epmbuildhistory ebhwhere e.ida3masterreference=em.ida2a2and p.ida3masterreference=pm.ida2a2and ebh.ida3a5=e.ida2a2and ebh.ida3b5=p.ida2a2

EPMBUILDRULE

select em.documentnumber, e.versionida2versioninfo||'.'||e.iterationida2iterationinfo as epmversion, pm.wtpartnumber, p.versionida2versioninfo||'.'||p.iterationida2iterationinfo as partversion, ebr.buildtypefrom epmdocumentmaster em, epmdocument e, wtpartmaster pm, wtpart p, epmbuildrule ebrwhere e.ida3masterreference=em.ida2a2and p.ida3masterreference=pm.ida2a2and ebr.branchida3a5=e.branchiditerationinfoand ebr.branchida3b5=p.branchiditerationinfo

EPMBUILDRULEASSOCIATIONLINK

select em.documentnumber, e.versionida2versioninfo||'.'||e.iterationida2iterationinfo as epmversion, pm.wtpartnumber, p.versionida2versioninfo||'.'||p.iterationida2iterationinfo as partversion, ebral.buildtypefrom epmdocumentmaster em, epmdocument e, wtpartmaster pm, wtpart p, epmbuildruleassociationlink ebralwhere e.ida3masterreference=em.ida2a2and p.ida3masterreference=pm.ida2a2and ebral.ida3a5=e.ida2a2and ebral.ida3b5=p.ida2a2

EPMDESCRIBELINK

select em.documentnumber, e.versionida2versioninfo||'.'||e.iterationida2iterationinfo as epmversion, pm.wtpartnumber, p.versionida2versioninfo||'.'||p.iterationida2iterationinfo as partversionfrom epmdocumentmaster em, epmdocument e, wtpartmaster pm, wtpart p, epmdescribelink edlwhere e.ida3masterreference=em.ida2a2and p.ida3masterreference=pm.ida2a2and edl.ida3b5=e.ida2a2and edl.ida3a5=p.ida2a2

在Creo中检入模型时，如果模型已有关联部件或勾选了"Auto Associate Parts to CAD Documents"，那么检入时会自动Build关联部件，Build的作用包括驱动部件结构以及传递Common Attributes，即Creo模型中映射好的参数会显示在关联部件的Common Attributes布局中。

如果Build出现问题，希望通过MethodServer日志排查问题原因，需要设置log4j日志级别，具体操作为：

修改%WT_HOME%\codebase\WEB-INF\log4jMethodServer.properties文件，中添加如下行：
log4j.logger.wt.build=ALL
log4j.logger.wt.epm.build=ALL
等待5分钟（其实不用这么久）后即可生效