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.



