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

admin

125.  在TC11.x下如何查找特定审批人未完成的执行签发任务
工作流附件的存储方式在 TC11.x以及后续版本下发生了变化,如下可以看到已经被声明不
3 s- Q2 J+ e/ U! c1 a支持.
9 j8 C0 I7 `. ]; C
签发附件现在是作为关系引用的次对象，EPMTask作为关系引用的主对象。新的查询如
/ S. W! L# Y8 t/ o7 l! a下：
1 D: r" a# r, M3 d' u' Z7 n) oObject_type is EPMPerformSignoffTask
State_value 4 表示未完成的任务
" @6 ]. H: {$ s" ^6 ~9 \0 W8 ^查询脚本如下，可以导入Teamcenter查询构建器
! S2 j+ }: Y. W5 I0 I- E<?xml version="1.0" encoding="utf-8"?>
& {" |4 B  o+ g) K& g% X<!-- GENERATED BY: PLM XML SDK 7.0.4.411 -->
9 }9 C! H. L8 q/ U9 F- M* {. }<plmxml_bus:PLMXMLBusinessTypes
xmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"
xmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema"
4 n4 |. m& j4 N) H# Y$ f, Glanguage="en-us" time="14:44:55" schemaVersion="6" author="Teamcenter
2 y/ p* d+ o$ f6 O3 Y% H! v9 P4 n( cV11000.2.2.20_20160504.00 - demo@IMC--1942934752(-1942934752)" date="2016-12-15"
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"
nameRef="#id2" queryFlag="0" queryClass="EPMTask">
<ApplicationRef application="Teamcenter" label="BLUhF49HIPhsCA"
version="BLUhF49HIPhsCA"></ApplicationRef>
<plmxml_bus:QueryClause id="id3" stringValue="SELECT qid FROM EPMTask WHERE
  s( U' h9 K& H7 o"ImanRelation<-
primary_object.Signoff:secondary_object.group_member.User:user.user_id" =
"${user_id = }" AND "object_type" = "${object_type =
8 J4 T2 D' I% @1 V# WEPMPerformSignoffTask}" AND "state_value" = "${state_value =
; C4 p! ]5 A- g% z4}""></plmxml_bus:QueryClause></plmxml_bus:SavedQueryDef>
4 ]/ [5 b9 @& s. {<plmxml_bus:Text id="id2" primary="enus"></
6 J% E+ x4 k* Cplmxml_bus:Text></plmxml_bus:PLMXMLBusinessTypes>
/ I8 ]' l9 G! A
- B( x. L! ~  O/ `) Y