|
请使用QQ关联注册PLM之家,学习更多关于内容,更多精彩原创视频供你学习!
您需要 登录 才可以下载或查看,没有账号?注册
x
125. 在TC11.x下如何查找特定审批人未完成的执行签发任务* i9 C' h+ P' W( A. r; y6 n
工作流附件的存储方式在 TC11.x以及后续版本下发生了变化,如下可以看到已经被声明不
{/ g. }( A& y0 b: U4 \支持.8 d9 c* K9 z8 v& z C6 `" M
, y# H3 C+ D7 V; N0 [$ {签发附件现在是作为关系引用的次对象,EPMTask作为关系引用的主对象。新的查询如' N) k1 v) ^9 \, |+ a8 S. [
下:" l! L3 N6 O% w @# [6 R* N; W
Object_type is EPMPerformSignoffTask
+ D, R, x. a9 fState_value 4 表示未完成的任务
. j5 V# R- u+ E( q3 ]. h查询脚本如下,可以导入Teamcenter查询构建器
+ ]* W- ]2 \9 {<?xml version="1.0" encoding="utf-8"?>, \6 t5 {# F }7 ]! ]
<!-- GENERATED BY: PLM XML SDK 7.0.4.411 -->+ Z$ P F5 \0 a5 o0 o! U
<plmxml_bus:PLMXMLBusinessTypes
# `, g. c8 [) r& gxmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"+ T8 k: q! W0 h9 ]7 _
xmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema"5 k% v5 k) V0 ~, K
language="en-us" time="14:44:55" schemaVersion="6" author="Teamcenter5 }7 W% h+ u% Q+ q
V11000.2.2.20_20160504.00 - demo@IMC--1942934752(-1942934752)" date="2016-12-15"# f' \# E4 U* q. F1 `
languages="cs-cz de-de en-us es-es fr-fr it-it ja-jp ko-kr pl-pl pt-br ru-ru zh-cn zh-tw">8 U6 t/ i q4 f% N
<plmxml_bus:SavedQueryDef id="id1" name="Find unfinished perform signoff task"( x( I& g a5 w b
nameRef="#id2" queryFlag="0" queryClass="EPMTask">% a2 H% D8 a# q6 N; q$ y' Z* {1 V
<ApplicationRef application="Teamcenter" label="BLUhF49HIPhsCA"
! g- V: `7 P- e6 T/ Z$ |, b9 C L Rversion="BLUhF49HIPhsCA"></ApplicationRef>/ ]4 T. K. _( O8 ?8 b
<plmxml_bus:QueryClause id="id3" stringValue="SELECT qid FROM EPMTask WHERE3 g0 g0 v$ p- Y9 C; ^& T. F
"ImanRelation<-% i# n* B3 l7 P6 ?4 v
primary_object.Signoff:secondary_object.group_member.User:user.user_id" =) h) h. S' G! ]) f
"${user_id = }" AND "object_type" = "${object_type =8 D: H& u, o! t: _6 Y
EPMPerformSignoffTask}" AND "state_value" = "${state_value =
: H! a! ~. q+ v3 A( l4}""></plmxml_bus:QueryClause></plmxml_bus:SavedQueryDef>. Y! \* z& T$ W1 b) z
<plmxml_bus:Text id="id2" primary="enus"></$ p! n) `- n1 `7 Z
plmxml_bus:Text></plmxml_bus:PLMXMLBusinessTypes>
! J1 I# Q1 u: L# l. d) J
* p: f* n6 B% m2 r/ m8 o |
|