Hello,I have an automation script based on Object lanuch point "ZZAMSVACTRANS" object. While "ZZAMSVACTRANS" has a relationship with "ZZAMSTIMECARD" object through a named relation "VACSHEET". Now I want to get two attributes from current object "ZZAMSVACTRANS" which are a string attribute ( "ZZEMPLOYEENO") & a date attribute ("VACATION_START") . Next I want to search for those two fields in "VACTIMESHEET" as follow:from psdi.server import MXServerfrom psdi.mbo import SqlFormatfrom psdi.mbo import MboValuemVac = mbo.getTisMboSet()mTS = mbo.getMboSet("VACTIMESHEET")mEmpno = mVac.getString("ZZEMPLOYEENO")mVacstart = mVac.getDate("VACATION_START")** Next setWhere works fine but to search for only the string attributemTS.setWhere("ZZEMPLOYEENO="+mEpno)** Next setWhere does not work ??? mTS.setWhere("TS_DAY="+mVacstart)I got thise error as in the picture
You need to use SQLFORMAT class.
Join CommunityInvite ColleaguesLearn MoreGet Started on MORE