Wednesday 16 January 2019

Limit domain with Where clause using Automation Script | Maximo




Attribute Launch Point:





Object: WPMATERIAL
Itemnum: ITEMNUM
Events: Retrieve list

Source Code:

VLOC = mbo.getString("LOCATION")
domainid = 'WPMITEM'

if VLOC is None or VLOC == "":
    vlocnull = "status = 'ACTIVE'"
else:
    vlocnull = "itemnum in (select itemnum from inventory where location='"+ mbo.getString('LOCATION') +"' AND ITEMSETID = 'ITEMSET' AND SITEID = 'BEDFORD' AND REORDER='1' AND STATUS = 'ACTIVE')"
listWhere = vlocnull
#    listWhere = "itemnum in (select itemnum from inventory where location='"+ mbo.getString('LOCATION') +"' AND ITEMSETID = 'SET1' AND SITEID = 'BEDFORD' AND REORDER='1' AND STATUS = 'ACTIVE')"

No comments:

Post a Comment