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

admin

125.  在TC11.x下如何查找特定审批人未完成的执行签发任务
工作流附件的存储方式在 TC11.x以及后续版本下发生了变化,如下可以看到已经被声明不
2 k, ~, ~0 i+ n  R  n% w4 B支持.

) H2 S" h* t2 ]. j. i, V" E* e( S- j签发附件现在是作为关系引用的次对象，EPMTask作为关系引用的主对象。新的查询如
2 t0 I/ n8 O+ I' ~0 C3 _4 ]下：
) v- S& E+ Y9 S6 @% {Object_type is EPMPerformSignoffTask
State_value 4 表示未完成的任务
查询脚本如下，可以导入Teamcenter查询构建器
; D0 s/ T/ X( r% |/ }<?xml version="1.0" encoding="utf-8"?>
6 C# r! e( D6 Y* ^" Q% W<!-- GENERATED BY: PLM XML SDK 7.0.4.411 -->
4 O+ F  ~  {/ |3 a: C& C<plmxml_bus:PLMXMLBusinessTypes
) {# T7 s. s, p1 e: r2 _- Cxmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"
xmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema"
language="en-us" time="14:44:55" schemaVersion="6" author="Teamcenter
V11000.2.2.20_20160504.00 - demo@IMC--1942934752(-1942934752)" date="2016-12-15"
- m, p' m7 s/ v( Rlanguages="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">
( z3 _- S, `0 P" W+ U<plmxml_bus:SavedQueryDef id="id1" name="Find unfinished perform signoff task"
nameRef="#id2" queryFlag="0" queryClass="EPMTask">
4 z( k; s7 E2 B+ O<ApplicationRef application="Teamcenter" label="BLUhF49HIPhsCA"
version="BLUhF49HIPhsCA"></ApplicationRef>
<plmxml_bus:QueryClause id="id3" stringValue="SELECT qid FROM EPMTask WHERE
' `. W5 H9 m7 F% J"ImanRelation<-
, S3 i% Y! H0 a, Yprimary_object.Signoff:secondary_object.group_member.User:user.user_id" =
' v$ D) D6 J& F# p"${user_id = }" AND "object_type" = "${object_type =
EPMPerformSignoffTask}" AND "state_value" = "${state_value =
6 h: d, a. y2 L  f4}""></plmxml_bus:QueryClause></plmxml_bus:SavedQueryDef>
<plmxml_bus:Text id="id2" primary="enus"></
9 R# y0 l1 ^9 I4 Q! ]+ H+ ?, iplmxml_bus:Text></plmxml_bus:PLMXMLBusinessTypes>
6 _1 \) z% b& T
. {- Y, u% y+ V2 v6 K2 }