MAXIMO6实施宝典，持续更新中！

jdaippyp

太少，要搞就使劲open，全部放上来吧。
共享的动力，哈哈。

snow.lovers

Overview : By default, Maximo displays 50 classification nodes. It is possible to configure Maximo to see all the classifications.


In Maximo 6, there is a limit of 50 hard-coded into control.jsp. to configure Maximo to see all the classifications, perform the following steps:

1. Edit the control.jsp file located in c:\maximo\applications\maximo\maximouiweb\webmodule\webclient\controls\tree\control.jsp

2. Change the following default value to to take in the higher numeric value for records to be displayed:

int CONST_TREE_NODE_CHILDREN_COUNT_DEFAULT = 50;

3. Rebuild and redeploy the Maximo ear file

yf6456

对与列表字段长度的修改，还有一个办法，就是加属性width
例如：              <tablecol id="copy_results_showlist_tablebody_5" dataattribute="DESCRIPTION" width="600" />

snow.lovers

不错，大家狂顶！

snow.lovers

很不幸，M6.1不能按照yf6456的操作办法进行，BUG！

allen08

LZ伟人，好不容易找到一个MAXIMO论坛

yf6456

M6常用sql：
--查看对象或属性信息
select b.objectname,attributename,title,remarks,b.description,columnname,maxtype,sameasattribute,a.classname,a.DOMAINID  
from MAXATTRIBUTE a ,maxobject b
where a.objectname=upper('REORDERPAD') and a.objectname=b.objectname order by attributename   

--查看关系
select * from maxrelationship where  name=upper('WPMATERIAL') and parent='FAILURELIST' for update;
--查看应用
select * from maxapps where app='ACTIVITY'
--查看索引
select * FROM MAXSYSINDEXES
SELECT * FROM MAXSYSKEYS

--人员
select * from person where personid='YF'
select * from PERSONCAL where personid='YF'

--人员组成员
select a.description,b.resppartygroup from persongroup a,PERSONGROUPTEAM b where a.persongroup=b.persongroup and  a.persongroup = 'AG_FIRE'
select * from persongroup where persongroup = 'SHUAXUE'
select * from PERSONGROUPTEAM where persongroup = 'AG_FIRE'
select a.persongroup,b.description,a.* from PERSONGROUPTEAM a,persongroup b
where respparty in( '戴玲') and a.persongroup=b.persongroup
--查询员工信息
select a.laborcode,b.displayname ,a.*,b.* from labor a, person b where a.personid=b.personid and laborcode='yf'
--员工
select * from labor;
--maximo用户
Select * From maxuser Where userid LIKE '罗%'
select loginid,a.* from maxuser a where userid='刘';
select * from GROUPUSER where userid like '周永%';

Select * From GROUPUSER Where USERID In (
Select userid From groupuser  Having Count(*) =1 Group By userid) And GROUPNAME='WOMG' ;
Select * From maxuser;
--角色
select * from maxrole
--角色中对应的人员组的成员为0的人员组
select
(select count(*) from PERSONGROUPTEAM b where a.persongroup=b.persongroup
and b.persongroup in (select persongroup from maxrole c where  c.persongroup=b.persongroup  )) as ct
,a.persongroup,a.description from persongroup a
where (select count(*) from PERSONGROUPTEAM b where a.persongroup=b.persongroup
and b.persongroup in (select persongroup from maxrole c where  c.persongroup=b.persongroup  )) =0
group by a.persongroup,a.description




--查看自增字段
select * from autokey;

--查询应用的service的classname
select * from MAXSERVICE WHERE servicename=upper('INVENTORY')

--注册lookup
SELECT * FROM MAXLOOKUPMAP
--值列表
select a.domainid,a.description,maxvalue,value,b.description from MaxDomain a,SynonymDomain b
where a.domainid=b.domainid
and a.domainid = upper('wostatus')
AND VALUE='AG'
and a.description like '%发放%'
select * from ALNDOMAIN a WHERE a.domainid = upper('CREWID')
select * from SynonymDomain WHERE domainid = upper('wostatus')

--工单类型
select * from worktype
--工单状态
select a.domainid,a.description,maxvalue,value,b.description from MaxDomain a,SynonymDomain b
where a.domainid=b.domainid and a.domainid=upper('WOSTATUS')
--工单类型
select a.domainid,a.description,maxvalue,value,b.description from MaxDomain a,SynonymDomain b
where a.domainid=b.domainid and a.domainid=upper('worktype')
--采购申请单状态
select a.domainid,a.description,maxvalue,value,b.description from MaxDomain a,SynonymDomain b
where a.domainid=b.domainid and a.domainid=upper('PRSTATUS')



--查看邮箱数据
select a.ASSIGNSTATUS,a.* from wfassignment a  order by  startdate

--查询菜单
select * from sigoption where app=UPPER('receipts')
--应用程序权限表
select * from  APPLICATIONAUTH  where app=UPPER('receipts')
--转到的信息，为应用程序和选项指定级别和嵌套
select * from MAXMENU where menutype = 'MODULE'


--查询工作流
select * from wfprocess where description like '%报缺%'
select * from wfnode where processid='26' order by nodeid; --节点
select * from action where objectname='WORKORDER'


