首页 > 代码库 > 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查询相关表