Monday, September 26, 2016

IBM Maximo : Calling a report from a push button in Maximo

Idea here is to launch a report from a push button on any screen. In this way business can run a specific report by clicking a button in the screen itself.

1.       Find the report which you want to run (ex: woprint.rptdesign) and hit the database to find the report number and execute below query

select reportnum,reportname,appname from report where reportname='woprint.rptdesign' and APPNAME='WOTRACK';



2.       From Report Library file (REPLIBRARY) and search for reportnum="351" , note the id related to it (highlighted)






id="reportd351"
label="Request Page" mboname="WORKORDER" reportnum="351" reporttype="BIRT" width="550">

3.       Navigate to application designer, search for WOTRACK and a new button with details like
Event : reportd351 and save it



4.       From Work Order Tracking application , you can see a Print Report button, when you click it shows report page like below




And on Submit, it generates the report.




----------------------------------------------------------------------------
 All the messages
below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Tuesday, September 20, 2016

Maximo Environment refresh- Naming environments

-- Below are the scripts which can be executed after production refreshes to make sure every environment is named from login screen etc.
Below is a example where we are trying to set values in a system as Development Environment


------ Messages on the Login Screen -----

--Login Button ---
update maximo.maxmessages set value = 'Sign In to Development' where msgkey = 'loginbutton' and msggroup = 'login';

-- Welcome Message ---
update maximo.maxmessages set value = 'You are in Development' where msgkey = 'welcome' and msggroup = 'login';

update maximo.maxmessages set value = 'Welcome to Development' where msgkey = 'welcomemaximomessage' and msggroup = 'login';

update maximo.maxmessages set value = 'Welcome to Development, {0}' where msgkey = 'welcomeusername' and msggroup = 'login';

-- Maximo Log Out Messages ----
update maximo.maxmessages set value = 'All users will be logged out of Development Environment in {0} minutes. Save your work.' where msgkey = 'AdminLogoutSubject';

update maximo.maxmessages set value = 'Maximo configuration in progress on Development Environment' where msgkey = 'AdminLogoutMessage';

--- Maximo Application ----

update maximo.maxapps set description = 'DEV - ' || description;

commit;



----------------------------------------------------------------------------
 All the messages below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.