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

admin

125.  在TC11.x下如何查找特定审批人未完成的执行签发任务
* L- S  e. i3 `8 t工作流附件的存储方式在 TC11.x以及后续版本下发生了变化,如下可以看到已经被声明不
支持.
. J$ u+ j( y8 m& X/ {1 A# W2 {0 Y
" u- d- p  b0 O签发附件现在是作为关系引用的次对象，EPMTask作为关系引用的主对象。新的查询如
- _7 U0 R1 U0 G! I下：
Object_type is EPMPerformSignoffTask
# @$ n, H) f; N# X) o7 EState_value 4 表示未完成的任务
查询脚本如下，可以导入Teamcenter查询构建器
7 [! y4 Y+ \& Z; M9 B<?xml version="1.0" encoding="utf-8"?>
<!-- GENERATED BY: PLM XML SDK 7.0.4.411 -->
<plmxml_bus:PLMXMLBusinessTypes
xmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"
* L8 G! `4 @! O/ Y2 H( sxmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema"
9 D9 M/ C! z% }2 L% X# Ulanguage="en-us" time="14:44:55" schemaVersion="6" author="Teamcenter
V11000.2.2.20_20160504.00 - demo@IMC--1942934752(-1942934752)" date="2016-12-15"
( {. F; Y1 W. f, c# zlanguages="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"
nameRef="#id2" queryFlag="0" queryClass="EPMTask">
/ K* |3 d+ n0 h# m1 }( ^<ApplicationRef application="Teamcenter" label="BLUhF49HIPhsCA"
* [4 J, T! ]3 D( P: h. S- Oversion="BLUhF49HIPhsCA"></ApplicationRef>
<plmxml_bus:QueryClause id="id3" stringValue="SELECT qid FROM EPMTask WHERE
"ImanRelation<-
' Q4 {& G& N6 v5 z. }* M/ A' Cprimary_object.Signoff:secondary_object.group_member.User:user.user_id" =
5 Q6 a2 Y1 {4 J" @, P4 b"${user_id = }" AND "object_type" = "${object_type =
EPMPerformSignoffTask}" AND "state_value" = "${state_value =
4}""></plmxml_bus:QueryClause></plmxml_bus:SavedQueryDef>
* ~/ n5 u: I' Y/ B6 ^+ E1 h# ~<plmxml_bus:Text id="id2" primary="enus"></
plmxml_bus:Text></plmxml_bus:PLMXMLBusinessTypes>
/ V- s. O" e5 t2 y. m