125. 在TC11.x下如何查找特定审批人未完成的执行签发任务

admin

125.  在TC11.x下如何查找特定审批人未完成的执行签发任务
工作流附件的存储方式在 TC11.x以及后续版本下发生了变化,如下可以看到已经被声明不
; N. x/ t8 t! |! G支持.

6 m* F" }( ]8 {签发附件现在是作为关系引用的次对象，EPMTask作为关系引用的主对象。新的查询如
7 Y1 ^! p* D6 {# `/ }' Z' ]" z2 U下：
Object_type is EPMPerformSignoffTask
State_value 4 表示未完成的任务
3 s. W5 t2 V& J) u3 O; e4 v$ l; c& r查询脚本如下，可以导入Teamcenter查询构建器
<?xml version="1.0" encoding="utf-8"?>
<!-- GENERATED BY: PLM XML SDK 7.0.4.411 -->
<plmxml_bus:PLMXMLBusinessTypes
xmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"
+ }! a9 v6 i, i1 F0 W+ C4 s  l1 nxmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema"
6 I9 ^( H# k) }$ h2 e/ G7 B; Ylanguage="en-us" time="14:44:55" schemaVersion="6" author="Teamcenter
' e7 W/ A4 b, iV11000.2.2.20_20160504.00 - demo@IMC--1942934752(-1942934752)" date="2016-12-15"
9 h) T) \6 T7 v  u1 B- Zlanguages="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">
<plmxml_bus:SavedQueryDef id="id1" name="Find unfinished perform signoff task"
2 e8 O$ @0 W8 ^- y; A& k4 i" `nameRef="#id2" queryFlag="0" queryClass="EPMTask">
+ X2 Y" h' b0 A+ I) ~$ r<ApplicationRef application="Teamcenter" label="BLUhF49HIPhsCA"
version="BLUhF49HIPhsCA"></ApplicationRef>
<plmxml_bus:QueryClause id="id3" stringValue="SELECT qid FROM EPMTask WHERE
4 N+ M7 v, z5 N1 q"ImanRelation<-
7 J8 @) S& U* G* c6 M: pprimary_object.Signoff:secondary_object.group_member.User:user.user_id" =
( z, |: O- ?, A$ w( g& O, n' K"${user_id = }" AND "object_type" = "${object_type =
  M  H8 E! N) J) b! a' ^% K1 q, LEPMPerformSignoffTask}" AND "state_value" = "${state_value =
: P6 G" k+ O8 W* X) K& ?4}""></plmxml_bus:QueryClause></plmxml_bus:SavedQueryDef>
- G9 b. @2 X/ J<plmxml_bus:Text id="id2" primary="enus"></
( C/ J3 l  H" ?$ d* pplmxml_bus:Text></plmxml_bus:PLMXMLBusinessTypes>
6 u  K7 j- A. _/ X# U% T3 ^) C3 ?' i
# s6 N1 z) m7 t7 ^( I- r