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

admin

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

: G2 }2 k/ H# P6 F( K1 i& m3 S签发附件现在是作为关系引用的次对象，EPMTask作为关系引用的主对象。新的查询如
; A. |6 ]+ A) f1 c  w5 R0 d( F下：
Object_type is EPMPerformSignoffTask
# |* w! f9 x( a: k% [State_value 4 表示未完成的任务
查询脚本如下，可以导入Teamcenter查询构建器
<?xml version="1.0" encoding="utf-8"?>
& u$ p" y1 K# \8 q$ M/ H4 P<!-- GENERATED BY: PLM XML SDK 7.0.4.411 -->
' S$ [8 r. V  j: m<plmxml_bus:PLMXMLBusinessTypes
9 Q" l( ]( \9 Yxmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"
) F8 G7 i3 S* i' I2 I  G( Pxmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema"
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">
<plmxml_bus:SavedQueryDef id="id1" name="Find unfinished perform signoff task"
nameRef="#id2" queryFlag="0" queryClass="EPMTask">
<ApplicationRef application="Teamcenter" label="BLUhF49HIPhsCA"
0 {* N# s* I6 O& T) n5 m2 p* Dversion="BLUhF49HIPhsCA"></ApplicationRef>
<plmxml_bus:QueryClause id="id3" stringValue="SELECT qid FROM EPMTask WHERE
" S3 R( }: w7 ?" i2 }, l8 J"ImanRelation<-
primary_object.Signoff:secondary_object.group_member.User:user.user_id" =
/ q. e1 b6 w! }0 P"${user_id = }" AND "object_type" = "${object_type =
3 ~5 q/ ?5 h! b" B( u6 LEPMPerformSignoffTask}" AND "state_value" = "${state_value =
3 m6 z: D2 B# R0 Q0 |4 V4}""></plmxml_bus:QueryClause></plmxml_bus:SavedQueryDef>
<plmxml_bus:Text id="id2" primary="enus"></
; M4 A# O4 m0 I4 @' U: gplmxml_bus:Text></plmxml_bus:PLMXMLBusinessTypes>

( z, H# Y  h  d1 C9 u" H8 D" a  Y