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

admin

125.  在TC11.x下如何查找特定审批人未完成的执行签发任务
8 g6 [5 p- A8 V  G; I0 l7 c工作流附件的存储方式在 TC11.x以及后续版本下发生了变化,如下可以看到已经被声明不
5 [- i4 O! U5 ]. b, L' x' D9 b支持.
4 t! a3 N* o( U; ~9 X; J
! y% h" y) h* a4 w# i' Q: n% [签发附件现在是作为关系引用的次对象，EPMTask作为关系引用的主对象。新的查询如
: l: A. ?8 r. p" K+ H下：
; D4 \; v7 m3 O  C4 ^$ M" oObject_type is EPMPerformSignoffTask
  x, J/ G3 k$ U: u; k/ l9 lState_value 4 表示未完成的任务
$ c  l; X# Y' {# S4 Y( P  `查询脚本如下，可以导入Teamcenter查询构建器
8 V1 W( X% x) u! @; i<?xml version="1.0" encoding="utf-8"?>
7 p7 S3 U! B3 }4 H  o' i3 H<!-- GENERATED BY: PLM XML SDK 7.0.4.411 -->
<plmxml_bus:PLMXMLBusinessTypes
+ L# y8 A# l  Pxmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"
8 L3 I. w* ?0 Z6 S! `6 F2 }$ G$ [; bxmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema"
language="en-us" time="14:44:55" schemaVersion="6" author="Teamcenter
+ ]( g0 P) \* c. `; Q* cV11000.2.2.20_20160504.00 - demo@IMC--1942934752(-1942934752)" date="2016-12-15"
3 s6 |6 Z4 K- M! F- d6 _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"
0 H' [, c& ^- L' O) rnameRef="#id2" queryFlag="0" queryClass="EPMTask">
<ApplicationRef application="Teamcenter" label="BLUhF49HIPhsCA"
3 I" S+ {9 g& G  qversion="BLUhF49HIPhsCA"></ApplicationRef>
$ z! V; {& [4 b* [! a2 ^<plmxml_bus:QueryClause id="id3" stringValue="SELECT qid FROM EPMTask WHERE
"ImanRelation<-
, Y( p/ K2 `, k/ cprimary_object.Signoff:secondary_object.group_member.User:user.user_id" =
"${user_id = }" AND "object_type" = "${object_type =
9 T; h) j& }1 E7 j; REPMPerformSignoffTask}" AND "state_value" = "${state_value =
  x4 L% g/ j( N# a, D3 I4}""></plmxml_bus:QueryClause></plmxml_bus:SavedQueryDef>
9 R" J; J: M5 E) ^6 S<plmxml_bus:Text id="id2" primary="enus"></
0 x- A7 L2 b6 o8 W2 N% s) splmxml_bus:Text></plmxml_bus:PLMXMLBusinessTypes>
2 D8 o/ [' R/ ?1 S" b