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

admin

125.  在TC11.x下如何查找特定审批人未完成的执行签发任务
工作流附件的存储方式在 TC11.x以及后续版本下发生了变化,如下可以看到已经被声明不
2 n- }/ J7 H/ c支持.
% r* V; }; E5 h" C" g
8 s  Z- M8 `' @3 K签发附件现在是作为关系引用的次对象，EPMTask作为关系引用的主对象。新的查询如
) D+ [5 ^7 K1 F* d- u. V* }7 p下：
Object_type is EPMPerformSignoffTask
State_value 4 表示未完成的任务
查询脚本如下，可以导入Teamcenter查询构建器
% z) J% d, E( p6 J; l) X2 f<?xml version="1.0" encoding="utf-8"?>
: T& _5 o4 i, I' O5 O) |<!-- GENERATED BY: PLM XML SDK 7.0.4.411 -->
) x% i* _/ @& S1 E- ]! Z<plmxml_bus:PLMXMLBusinessTypes
xmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"
4 T- j3 V4 t- w5 C( E# n6 c4 sxmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema"
. F/ _2 b9 F8 M% ]9 Nlanguage="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 b% m3 r- I8 ^  H) Blanguages="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"
  W& V% ?9 ^% |' a( QnameRef="#id2" queryFlag="0" queryClass="EPMTask">
<ApplicationRef application="Teamcenter" label="BLUhF49HIPhsCA"
version="BLUhF49HIPhsCA"></ApplicationRef>
<plmxml_bus:QueryClause id="id3" stringValue="SELECT qid FROM EPMTask WHERE
. d# V) o  d; Y$ D5 x5 [5 Y"ImanRelation<-
. P& @* B& I. x  Xprimary_object.Signoff:secondary_object.group_member.User:user.user_id" =
4 @$ a$ ?% ]+ \& s1 V"${user_id = }" AND "object_type" = "${object_type =
' l* j; A1 A) N3 a* dEPMPerformSignoffTask}" 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>