Has anyone used Enterprise Service Response Configuration? I am creating a new work order using web service (synchronous) and response xml contains site, work order number and work order ID. As far as I know maximo adds the primary columns, defined in DB config application using Primary Column# field, to the response. I want to add the status field also. Can the response xml be modified without adding status as primary column in DB config application? I tried creating an integration automation script on the response (both User Exit and External Exit) but it did not work.
SYNC.1ATESTWO.USEREXIT.OUT.AFTER
from psdi.server import MXServer
from psdi.mbo import MboConstants
wonum = erData.getCurrentData("WONUM")
siteid = erData.getCurrentData("SITEID")
woMboSet = MXServer.getMXServer().getMboSet("WORKORDER", MXServer.getMXServer().getSystemUserInfo())
woMboSet.setWhere("wonum = '"+wonum+"' and siteid = '"+siteid+"'")
woMboSet.setFlag(MboConstants.DISCARDABLE, True)
woMboSet.setFlag(MboConstants.NOSAVE, True)
woMboSet.reset()
woMbo = woMboSet.moveFirst()
if(woMbo):
erData.setCurrentData("STATUS",woMbo.getString("STATUS"))
woMboSet.clear()
woMboSet.close()