MAXIMO学习笔记

1、  查询页面菜单和标签

  select * from maxpresentation where app like '%MENUS%'

  select * from maxpresentation where app like '%LIB%'

2、根据用户名查询其拥有的应用程序增、删、改、查功能

select distinct u.userid,
       b.description,
       g.description,
--       t.app,
       m.description,
       t.optionname
  from applicationauth t,
       maxapps         m,
       maxgroup        p,
       groupuser