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

admin

125.  在TC11.x下如何查找特定审批人未完成的执行签发任务
* T4 m, V5 b/ Y. n工作流附件的存储方式在 TC11.x以及后续版本下发生了变化,如下可以看到已经被声明不
9 t, P+ y7 n# A支持.
) {" t# H8 l# R6 w
签发附件现在是作为关系引用的次对象，EPMTask作为关系引用的主对象。新的查询如
" g9 i" w, _. o) A# H下：
Object_type is EPMPerformSignoffTask
' ]' g( Y. H4 s" Y0 v$ f, w  @State_value 4 表示未完成的任务
( E+ x6 w0 Y- b5 w  w查询脚本如下，可以导入Teamcenter查询构建器
% ^: h$ y7 A7 @6 R<?xml version="1.0" encoding="utf-8"?>
* |* m) }- C  i6 s  E. d' K<!-- GENERATED BY: PLM XML SDK 7.0.4.411 -->
<plmxml_bus:PLMXMLBusinessTypes
3 J8 @; h) @/ p- txmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"
xmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema"
! d( u* t! W! J$ H+ }% h. Y/ {language="en-us" time="14:44:55" schemaVersion="6" author="Teamcenter
, c* S; h# m/ ^/ @9 iV11000.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">
5 \$ U. O( q  ?<plmxml_bus:SavedQueryDef id="id1" name="Find unfinished perform signoff task"
/ B) A7 M  H6 X- YnameRef="#id2" queryFlag="0" queryClass="EPMTask">
3 b2 R+ b. L8 C* e" ~' l5 C<ApplicationRef application="Teamcenter" label="BLUhF49HIPhsCA"
2 D" k) c+ h! L5 lversion="BLUhF49HIPhsCA"></ApplicationRef>
* d- ?  O2 }/ j<plmxml_bus:QueryClause id="id3" stringValue="SELECT qid FROM EPMTask WHERE
"ImanRelation<-
primary_object.Signoff:secondary_object.group_member.User:user.user_id" =
; @0 K- E( S1 G9 N- L"${user_id = }" AND "object_type" = "${object_type =
EPMPerformSignoffTask}" AND "state_value" = "${state_value =
4}""></plmxml_bus:QueryClause></plmxml_bus:SavedQueryDef>
<plmxml_bus:Text id="id2" primary="enus"></
plmxml_bus:Text></plmxml_bus:PLMXMLBusinessTypes>

- G. M  p6 n0 q( h$ Q' y$ ~8 v