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

admin

125.  在TC11.x下如何查找特定审批人未完成的执行签发任务
3 B& s' e) D' a" y5 e; _工作流附件的存储方式在 TC11.x以及后续版本下发生了变化,如下可以看到已经被声明不
+ A& j7 y" T5 [* H4 O. n3 j支持.
2 {; s( [8 z. a: u" h) C7 s
/ u6 M1 c4 F0 |签发附件现在是作为关系引用的次对象，EPMTask作为关系引用的主对象。新的查询如
- T% _1 P" z* z7 j1 W/ S  |下：
( C& M+ K9 _* [1 Y+ JObject_type is EPMPerformSignoffTask
) h. I" E7 i3 [/ gState_value 4 表示未完成的任务
1 d% G# o$ e6 F, W查询脚本如下，可以导入Teamcenter查询构建器
<?xml version="1.0" encoding="utf-8"?>
<!-- GENERATED BY: PLM XML SDK 7.0.4.411 -->
8 _, D8 Z$ q: D2 q<plmxml_bus:PLMXMLBusinessTypes
xmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"
5 p" C! W; n8 }% i6 }6 Oxmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema"
! D5 g" A7 q3 L4 r- p' alanguage="en-us" time="14:44:55" schemaVersion="6" author="Teamcenter
- P7 d$ |$ `1 J6 V# pV11000.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">
; R0 a/ `+ g. |; l3 L  R& K<plmxml_bus:SavedQueryDef id="id1" name="Find unfinished perform signoff task"
( w: ^+ I- c8 m) vnameRef="#id2" queryFlag="0" queryClass="EPMTask">
<ApplicationRef application="Teamcenter" label="BLUhF49HIPhsCA"
version="BLUhF49HIPhsCA"></ApplicationRef>
- t7 Q6 R2 N8 E2 V<plmxml_bus:QueryClause id="id3" stringValue="SELECT qid FROM EPMTask WHERE
"ImanRelation<-
7 r) r7 D/ @1 P' m8 jprimary_object.Signoff:secondary_object.group_member.User:user.user_id" =
"${user_id = }" AND "object_type" = "${object_type =
EPMPerformSignoffTask}" AND "state_value" = "${state_value =
4}""></plmxml_bus:QueryClause></plmxml_bus:SavedQueryDef>
<plmxml_bus:Text id="id2" primary="enus"></
plmxml_bus:Text></plmxml_bus:PLMXMLBusinessTypes>
  g4 {8 K0 D& U2 T& p
) s. m, C1 t8 x+ n7 S/ i' @