Fetching Dynamic Lookup Lists via Attribute Launch Point with Retrieve List Event
Yalcin Kumbasar 270006B8DE Visits (14150)
In previous versions of Maximo/ICD, we used to write Java codes or create table domain of domains with case statement in list where clause in order to fetch lookup lists dynamically. Then, conditional domains were introduced, but they caused performance issues for large lists and were inefficient for some cases. In latest version (7.6), we have the "Retrieve List" event for Attribute Launch Points which is perfect for this task. Let me go through an example to explain:
AIM: Fetching different person groups for different sites for a custom field for groups
0) Assume that there are many sites corresponding to cities such as IZMIR, LONDON, PARIS, etc.
1) Create as many as needed table domains of person groups, namely GR-IZMIR, GR-LONDON, GR-PARIS, GR-COMMON, GR-ALL. They will be used like cases in a switch statement.
2) Go to Database Configuration application and create a custom field same as PERS
3) Write the Automation Script below for attribute launch point with Retrieve List event.
# select domain of person groups with respect to cities (sites) using a dictionary def sele
4) Go to Application Designer, add custom field to your application and write the lookup property for field as "PERSONGROUP".
NOTE: As I remember it did not work with a custom lookup and had shown invalid binding. It worked with the default lookup for person groups which is PERSONGROUP. If it was an ALNDOMAIN, I would prefer its default lookup instead of "VALUELIST".