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

admin

125.  在TC11.x下如何查找特定审批人未完成的执行签发任务
工作流附件的存储方式在 TC11.x以及后续版本下发生了变化,如下可以看到已经被声明不
: A8 R* ~! h+ F支持.
9 D$ F3 s5 ^% ~# O8 {6 T% l
签发附件现在是作为关系引用的次对象，EPMTask作为关系引用的主对象。新的查询如
下：
Object_type is EPMPerformSignoffTask
State_value 4 表示未完成的任务
- c- R8 X* u& b6 a  n5 e查询脚本如下，可以导入Teamcenter查询构建器
% c1 b4 g' K9 a5 H$ ?6 H# ?8 V<?xml version="1.0" encoding="utf-8"?>
! N7 h6 ]" N) h9 S% U0 u' e& t<!-- GENERATED BY: PLM XML SDK 7.0.4.411 -->
1 t& j( D) n4 u<plmxml_bus:PLMXMLBusinessTypes
7 v) g3 u: \7 P# \xmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"
- o) a0 @& u1 Lxmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema"
language="en-us" time="14:44:55" schemaVersion="6" author="Teamcenter
7 I- N5 B2 P  Q  F" p6 |V11000.2.2.20_20160504.00 - demo@IMC--1942934752(-1942934752)" date="2016-12-15"
/ `" l+ {3 ^# Y0 klanguages="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( ]2 n  Q; x, p$ _: G- VnameRef="#id2" queryFlag="0" queryClass="EPMTask">
4 C! F3 N) y& B) ~5 @<ApplicationRef application="Teamcenter" label="BLUhF49HIPhsCA"
version="BLUhF49HIPhsCA"></ApplicationRef>
. R- {4 X5 _0 g: K+ i+ J<plmxml_bus:QueryClause id="id3" stringValue="SELECT qid FROM EPMTask WHERE
/ e3 X# Q5 @% v* [6 ]' }  O0 x3 t"ImanRelation<-
primary_object.Signoff:secondary_object.group_member.User:user.user_id" =
) X, |: ~$ ~4 u, w  b. n# G" _"${user_id = }" AND "object_type" = "${object_type =
EPMPerformSignoffTask}" AND "state_value" = "${state_value =
9 w3 }  d# a/ @" h# r2 l  X2 |4}""></plmxml_bus:QueryClause></plmxml_bus:SavedQueryDef>
<plmxml_bus:Text id="id2" primary="enus"></
7 {  W% G2 ^6 |6 `3 e1 z, Q3 cplmxml_bus:Text></plmxml_bus:PLMXMLBusinessTypes>

2 S) {  F+ m3 `7 n