|
|
请使用QQ关联注册PLM之家,学习更多关于内容,更多精彩原创视频供你学习!
您需要 登录 才可以下载或查看,没有账号?注册
x
125. 在TC11.x下如何查找特定审批人未完成的执行签发任务
2 S1 ]5 S% x# \+ I# c3 [工作流附件的存储方式在 TC11.x以及后续版本下发生了变化,如下可以看到已经被声明不
5 X2 r: I7 r3 o2 e$ B1 E支持.9 ?7 ~! P z! r
8 u3 h C& R! c. `4 f
签发附件现在是作为关系引用的次对象,EPMTask作为关系引用的主对象。新的查询如. b ^0 Q' C h) W. K+ A6 L
下:+ o; N4 O6 O# n* _* v$ \$ ?5 D
Object_type is EPMPerformSignoffTask* w. v+ m: i4 }- K
State_value 4 表示未完成的任务
# v, U) z) @& s# y& U查询脚本如下,可以导入Teamcenter查询构建器
' J6 d3 C& E3 x: X+ c( {5 W<?xml version="1.0" encoding="utf-8"?>
0 b& `& N& J; Y" L<!-- GENERATED BY: PLM XML SDK 7.0.4.411 -->1 L7 L! J1 ^. q! I
<plmxml_bus:PLMXMLBusinessTypes
! d4 U) z7 W: C% l6 I- e) hxmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"6 h( s* x: M" H( a2 }
xmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema"# m* L. V4 H6 F3 H9 c' W. q
language="en-us" time="14:44:55" schemaVersion="6" author="Teamcenter
w: j6 d; ^/ B* g6 `V11000.2.2.20_20160504.00 - demo@IMC--1942934752(-1942934752)" date="2016-12-15"
6 d! O* j* h$ L- Olanguages="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"> \! d1 r% d4 V4 D; J+ @: z% J
<plmxml_bus:SavedQueryDef id="id1" name="Find unfinished perform signoff task"$ c, P+ a4 @5 o) V, h* s
nameRef="#id2" queryFlag="0" queryClass="EPMTask">
: n; p: T3 \2 R; @1 m( U4 c7 ]7 _<ApplicationRef application="Teamcenter" label="BLUhF49HIPhsCA"# l, y# n: I/ q$ p1 _
version="BLUhF49HIPhsCA"></ApplicationRef>
8 x4 G2 a0 {+ \3 w/ b- s<plmxml_bus:QueryClause id="id3" stringValue="SELECT qid FROM EPMTask WHERE
# W0 |% b! Z1 X3 V1 I- j"ImanRelation<-
7 K: h* }' w5 y* p/ H+ `, O8 J2 |primary_object.Signoff:secondary_object.group_member.User:user.user_id" =4 v5 z: ^! M/ V- T7 s
"${user_id = }" AND "object_type" = "${object_type =: m1 N' Z' [) i+ E
EPMPerformSignoffTask}" AND "state_value" = "${state_value =; ~3 x' s8 V, L6 g2 j
4}""></plmxml_bus:QueryClause></plmxml_bus:SavedQueryDef>
2 S* c i# @- |8 ?, P9 T' E<plmxml_bus:Text id="id2" primary="enus"></+ M. d& `' O$ b9 p( A
plmxml_bus:Text></plmxml_bus:PLMXMLBusinessTypes>1 M+ w' U H. M, K
" |1 m1 m6 b' G
|
|