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

admin

125.  在TC11.x下如何查找特定审批人未完成的执行签发任务
( w' T8 d: Z, H" q& k+ {工作流附件的存储方式在 TC11.x以及后续版本下发生了变化,如下可以看到已经被声明不
支持.

签发附件现在是作为关系引用的次对象，EPMTask作为关系引用的主对象。新的查询如
3 c- p  t4 R5 }1 k下：
Object_type is EPMPerformSignoffTask
  P  a1 ?3 Q2 E) V$ Y. hState_value 4 表示未完成的任务
# Q9 D/ J, ~" ?& P9 B) q' i9 _3 N查询脚本如下，可以导入Teamcenter查询构建器
8 t1 U  T4 o7 T) C, r! r8 ]<?xml version="1.0" encoding="utf-8"?>
<!-- GENERATED BY: PLM XML SDK 7.0.4.411 -->
<plmxml_bus:PLMXMLBusinessTypes
6 b. v. y* A; O; o1 I  |xmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"
4 A3 K7 o9 X5 l% W% k/ |9 _% Axmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema"
  v2 E+ P6 Z) ?6 ]- N7 M6 a6 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"
9 A0 F$ f6 O% }% S0 X& glanguages="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 y" o4 R& g1 P; T5 ]& b<plmxml_bus:SavedQueryDef id="id1" name="Find unfinished perform signoff task"
nameRef="#id2" queryFlag="0" queryClass="EPMTask">
, d5 C+ L' u0 z8 l2 R<ApplicationRef application="Teamcenter" label="BLUhF49HIPhsCA"
6 W: F4 ~2 k6 A" A* n" Hversion="BLUhF49HIPhsCA"></ApplicationRef>
<plmxml_bus:QueryClause id="id3" stringValue="SELECT qid FROM EPMTask WHERE
"ImanRelation<-
primary_object.Signoff:secondary_object.group_member.User:user.user_id" =
) |( ^4 J  V4 M" o/ P"${user_id = }" AND "object_type" = "${object_type =
! x5 I; q, C, K+ vEPMPerformSignoffTask}" AND "state_value" = "${state_value =
* c% n' b- I( k- O4}""></plmxml_bus:QueryClause></plmxml_bus:SavedQueryDef>
<plmxml_bus:Text id="id2" primary="enus"></
: D4 F  f! s/ |plmxml_bus:Text></plmxml_bus:PLMXMLBusinessTypes>

! R2 h7 M& T* [! g- Q& \, `