Recently we had a requirement of conditional lookup for Maximo list view search. We have a custom column called sub-work type which is based on the value selected on the main work type attribute. This functionality on the application was working fine using table domain but it wasn't working on the list view in Maximo.
SO we developed a solution using conditional lookup automation script in Maximo list view search fields. First, we got the where clause of the current APP from memory in wclause variable, and then we got the work type i.e. CM or PM value using the split function. Then by using the zombie() method we set the work type value for a list where clause.
Object |
WORKORDER |
Type |
ATTRIBUTE LAUNCH POINT (Jython) |
Attribute |
WOSUBTYPE |
Name |
WOSUBTYPE |
Body |
from psdi.common.context import UIContext appName = mbo.getThisMboSet().getParentApp() if appName in ('PLUSPWO','PLUSPWOCMP'): #Get Where clause for list view search wclause = service.webclientsession().getCurrentApp().getResultsBean().getMboSet().getUserAndQbeWhere() #Search worktype value of list view if mbo.isZombie(): clause=wclause.split("worktype")[1].split("'")[1] listWhere="worktype='"+clause+"'" |
Add caption |
- Now on the below screenshot, you can see the sub-work type related to selected work type CM is displaying.
- Select the value and click search.
No comments:
Post a Comment