--查看文档服务器
select * from APPDOCTYPE where app='FATRAN'
select * from doctypes where doctype='业务审批'
select * from DOCLINKS where doctype='业务审批'
select * from DOCLINKS where keytable='WORKORDER'


--查看工作流
select * from wfinstance where ownerid = (select workorderid from workorder where wonum='2176')

--查看设备
SELECT * FROM LOCANCESTOR WHERE location in (select location from locancestor where ancestor='NULL')
select * from locations where location in ('SWIC021','34AWIC021','4TB17IC02','FUCKD2')


--字段控制
select * from MEXFLDCTRL
select * from MEXFLDCTRLATTRIB

--查看分类
select * from CLASSSTRUCTURE
select * from CLASSIFICATION

--查看工作流
Select a.* From wfassignment A Where wfid=0 And processNAME='WOTRACKING'  And processrev=13;
Select * From wfassignment Where ownerid In (Select workorderid From workorder Where wonum='3220')
Select * From wfnode
Select * From wfaction Where  processNAME='WOTRACKING'  And processrev=13 Order By processname,processrev

--位置
select count(*) from locations where location not in (select location from lochierarchy)
--位置层次结构,本身与父级
select count(*) from lochierarchy
select * from lochierarchy where location=parent
--搜索位置层次结构，本身与所有父级
select count(*) from locancestor

yf6456

Maximo 5.x                                                          MXES          
MaxTables, MaxTables2                      MaxObject, MaxTable, MaxView          
MaxSysColumns, MaxSysColumns2                    MaxAttribute, MaxViewColumn          
MaxSysIndexes, MaxSysKeys                    MaxSysIndexes, MaxSysKeys          
SigOption                                                    SigOption, MaxMenu          
MaxUserAuth                                    ApplicationAuth          
ValueList                                                    MaxDomain, SynonymDomain

yf6456

使用bat导入：
maxinst.bat -czh -imaxdemo -dmaximo.log

使用imp导入：
imp maximo/maximo@orcl file=D:\Maximo6\tools\maximo\zh\maximo2.DMP log=D:\Maximo6\tools\maximo\zh\maximo2.log full=y feedback=10000 buffer=1024000

yf6456

delete from GRPREASSIGNAUTH t where t.userid = 'MAXADMIN';
insert into GRPREASSIGNAUTH select GRPREASSIGNAUTHseq.Nextval,'MAXADMIN',t.groupname,null from maxgroup t ;
delete from  GROUPUSER t where t.userid = 'MAXADMIN';
insert into GROUPUSER select  GROUPUSERseq.Nextval,'MAXADMIN',t.GROUPNAME,NULL FROM GRPREASSIGNAUTH  t WHERE t.userid = 'MAXADMIN';
commit;

yf6456

SqlFormat：
                SqlFormat sqlformat = new SqlFormat(getUserInfo(), "LABORCODE=:1");
                sqlformat.setObject(1, "Labor", "LaborCode", laborcode);
                MboSetRemote msr = getMboSet("$Labor", "Labor", sqlformat.format());
                if (!msr.isEmpty()) {
                        MboRemote mbo = msr.getMbo(0);
                        if (type != null && !"".equalsIgnoreCase(type)) {
                                ret = mbo.getString(type);
                        }
                }

yf6456

公用字段类，指在所有表中含有本类对应的字段时，可以将这个类作为字段类或继承这个类

public class FldLaborcode extends MAXTableDomain
{

    public FldLaborcode(MboValue mbovalue)
        throws MXException
    {
        this(mbovalue, null);
    }

    public FldLaborcode(MboValue mbovalue, String s)
        throws MXException
    {
        super(mbovalue);
        String s1 = getMboValue().getAttributeName();
        //输入值时产生关联
        setRelationship("LABOR", "orgid=[s:7]rgid and laborcode = :" + s1);
        addConditionalListWhere("orgid", "1", "orgid=[s:7]rgid");
        setErrorMessage("labor", "NotValidLabor");
    }
}

snow.lovers

好东西，谢谢上楼！就是有几个图标看这不舒服，哈哈

yf6456

我也不想啊，自动产生的。

rocshaw

好东西啊，
顶
顶

snow.lovers

实现缺陷工单预警颜色变化（MAXIMO6）
参见下面地址：
http://www.eampub.com/thread-162-1-1.html

W39

克隆新应用后要在工作流中添加应用才会在应用的工具栏上出发送工作流的图标

ljl18

MAXIMO启动中心增加一个导航链接


5、MAXIMO启动中心增加一个导航链接
步骤如下：
1、修改maxpresstentation表 APP=library，增加一个段
<header id="selfServicePageHeader">
     <titlebar id="self_pageTitlebar"> 相当于克隆，
2、在这个结构中增加连接
<hyperlink id="self_ibm" label="guestbook" mxevent="loadlink" classname="powerwhite" targetid="self_pageTitlebar" link="http://10.192.174.23:8080/guestbook/" image="information.gif"/>

在maxlabels表的app＝library中增加标签定义self_ibm
3、修改maxpresstentation中app＝STARTCNTR
3、重启生效

snow.lovers

http://www.eampub.com/thread-471-1-1.html

jnte

支持，归纳总结，顶一下