Wednesday, 19 January 2022

how to use sqlformat in automation script

  status=mbo.getString("status")

 siteid=mbo.getString("siteid") 

  assetSet=mbo.getMboSet("ASSET")

  sqlFormat = SqlFormat(assetSet.getUserInfo(), "siteid = :2 and status=:1 ")

  sqlFormat.setObject(1, "ASSET", "STATUS", status)

  sqlFormat.setObject(2, "ASSET", "SITEID", siteid)

  assetSet.setWhere(sqlFormat.format())

No comments:

Post a Comment