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

admin

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

( Y2 B3 l5 Q# i5 \2 j4 Y& H+ [签发附件现在是作为关系引用的次对象，EPMTask作为关系引用的主对象。新的查询如
/ _8 X$ [5 k9 L% Q  `8 r下：
Object_type is EPMPerformSignoffTask
8 |$ H, ^2 V8 r! q' aState_value 4 表示未完成的任务
* |1 S+ M* I: _0 ^6 G- m' D查询脚本如下，可以导入Teamcenter查询构建器
<?xml version="1.0" encoding="utf-8"?>
* W" \( {) U0 h; {<!-- GENERATED BY: PLM XML SDK 7.0.4.411 -->
<plmxml_bus:PLMXMLBusinessTypes
xmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"
) c* a: X! U  W5 hxmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema"
language="en-us" time="14:44:55" schemaVersion="6" author="Teamcenter
( e1 D3 n6 C4 y" \. e% j5 YV11000.2.2.20_20160504.00 - demo@IMC--1942934752(-1942934752)" date="2016-12-15"
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">
& G. ?- F$ V3 @+ G0 a) w3 H4 u' T9 J<plmxml_bus:SavedQueryDef id="id1" name="Find unfinished perform signoff task"
. A& J4 w; g% V* C+ d: M% cnameRef="#id2" queryFlag="0" queryClass="EPMTask">
5 G: i- K/ \- i7 d5 c* q2 K<ApplicationRef application="Teamcenter" label="BLUhF49HIPhsCA"
6 q4 M" g" P, i! o- f1 lversion="BLUhF49HIPhsCA"></ApplicationRef>
<plmxml_bus:QueryClause id="id3" stringValue="SELECT qid FROM EPMTask WHERE
8 R) a# F& x# P5 J' X* y9 x"ImanRelation<-
primary_object.Signoff:secondary_object.group_member.User:user.user_id" =
"${user_id = }" AND "object_type" = "${object_type =
EPMPerformSignoffTask}" AND "state_value" = "${state_value =
3 c; ^4 d0 S" l: H3 O8 A$ ?4}""></plmxml_bus:QueryClause></plmxml_bus:SavedQueryDef>
" q+ R; o; u) s# r<plmxml_bus:Text id="id2" primary="enus"></
- t! @& m/ J- _( n2 u3 r; |2 Tplmxml_bus:Text></plmxml_bus:PLMXMLBusinessTypes>

3 S- h: j3 V/ B7 ]  y" v( N