How to retrieve a list of values for an attribute

notebook

The way to get a list of values is like setting up a Table Domain for an attribute.

if mbo.isZombie():                         # List of values for the List tab or Advanced Search
    relationObject = "WORKTYPE"            # Value list object
    relationWhere = "woclass='WORKORDER'"  # Validation where clause
    listWhere = "woclass='WORKORDER'"      # List where clause
    listOrder = "worktype"                 # Order By clause
    srcKeys = ["WORKTYPE"]                 # Source attribute
    targetKeys = ["CUSTWORKTYPE"]          # Target attribute
else:
    relationObject = "WORKTYPE"
    relationWhere = "woclass='WORKORDER' and orgid=:orgid"  # Specific validation where clause
    listWhere = "woclass='WORKORDER'"                       # Specific list where clause
    listOrder = "worktype"
    srcKeys = ["WORKTYPE"]
    targetKeys = ["CUSTWORKTYPE"]

If you found my post interesting or useful and just want to say thanks, you can always buy me a coffee.

Leave a Reply