如果查询,二开的某个插件被哪些单据引用,查询单据上都有哪些插件
--MS SQL Server
select
FID
,(select FNAME
from T_META_OBJECTTYPE_L
where FID = T_META_OBJECTTYPE_Temp.FID
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('//ClassName') 'Item', * from T_META_OBJECTTYPE)
T_META_OBJECTTYPE_Temp
where convert(varchar(max),Item) like '%插件名%'
------查询单据上都有哪些插件
select a.FID,a.FKERNELXML,b.FNAME,a.Dome
from
(select FKERNELXML.query('//ClassName') 'Dome', * from T_META_OBJECTTYPE) a
left join T_META_OBJECTTYPE_L b on b.FID = a.FID
where b.FLOCALEID = '2052' and b.FNAME = '采购订单'
如果查询,二开的某个插件被哪些单据引用,查询单据上都有哪些插件
--MS SQL ServerselectFID,(select FNAME from T_META_OBJECTTYPE_L where FID = T_META_OBJECTTYPE_Temp.FID and FLOCALEID = 2...
点击下载文档
本文2024-09-16 17:14:59发表“云星空知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3cloud-14495.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章