首页 > 代码库 > form查询相关表
form查询相关表
------------------------------------------------------------------------
select * from limsappcategories
select * from limsapplications
select * from limsxfdforms
select * from limsxfdresources
select * from limsappserverscripts
select * from limsappclientscripts
select * from limsappdatasources
----------------------------form
select f.formid ,c.catname, a.appname, f.formname
from limsxfdforms f
join limsapplications a
on a.appid = f.appid
join limsappcategories c
on a.categoryid = c.categoryid
where f.formid = ‘79B18936-DFEE-4002-9FF7-9BBBADB97A8A‘
----------------------------serverscript
select c.catname, a.appname, s.scriptid
from limsappserverscripts s
join limsapplications a
on a.appid = s.appid
join limsappcategories c
on a.categoryid = c.categoryid
where s.scriptid = ‘C552F35A-B2F5-EB49-AE03-46E66F9CC31F‘
----------------------------clientscript
select c.catname, a.appname, s.scriptid
from limsappclientscripts s
join limsapplications a
on a.appid = s.appid
join limsappcategories c
on a.categoryid = c.categoryid
where s.scriptid = ‘5BBBF5D6-0CF4-4E72-A4C1-4D9D5B930392‘
----------------------------datasource
select c.catname, a.appname, d.datasourceid, ds.dsname
from limsappdatasources d
join limsdatasources ds
on d.datasourceid = ds.datasourceid
join limsapplications a
on a.appid = d.appid
join limsappcategories c
on a.categoryid = c.categoryid
where d.datasourceid = ‘193F410D-BDA8-400A-B40D-B49AFE8A93F8‘
------------------------------------------------------------------------
----------------------------serverscript
select * from limsserverscriptcategories
select * from limsserverscripts
select lsc.catname, ls.scriptname
from limsserverscripts ls
left join limsserverscriptcategories lsc
on ls.categoryid = lsc.categoryid
where ls.scriptid = ‘36BF138A-476F-E446-8766-31D3F9B6F6F9‘
------------------------------------------------------------------------
----------------------------clientscript
select * from limsclientscriptcategories
select * from limsclientscripts
select lcc.catname, lc.scriptname
from limsclientscripts lc
left join limsclientscriptcategories lcc
on lc.categoryid = lcc.categoryid
where lc.scriptid = ‘006C2968-C5BF-484E-946A-E8F311B8CC72‘
------------------------------------------------------------------------
----------------------------datasource
select * from limsdatasourcecategories
select * from limsdatasources
select lc.catname, ld.dsname
from limsdatasources ld
left join limsdatasourcecategories lc
on lc.categoryid = ld.categoryid
where datasourceid = ‘6B1740EA-742A-EB43-ACEF-77D4EC26A993‘
------------------------------------------------------------------------
form查询相关表
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。