Maximo URL's

Примеры открытия конкретного объекта в приложении и выборки записей с фильтром

Открыть выборку (sqlwhere или useqbe)

http://server.url/maximo/ui/login?event=loadapp&value=wotrack6&additionalevent=sqlwhere&additionaleventvalue=status%3D'APPR'

http://server.url/maximo/ui/login?event=loadapp&value=sr3&additionalevent=sqlwhere&additionaleventvalue=status%3D'INPROGRO'

Не запускается 'Центр управления' (db2cc) - Can not open display

На Linux системах при запуске "Центра управления" DB2 не из под учетной записи инстанса (db2inst1) может возникать следующая ошибка:

user@srv: db2cc

No protocol specified

Error: Can not open display

Вероятнее всего вы попытались запустить "Центр управления" из-под учетной записи пользователя, который был вами создан при установке системы Linux, или системной учетной записи root.

Dynamic query variables in Maximo

Here is a list of variables you can use in Maximo for queries.

:yes – true
:no – false
:&date& – current date
:&datetime& – current date/time
:&user& – logged in user
:&personid& – person ID of the logged in
:&appname& – application name
:&mboname& – name of the current business object
:&ownername& – name of the owner business object
:<relationshipname>.<attrname> – value of an attribute of a related business object of the current business object
:&owner&.<attrname> – value of an attribute of the owner business object
:&owner&.<relationshipname>.<attrname> – value of an attribute of the related business object of the owner business object
:$old_<attrname> – the initial value from the database of the attribute

Cloning one Maximo 7.5 Administrative Environment to Another Machine

Link: Cloning one Maximo 7.5 Administrative Environment to Another Machine

Question

Can you clone/port a Maximo environment to another machine without doing a full install on the second machine.

Answer

You can attempt to clone/port a Maximo environment to another machine from a machine where Maximo has been installed. On both machines Maximo must reside in the same location. If Maximo was installed on the E drive on machine 1 it needs to be setup on the E drive on machine 2. The operating system on both machines must be identical. If one is Windows 2003 SP2 64-bit, the second machine must be the same. It can not be for example Windows 2003 SP2 32-bit or Windows 2003 64-bit.

This assumes the middleware has been installed and configured.

On the first machine:

1. Zip the ibm\smp folder

2. Backup the database this Maximo connects

On the second machine:

Принудительное обновление Старт-Центров MAXIMO

Для принудительного обновления старт-центров в MAXIMO необходимо запустить скрипт в СУБД.

Для всех групп:

DELETE FROM MAXIMO.LAYOUT WHERE SCCONFIGID IN ((SELECT MAXIMO.SCCONFIG.SCCONFIGID FROM MAXIMO.SCCONFIG));
DELETE FROM MAXIMO.SCCONFIG;

или для конкретной группы:

DELETE FROM LAYOUT WHERE SCCONFIGID IN (SELECT SCCONFIGID FROM SCCONFIG WHERE GROUPNAME = 'SECURITYGROUPNAME');
DELETE FROM SCCONFIG WHERE GROUPNAME = 'SECURITYGROUPNAME';

Installing JAD in Eclipse

Link for plugin
Link for JAD for different platforms
p.s.
It's work's in Eclipse 4.2. But not in 4.3.

How to Create Application Restrictions via Presentation.xml

You can use Application Designer to define restrictions on what records can display in an application. You can filter what data a user can see when opening an application by entering a query in the application’s presentation control. You might want to filter what records a specific application displays when it and several other applications use the same data source, but not all of the data records in the set are applicable to all of the applications.

To define an application restriction, complete the following steps:

1. Open Application Designer by choosing Go To > Configuration > Application Designer.
2. Type the name of the application you wish to open, or press Enter to display a list of applications.
3. As an example, open the Assets application in the Workspace tab.
4. Click Select Action > Toggle Show All Controls.
5. Click the "presentation..." control.
6. Click the Control Properties button to open the Presentation Properties dialog box.
7. In the Where Clause field, enter "inactive=’0’". Application Designer interprets the query as "select * from asset where inactive=’0’".
8. Click Save.

When you open the Assets application, you will only see records where the inactive attribute has a value of "0".