BOSIDE 查询SQL

/*****BOSIDE*****/

--领域模型

select *from T_MDL_DOMAINMODETYPE

select *from T_MDL_DOMAINMODELSUB

select *from T_MDL_DOMAINMODETYPE_L where FLOCALEID=2052;

select *from T_MDL_DOMAINMODELSUB_L where FLOCALEID=2052;

--元素分类

select b.FNAME,a.* from T_MDL_ELEMENTTYPE a

inner join T_MDL_ELEMENTTYPE_L b on a.FID=b.FID where b.FLOCALEID=2052

--元数据表

select *from T_META_OBJECTTYPE where FSUPPLIERNAME='Kingdee'--FDEVTYPE=2 --表示扩展

--操作

select b.FNAME,a.* from T_MDL_FORMOPERATIONTYPE a

inner join T_MDL_FORMOPERATIONTYPE_L b on a.FID=b.FID where b.FLOCALEID=2052

--校验器

select b.FNAME,a.* from T_MDL_FORMVALIDATIONTYPE a

inner join T_MDL_FORMVALIDATIONTYPE_L b on a.FTYPEID=b.FTYPEID where b.FLOCALEID=2052

--实体服务

select b.FDESC,a.* from T_MDL_FORMBUSINESS a

inner join T_MDL_FORMBUSINESS_L b on a.FACTIONID=b.FACTIONID where b.FLOCALEID=2052

--缺省值函数

select b.FDESC,a.* from T_MDL_FORMFUNCTION a

inner join T_MDL_FORMFUNCTION_L b on a.FID=b.FID where b.FLOCALEID=2052

--表达式函数

select SUBSTRING(a.FAPPEARANCECLASS,5,150) 函数标识,b.FNAME 函数名,b.FDESCRIPTION 使用说明, *from T_MDL_ELEMENTTYPE a

inner join T_MDL_ELEMENTTYPE_L b on a.FID=b.FID and b.FLOCALEID=2052

join T_MDL_DOMAINMODELELEMENTMAP c on a.FID=c.FELEMENTTYPEID and c.FID=1200 and c.FELEMENTGROUPID=24

--xml字符串查找校验器用到lambda表达式的元数据

select *from (

select fid,FKERNELXML.query('//FormOperation//Validations') 'item' from T_META_OBJECTTYPE

where FMODELTYPEID=100)a

where convert(varchar(max),item) like '%lambda%';

--xml字符串查找实体服务

select *from (

select fid,FKERNELXML.query('//EntityServiceRules//EntityServiceRule') 'item' from T_META_OBJECTTYPE

where FMODELTYPEID=100)a

where convert(varchar(max),item) like '%SysParam%';