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

admin

125.  在TC11.x下如何查找特定审批人未完成的执行签发任务
6 ]+ E/ C$ j6 H工作流附件的存储方式在 TC11.x以及后续版本下发生了变化,如下可以看到已经被声明不
支持.

1 E( t6 J$ n$ Q: m4 T3 C签发附件现在是作为关系引用的次对象，EPMTask作为关系引用的主对象。新的查询如
下：
Object_type is EPMPerformSignoffTask
* F- ?- k9 s$ f) u2 k. lState_value 4 表示未完成的任务
6 w% ?) B4 `9 V查询脚本如下，可以导入Teamcenter查询构建器
; V8 l# Y) \5 y$ g6 F3 R<?xml version="1.0" encoding="utf-8"?>
/ V+ {- i9 t% K<!-- GENERATED BY: PLM XML SDK 7.0.4.411 -->
<plmxml_bus:PLMXMLBusinessTypes
xmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"
/ G8 a- a" J2 txmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema"
* v& p7 U5 Q' Z6 t2 W9 i. ulanguage="en-us" time="14:44:55" schemaVersion="6" author="Teamcenter
1 u: W( K! t* jV11000.2.2.20_20160504.00 - demo@IMC--1942934752(-1942934752)" date="2016-12-15"
9 T2 r) @- ~  I; }7 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"
$ W2 D  m' W: t1 VnameRef="#id2" queryFlag="0" queryClass="EPMTask">
- w1 L3 A2 ]1 v7 S<ApplicationRef application="Teamcenter" label="BLUhF49HIPhsCA"
* c5 M3 Y9 l2 Hversion="BLUhF49HIPhsCA"></ApplicationRef>
1 H0 A- E. E2 H<plmxml_bus:QueryClause id="id3" stringValue="SELECT qid FROM EPMTask WHERE
  x3 S. z' ^& o+ W4 F"ImanRelation<-
0 X% G4 e5 B* Y, {. z! `primary_object.Signoff:secondary_object.group_member.User:user.user_id" =
' ]  G6 D# R; E: [! `2 w"${user_id = }" AND "object_type" = "${object_type =
7 F: F, |, r/ n6 o/ z: H( zEPMPerformSignoffTask}" AND "state_value" = "${state_value =
4}""></plmxml_bus:QueryClause></plmxml_bus:SavedQueryDef>
" `  o9 L% M  l6 J# H+ D$ w4 O<plmxml_bus:Text id="id2" primary="enus"></
3 O% x( ?3 d/ ], W) O1 f9 Zplmxml_bus:Text></plmxml_bus:PLMXMLBusinessTypes>

8 _, Q, S" H. H* @" Z5 D7 Y( ^