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

admin

125.  在TC11.x下如何查找特定审批人未完成的执行签发任务
$ X4 a' x7 d8 c: U工作流附件的存储方式在 TC11.x以及后续版本下发生了变化,如下可以看到已经被声明不
支持.
. Z2 [* C# D  s9 ]6 w( [/ }
' a* A9 r* ?. |3 V: r: Q签发附件现在是作为关系引用的次对象，EPMTask作为关系引用的主对象。新的查询如
+ X6 y9 u5 N( H$ [下：
Object_type is EPMPerformSignoffTask
State_value 4 表示未完成的任务
查询脚本如下，可以导入Teamcenter查询构建器
<?xml version="1.0" encoding="utf-8"?>
<!-- GENERATED BY: PLM XML SDK 7.0.4.411 -->
+ t/ U0 t8 q1 j- a( |+ N<plmxml_bus:PLMXMLBusinessTypes
1 Q5 O) G# M, e# \8 M! A7 G9 Fxmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"
xmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema"
language="en-us" time="14:44:55" schemaVersion="6" author="Teamcenter
! a' P9 b7 \/ r. xV11000.2.2.20_20160504.00 - demo@IMC--1942934752(-1942934752)" date="2016-12-15"
% g% X0 e5 D, q- ?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">
( T! I5 ~$ Y3 S! a* m<plmxml_bus:SavedQueryDef id="id1" name="Find unfinished perform signoff task"
nameRef="#id2" queryFlag="0" queryClass="EPMTask">
. @( q& N$ o# ]3 G$ ?, _% c<ApplicationRef application="Teamcenter" label="BLUhF49HIPhsCA"
: K- ^( O7 E3 U- E1 O, Qversion="BLUhF49HIPhsCA"></ApplicationRef>
% {5 g+ E/ d2 p  W  u<plmxml_bus:QueryClause id="id3" stringValue="SELECT qid FROM EPMTask WHERE
"ImanRelation<-
: i. [7 f) b; [( Kprimary_object.Signoff:secondary_object.group_member.User:user.user_id" =
"${user_id = }" AND "object_type" = "${object_type =
EPMPerformSignoffTask}" AND "state_value" = "${state_value =
, ]9 m$ h9 M/ d3 d+ d4}""></plmxml_bus:QueryClause></plmxml_bus:SavedQueryDef>
<plmxml_bus:Text id="id2" primary="enus"></
plmxml_bus:Text></plmxml_bus:PLMXMLBusinessTypes>
( ?, N4 Y4 Z6 j8 {* C6 Q6 P