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

admin

125.  在TC11.x下如何查找特定审批人未完成的执行签发任务
工作流附件的存储方式在 TC11.x以及后续版本下发生了变化,如下可以看到已经被声明不
支持.
- P# i2 ?! }. e5 n( E6 z$ }4 ~
签发附件现在是作为关系引用的次对象，EPMTask作为关系引用的主对象。新的查询如
- r+ l9 _6 d! p下：
7 }  u9 ]/ x# t! l, j7 F8 a. Z' ?Object_type is EPMPerformSignoffTask
State_value 4 表示未完成的任务
查询脚本如下，可以导入Teamcenter查询构建器
* ^1 r( _2 g: D3 G/ X5 A& j3 C! s<?xml version="1.0" encoding="utf-8"?>
  O0 a& d. k- h! ?3 O<!-- GENERATED BY: PLM XML SDK 7.0.4.411 -->
3 C* w7 {; C9 _: i4 e<plmxml_bus:PLMXMLBusinessTypes
9 x) x/ \5 t9 o1 x- w0 ]* gxmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"
- V' |+ H5 `% C; _9 ^- wxmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema"
  q3 S$ y. z0 ^' b% [language="en-us" time="14:44:55" schemaVersion="6" author="Teamcenter
! ]5 [  c- U% R7 k* |8 ?6 FV11000.2.2.20_20160504.00 - demo@IMC--1942934752(-1942934752)" date="2016-12-15"
5 c# U/ S- k3 [; ^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">
<plmxml_bus:SavedQueryDef id="id1" name="Find unfinished perform signoff task"
' k% u% `1 X  f4 a: T  |0 v7 _2 LnameRef="#id2" queryFlag="0" queryClass="EPMTask">
<ApplicationRef application="Teamcenter" label="BLUhF49HIPhsCA"
version="BLUhF49HIPhsCA"></ApplicationRef>
' @* e! s' V) z  a3 @<plmxml_bus:QueryClause id="id3" stringValue="SELECT qid FROM EPMTask WHERE
' t6 V- F1 ^, q* H1 t. d"ImanRelation<-
. d7 w" F2 s* g, z; I) Iprimary_object.Signoff:secondary_object.group_member.User:user.user_id" =
"${user_id = }" AND "object_type" = "${object_type =
EPMPerformSignoffTask}" AND "state_value" = "${state_value =
( W  w$ S2 f5 A4}""></plmxml_bus:QueryClause></plmxml_bus:SavedQueryDef>
<plmxml_bus:Text id="id2" primary="enus"></
) L3 N, P% U7 N6 ~plmxml_bus:Text></plmxml_bus:PLMXMLBusinessTypes>
2 p3 t+ S) h+ c- z