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

admin

125.  在TC11.x下如何查找特定审批人未完成的执行签发任务
0 }! n, c+ g. r- x: w: f工作流附件的存储方式在 TC11.x以及后续版本下发生了变化,如下可以看到已经被声明不
4 x) M* e. G9 d. m9 A+ b支持.

# M' L2 }0 W6 Y- V1 s/ u' R签发附件现在是作为关系引用的次对象，EPMTask作为关系引用的主对象。新的查询如
下：
' ~6 A, A7 F& _3 v7 d( DObject_type is EPMPerformSignoffTask
; j. Y1 L: }9 N# l4 Y" V& ZState_value 4 表示未完成的任务
查询脚本如下，可以导入Teamcenter查询构建器
/ ?' ]0 D. H$ r- K6 S% H<?xml version="1.0" encoding="utf-8"?>
( H' ^( U5 K3 s/ b" {<!-- GENERATED BY: PLM XML SDK 7.0.4.411 -->
<plmxml_bus:PLMXMLBusinessTypes
2 ]: [3 l7 ]) J" H6 v5 ~! Qxmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"
& c. t8 P2 y, |  w% Wxmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema"
3 c: j' F2 J" X# T# j7 Q0 ilanguage="en-us" time="14:44:55" schemaVersion="6" author="Teamcenter
: R6 C8 l+ F  j8 C, LV11000.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">
2 _. ^  l" u) R! L<plmxml_bus:SavedQueryDef id="id1" name="Find unfinished perform signoff task"
1 G3 E; i, i. G* fnameRef="#id2" queryFlag="0" queryClass="EPMTask">
<ApplicationRef application="Teamcenter" label="BLUhF49HIPhsCA"
version="BLUhF49HIPhsCA"></ApplicationRef>
  C9 F  x& r: y; H<plmxml_bus:QueryClause id="id3" stringValue="SELECT qid FROM EPMTask WHERE
"ImanRelation<-
! l3 u  G! x; c5 X, Nprimary_object.Signoff:secondary_object.group_member.User:user.user_id" =
) ]/ e* m0 n0 ~# U"${user_id = }" AND "object_type" = "${object_type =
EPMPerformSignoffTask}" AND "state_value" = "${state_value =
$ O0 r+ }; t5 @  `+ ~4}""></plmxml_bus:QueryClause></plmxml_bus:SavedQueryDef>
<plmxml_bus:Text id="id2" primary="enus"></
plmxml_bus:Text></plmxml_bus:PLMXMLBusinessTypes>
2 v1 p  F; W: d8 v1 N. P! ?
/ Q' ~9 x2 \5 H- N  g