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

admin

125.  在TC11.x下如何查找特定审批人未完成的执行签发任务
6 [  K8 |2 i3 G7 B1 N2 R工作流附件的存储方式在 TC11.x以及后续版本下发生了变化,如下可以看到已经被声明不
支持.
& x5 l3 N; |5 T1 @
( n3 ~$ V7 ]* H6 P# k签发附件现在是作为关系引用的次对象，EPMTask作为关系引用的主对象。新的查询如
2 Y4 I( V' P. m# R8 G4 A2 \1 X下：
. Y% \5 d9 E# `! K* }8 z* _Object_type is EPMPerformSignoffTask
State_value 4 表示未完成的任务
查询脚本如下，可以导入Teamcenter查询构建器
<?xml version="1.0" encoding="utf-8"?>
  K8 K0 c  w+ B4 c: r<!-- GENERATED BY: PLM XML SDK 7.0.4.411 -->
<plmxml_bus:PLMXMLBusinessTypes
xmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"
" ]: D% z9 o. h. D. p+ p* _* Ixmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema"
/ _- T7 m, M! i& Blanguage="en-us" time="14:44:55" schemaVersion="6" author="Teamcenter
. u% ]" w+ r' M# Y* EV11000.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"
, V5 W2 C% Q- p# M% S$ D/ EnameRef="#id2" queryFlag="0" queryClass="EPMTask">
<ApplicationRef application="Teamcenter" label="BLUhF49HIPhsCA"
version="BLUhF49HIPhsCA"></ApplicationRef>
<plmxml_bus:QueryClause id="id3" stringValue="SELECT qid FROM EPMTask WHERE
; M6 I8 H4 N+ @1 ~! _"ImanRelation<-
primary_object.Signoff:secondary_object.group_member.User:user.user_id" =
6 K. [* c9 Y% _- x! v% x"${user_id = }" AND "object_type" = "${object_type =
EPMPerformSignoffTask}" AND "state_value" = "${state_value =
, E& t. B3 H! J% A7 v& x9 |. h" c4}""></plmxml_bus:QueryClause></plmxml_bus:SavedQueryDef>
<plmxml_bus:Text id="id2" primary="enus"></
+ ^% [- [. X5 ]2 b5 v0 e% zplmxml_bus:Text></plmxml_bus:PLMXMLBusinessTypes>

# T# N4 j5 |" M% A9 _5 D