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

admin

125.  在TC11.x下如何查找特定审批人未完成的执行签发任务
; A6 C# V# ?4 ?% Q" w+ x; E工作流附件的存储方式在 TC11.x以及后续版本下发生了变化,如下可以看到已经被声明不
1 f' {9 ^% K- K6 a支持.
5 H# W/ L! X, ]$ m" U$ Z& q6 C4 [
( h. V1 P5 P! X& X签发附件现在是作为关系引用的次对象，EPMTask作为关系引用的主对象。新的查询如
下：
Object_type is EPMPerformSignoffTask
4 J$ s( f+ T' uState_value 4 表示未完成的任务
% _' n6 h& h0 U8 I查询脚本如下，可以导入Teamcenter查询构建器
9 v5 |+ @8 h* o5 W<?xml version="1.0" encoding="utf-8"?>
3 F  n/ j% U* T) b  u<!-- GENERATED BY: PLM XML SDK 7.0.4.411 -->
<plmxml_bus:PLMXMLBusinessTypes
/ z& n) }8 h" C% C6 K" Txmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"
2 X( Q3 U9 \* Y) o4 Lxmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema"
- Z/ k- a) z+ j- R2 V8 k, ?, Planguage="en-us" time="14:44:55" schemaVersion="6" author="Teamcenter
V11000.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">
* i, ~& \. w  U4 i+ h/ h  L<plmxml_bus:SavedQueryDef id="id1" name="Find unfinished perform signoff task"
$ W( b" s2 g7 h. L2 r  L) ZnameRef="#id2" queryFlag="0" queryClass="EPMTask">
. n. d& ~% G/ x/ J<ApplicationRef application="Teamcenter" label="BLUhF49HIPhsCA"
5 Z6 j0 _4 p/ n- g4 c$ vversion="BLUhF49HIPhsCA"></ApplicationRef>
: ^8 D1 p0 O8 t% [; q% T# {% V3 @<plmxml_bus:QueryClause id="id3" stringValue="SELECT qid FROM EPMTask WHERE
"ImanRelation<-
primary_object.Signoff:secondary_object.group_member.User:user.user_id" =
* l& \6 o4 s2 m6 h( j! r"${user_id = }" AND "object_type" = "${object_type =
EPMPerformSignoffTask}" AND "state_value" = "${state_value =
4}""></plmxml_bus:QueryClause></plmxml_bus:SavedQueryDef>
: R' D$ k2 l) ~<plmxml_bus:Text id="id2" primary="enus"></
. P9 L5 c% }& t0 i# M, Oplmxml_bus:Text></plmxml_bus:PLMXMLBusinessTypes>

4 F* q7 D% z, B. B: @2 D