Enovia Database

最新推荐文章于 2024-10-17 13:14:03 发布

原创最新推荐文章于 2024-10-17 13:14:03 发布 · 1.6k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#database #query #attributes #bt #xml

本文介绍了如何使用SQL进行复杂查询，包括查询具有所有属性的公交类型、从类型到类型的关系、菜单中的所有命令、表单中的所有字段及与格式相关的所有策略等。通过这些示例，读者可以了解如何构建复杂的SQL查询来获取所需的数据。

-- To query a bus with all attributes
select bt.mxname, bo.lxname, at.mxname, str.lxval
from mxbustype bt, lxbo_985079cc bo, mxdrvinfo di, mxattrtype at, lxstring_985079cc str
where bt.mxoid = bo.lxtype
   and bt.mxoid = di.mxtype
   and di.mxobj = at.mxoid
   and str.lxtype = at.mxoid
   and str.lxoid = bo.lxoid
   and bt.mxname = '%MXNAME%'
   and bo.lxname = '%LXNAME%'

-- To query a relationship from type and to type
select rt.mxname, di.mxkind, bt.mxname from mxreltype rt, mxdrvinfo di, mxbustype bt
where rt.mxoid = di.mxtype
and bt.mxoid = di.mxobj
and rt.mxname = '%RELNAME%'

-- To query all commands of a menu
select cm.mxname
from mxmenu cm, mxdrvinfo di
where di.mxobj = cm.mxoid
and di.mxtype =
(select mxmenu.mxoid from mxmenu where mxmenu.mxname = '%MENUNAME%')

--To query all fields of a form
select * from mxfield fd, mxform fm
where fd.mxparent = fm.mxoid
and fm.mxname = '%FORMNAME%

--To query all Policies related to a Format
select po.mxname from mxpolinfo pi, mxformat fm, mxpolicy po
where fm.oid = pi.mxobj
and po.mxoid = pi.mxpolicy
and fm.name = 'XML'

--To query the range of an attribute
select rl.mxlowval from mxrangelist rl, mxattrtype at
where rl.mxattr = at.mxoid
and at.mxname = '%ATTRNAME%'

MXADMIN

MXADMINREL

MXAPPLICATION

MXASSIGN

MXATTRTYPE

MXBUSTYPE

MXCHAIN

MXCHAINATTRIBUTE

MXCHANNEL

MXCUE

MXDEFINT