k3 cloud中根据表明查找业务对象

k3 cloud中根据表明查找业务对象(表名称:PAEZ_SignOutRege)

and FLOCALEID = 2052) FNAME
,FKERNELXML
,(select
FNAME
from T_META_OBJECTTYPE_L
where FID = T_META_OBJECTTYPE_Temp.FID and FLOCALEID = '2052') FNAME
,Item
from
(select FKERNELXML.query('//TableName') 'Item', * from T_META_OBJECTTYPE)
T_META_OBJECTTYPE_Temp
where convert(varchar(max),Item) like '%PAEZ_SignOutRege%'

posted on 2020-11-02 17:27  这一生,谢谢自己  阅读(152)  评论(0编辑  收藏  举报