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

admin

125.  在TC11.x下如何查找特定审批人未完成的执行签发任务
; }  _% R% }- |) Y3 d; u7 Y工作流附件的存储方式在 TC11.x以及后续版本下发生了变化,如下可以看到已经被声明不
# F1 i4 ^1 O% _% D支持.
- r/ t3 I+ f5 K: G! Z2 ~
2 S% c) s7 H4 J! _6 O签发附件现在是作为关系引用的次对象，EPMTask作为关系引用的主对象。新的查询如
' `5 N, n$ j8 T. O* Y, w+ c下：
Object_type is EPMPerformSignoffTask
State_value 4 表示未完成的任务
4 Y' U, @0 B, Y4 s) I查询脚本如下，可以导入Teamcenter查询构建器
<?xml version="1.0" encoding="utf-8"?>
<!-- GENERATED BY: PLM XML SDK 7.0.4.411 -->
6 E7 X# \/ X7 B$ [. {% P* b" O<plmxml_bus:PLMXMLBusinessTypes
xmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"
xmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema"
( H+ D% ^& u( N& Z% |language="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">
) f1 s, _3 S5 _2 ~4 v/ n- t<plmxml_bus:SavedQueryDef id="id1" name="Find unfinished perform signoff task"
# K3 u' l* e2 c2 y* x3 snameRef="#id2" queryFlag="0" queryClass="EPMTask">
2 S. r; P0 o0 i. O/ F: `, U<ApplicationRef application="Teamcenter" label="BLUhF49HIPhsCA"
& a2 a: d4 K# Sversion="BLUhF49HIPhsCA"></ApplicationRef>
<plmxml_bus:QueryClause id="id3" stringValue="SELECT qid FROM EPMTask WHERE
! t+ f0 }( y  ~, s+ R"ImanRelation<-
1 O9 [& O) w( x( P2 Z8 W% Kprimary_object.Signoff:secondary_object.group_member.User:user.user_id" =
: U# D- L: m/ I7 i& v) Y  s# Y"${user_id = }" AND "object_type" = "${object_type =
EPMPerformSignoffTask}" AND "state_value" = "${state_value =
7 \  w# j( u' l4}""></plmxml_bus:QueryClause></plmxml_bus:SavedQueryDef>
( s+ ~. ?5 N" C5 m<plmxml_bus:Text id="id2" primary="enus"></
plmxml_bus:Text></plmxml_bus:PLMXMLBusinessTypes>

/ p% h" a% J, w1 J3 u