|
请使用QQ关联注册PLM之家,学习更多关于内容,更多精彩原创视频供你学习!
您需要 登录 才可以下载或查看,没有账号?注册
x
125. 在TC11.x下如何查找特定审批人未完成的执行签发任务
. b; H; r- V. l) m' K y工作流附件的存储方式在 TC11.x以及后续版本下发生了变化,如下可以看到已经被声明不- x- d ?% u0 P& p3 D
支持.) l: i5 }( y6 R1 g" B
3 ] [7 J. b# H
签发附件现在是作为关系引用的次对象,EPMTask作为关系引用的主对象。新的查询如
v0 h2 t/ d6 s) x# { \下:$ Y8 E' G4 w% P8 N% z6 t, Q
Object_type is EPMPerformSignoffTask
- ]- x, `+ _8 q' F; H; Q- B" JState_value 4 表示未完成的任务2 E: w# b' G5 O6 J8 \/ ?
查询脚本如下,可以导入Teamcenter查询构建器: A6 D# M/ S, a n3 A
<?xml version="1.0" encoding="utf-8"?>
, @$ S9 v0 c% o- P<!-- GENERATED BY: PLM XML SDK 7.0.4.411 -->
7 T1 r! }' @9 r" V<plmxml_bus:PLMXMLBusinessTypes
, z4 ]+ {/ }8 n+ j! mxmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"! R5 y9 Z5 i, W* w7 \
xmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema", j# p" `5 h$ z. D3 o1 E( L$ s7 |
language="en-us" time="14:44:55" schemaVersion="6" author="Teamcenter
* X8 N5 m- ~( `V11000.2.2.20_20160504.00 - demo@IMC--1942934752(-1942934752)" date="2016-12-15"
0 C+ H' o; y% j" x! y" k! ~8 mlanguages="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">( R$ z1 n& @( _7 J, y
<plmxml_bus:SavedQueryDef id="id1" name="Find unfinished perform signoff task"
2 U5 f6 b8 I5 J( N2 fnameRef="#id2" queryFlag="0" queryClass="EPMTask">9 U" d+ d6 M' |5 j
<ApplicationRef application="Teamcenter" label="BLUhF49HIPhsCA"
0 j! e. W0 S3 E& p3 o* c* K- Y) @version="BLUhF49HIPhsCA"></ApplicationRef>9 S) S4 X; v- t$ C9 z R
<plmxml_bus:QueryClause id="id3" stringValue="SELECT qid FROM EPMTask WHERE9 `/ m7 n8 _9 Z7 ^
"ImanRelation<-& C+ f7 K* K+ U! a( e
primary_object.Signoff:secondary_object.group_member.User:user.user_id" =( p% I; Z9 w& J
"${user_id = }" AND "object_type" = "${object_type =* v7 q* g. `/ g2 z! O1 Q
EPMPerformSignoffTask}" AND "state_value" = "${state_value =
- U8 ^5 z; j* L% `5 ?% f; h' i9 I4 O4}""></plmxml_bus:QueryClause></plmxml_bus:SavedQueryDef>0 M; i0 F4 x! }% K+ }1 X
<plmxml_bus:Text id="id2" primary="enus"></
3 E$ \) s) S: Y! Z9 k1 k, r& }plmxml_bus:Text></plmxml_bus:PLMXMLBusinessTypes>
3 b- D8 j% @' O8 h6 A" k; O2 l: r9 u T. }
|
|