This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
I need an automation script that can detect and manipulate the WHERE clause currently active within an application.
Here is an example scenario:
1) User goes to the Assets application
2) User uses the LIST tab and / or Advanced search to display a record set...
a. User sets SITEID = 'SS'
b. User sets PRIORITY = 4
c. User specifies a location value of 'STCE7001'
3) When the user applies these criteria, Maximo automatically generates a WHERE clause = (priority = 4 and siteid like '%SS%' and location like '%STCE7001%').
4) User reviews the list of records on the List tab and decides to run a report—they press a button in the toolbar.
5) The toolbar button is associated with UI sig option that launches an automation script.
6) The automation script is able to detect the WHERE clause (priority = 4 and siteid like '%SS%' and location like '%STCE7001%'), and then parse and reformat it.
7) The automation script then takes the reformatted WHERE clause and launches a URL with the reformatted WHERE clause appended to the end of the URL.
I can figure out everything except for step #6--HOW to use the MBO model to put the WHERE clause into a variable. Any thoughts or help would be GREATLY appreciated!