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

admin

125.  在TC11.x下如何查找特定审批人未完成的执行签发任务
$ j% `# f/ r- f工作流附件的存储方式在 TC11.x以及后续版本下发生了变化,如下可以看到已经被声明不
支持.
8 _4 o. }9 D! }, y3 X" ^! |8 g
签发附件现在是作为关系引用的次对象，EPMTask作为关系引用的主对象。新的查询如
" P5 n- c; T) ^5 R6 Z, x下：
; x/ \3 [8 k# WObject_type is EPMPerformSignoffTask
State_value 4 表示未完成的任务
# D+ D. ]/ j- U$ d/ v! i* U3 K7 P4 c查询脚本如下，可以导入Teamcenter查询构建器
<?xml version="1.0" encoding="utf-8"?>
<!-- GENERATED BY: PLM XML SDK 7.0.4.411 -->
' _) \0 C2 W( v+ s8 s, |! U<plmxml_bus:PLMXMLBusinessTypes
& B- G3 v6 v4 p% d  q  ?xmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"
7 P. n$ K; j3 E- U4 cxmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema"
language="en-us" time="14:44:55" schemaVersion="6" author="Teamcenter
! B1 U7 i5 G  p- d$ VV11000.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">
6 n0 z. S$ |+ G2 w) i<plmxml_bus:SavedQueryDef id="id1" name="Find unfinished perform signoff task"
nameRef="#id2" queryFlag="0" queryClass="EPMTask">
8 r( d0 l+ a9 M0 L<ApplicationRef application="Teamcenter" label="BLUhF49HIPhsCA"
version="BLUhF49HIPhsCA"></ApplicationRef>
3 [' o3 y% P# A3 }<plmxml_bus:QueryClause id="id3" stringValue="SELECT qid FROM EPMTask WHERE
' g( k0 ~1 b8 P2 x"ImanRelation<-
8 z; l6 L, ]# r2 `0 Vprimary_object.Signoff:secondary_object.group_member.User:user.user_id" =
  p4 {) A1 ]4 p+ Q- y"${user_id = }" AND "object_type" = "${object_type =
/ K4 K" ~- |; ]1 xEPMPerformSignoffTask}" AND "state_value" = "${state_value =
# G7 U) W4 X  L% j2 X0 I4}""></plmxml_bus:QueryClause></plmxml_bus:SavedQueryDef>
<plmxml_bus:Text id="id2" primary="enus"></
9 `- S8 t9 D. Y2 r2 l2 y, n, W9 Xplmxml_bus:Text></plmxml_bus:PLMXMLBusinessTypes>

* Z$ ~3 s! w0 |. }2 F6 z  P