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

admin

125.  在TC11.x下如何查找特定审批人未完成的执行签发任务
工作流附件的存储方式在 TC11.x以及后续版本下发生了变化,如下可以看到已经被声明不
支持.
" q% D! [' \' R5 e: h
签发附件现在是作为关系引用的次对象，EPMTask作为关系引用的主对象。新的查询如
! [. a! N( t7 h: Z下：
" J9 Y7 H7 i" Y. _Object_type is EPMPerformSignoffTask
2 D  ^8 ~' l1 L$ `: G5 kState_value 4 表示未完成的任务
查询脚本如下，可以导入Teamcenter查询构建器
<?xml version="1.0" encoding="utf-8"?>
<!-- GENERATED BY: PLM XML SDK 7.0.4.411 -->
7 b/ Z6 G2 S. N+ E2 Y<plmxml_bus:PLMXMLBusinessTypes
0 c: z; e: M: I8 o1 mxmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"
7 |- w  P/ V3 b! K9 k( wxmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema"
7 l9 m7 d8 m; Z7 k2 h/ }1 F  r/ klanguage="en-us" time="14:44:55" schemaVersion="6" author="Teamcenter
V11000.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">
& k5 r) c; T; K<plmxml_bus:SavedQueryDef id="id1" name="Find unfinished perform signoff task"
nameRef="#id2" queryFlag="0" queryClass="EPMTask">
<ApplicationRef application="Teamcenter" label="BLUhF49HIPhsCA"
; B. L  e5 C: _- x4 Vversion="BLUhF49HIPhsCA"></ApplicationRef>
# P, O7 `" k! s/ A0 [: ^<plmxml_bus:QueryClause id="id3" stringValue="SELECT qid FROM EPMTask WHERE
"ImanRelation<-
primary_object.Signoff:secondary_object.group_member.User:user.user_id" =
8 X! B$ D' C3 ^9 s& F7 g) ?2 O"${user_id = }" AND "object_type" = "${object_type =
EPMPerformSignoffTask}" AND "state_value" = "${state_value =
4}""></plmxml_bus:QueryClause></plmxml_bus:SavedQueryDef>
- c+ q7 o: l8 k6 R<plmxml_bus:Text id="id2" primary="enus"></
plmxml_bus:Text></plmxml_bus:PLMXMLBusinessTypes>

1 S: l. c$ T% w( _" B1 j