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

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

select FID
,(select FNAME from T_META_OBJECTTYPE_L where FID = T_META_OBJECTTYPE_Temp.FID and FLOCALEID = 2052) FNAME
,FKERNELXML ,Item

from

(select FKERNELXML.query('//TableName') 'Item', * from T_META_OBJECTTYPE) T_META_OBJECTTYPE_Temp

where convert(varchar(max),Item) like '%t_gl_voucher%' --数据库表名(依情况替换此处't_ER_ExpenseReimb')

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