|
|
请使用QQ关联注册PLM之家,学习更多关于内容,更多精彩原创视频供你学习!
您需要 登录 才可以下载或查看,没有账号?注册
x
125. 在TC11.x下如何查找特定审批人未完成的执行签发任务5 F: B7 q& D/ Z' a6 q- T; `6 R# O
工作流附件的存储方式在 TC11.x以及后续版本下发生了变化,如下可以看到已经被声明不$ }7 u- T) N, \" Q
支持.: S$ C, d1 E# q5 R; @: g
, [% ]" Q8 v4 C5 `1 `' P, _9 W9 l签发附件现在是作为关系引用的次对象,EPMTask作为关系引用的主对象。新的查询如* z- l; j9 C, ? T* k" B" a
下: f+ A3 d+ n( Y
Object_type is EPMPerformSignoffTask5 b7 |' H: A/ y/ j8 j' K* V
State_value 4 表示未完成的任务
; v& R% g) A3 F# T查询脚本如下,可以导入Teamcenter查询构建器
! h* o; }5 R( S. c<?xml version="1.0" encoding="utf-8"?>' P8 W" D1 j: C! ?% y4 x* O; r
<!-- GENERATED BY: PLM XML SDK 7.0.4.411 -->
( j$ u- C6 m b! d" X<plmxml_bus:PLMXMLBusinessTypes
( R/ [" [' I/ u. n4 Bxmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"
8 k$ S4 ]% e( J' P8 oxmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema"
3 D- j! m& ?# x6 A. [/ Clanguage="en-us" time="14:44:55" schemaVersion="6" author="Teamcenter, Y. t! k' |% c0 v% m
V11000.2.2.20_20160504.00 - demo@IMC--1942934752(-1942934752)" date="2016-12-15"- F( h, }# b7 f$ i8 Y
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">
' u8 M9 W) g, l7 z<plmxml_bus:SavedQueryDef id="id1" name="Find unfinished perform signoff task"
* v4 ?4 I k& `5 R9 SnameRef="#id2" queryFlag="0" queryClass="EPMTask">8 e5 [' [3 p. n1 G8 F( U( i+ ]
<ApplicationRef application="Teamcenter" label="BLUhF49HIPhsCA"
$ C( Z! f$ S. t0 p4 oversion="BLUhF49HIPhsCA"></ApplicationRef>. {+ T/ L# N( ^6 X$ a% B' T
<plmxml_bus:QueryClause id="id3" stringValue="SELECT qid FROM EPMTask WHERE/ [1 I# O- M3 d: k" p: X. |( @
"ImanRelation<-
0 m9 i: _: L W, Q% x: nprimary_object.Signoff:secondary_object.group_member.User:user.user_id" =: ?0 w6 ?8 ]; p5 f' b( q5 E
"${user_id = }" AND "object_type" = "${object_type =. {. ^& X, d# [4 g+ A0 G; l7 T
EPMPerformSignoffTask}" AND "state_value" = "${state_value =. X( Q4 a |; ]. X# k) N( a
4}""></plmxml_bus:QueryClause></plmxml_bus:SavedQueryDef>
2 u/ k* e) t. R8 J<plmxml_bus:Text id="id2" primary="enus"></% _% w5 V: P% h: r3 _$ `
plmxml_bus:Text></plmxml_bus:PLMXMLBusinessTypes>1 Y; [) n+ M7 D. S$ W
: z0 Y8 w: z* }- H% p, w& ? |
|