var tsmc = _g().getParameterContainer().getWidgetByName("tsmc").getValue();

var isbn = _g().getParameterContainer().getWidgetByName("isbn").getValue();

var dshm = _g().getParameterContainer().getWidgetByName("dshm").getValue();

var htbh = _g().getParameterContainer().getWidgetByName("htbh").getValue();

var htmc = _g().getParameterContainer().getWidgetByName("htmc").getValue();

var result = FR.remoteEvaluate(

    '=SQL("HANA_测试环境-MySql", ' +

        '"SELECT COUNT(*) AS GS, ROUND(COUNT(*)/500)+1 AS ZYM " ' +

        '+ "FROM GCT01 t2 " ' +

        '+ "LEFT JOIN GCT04 t1 ON t2.XTDWDM = t1.XTDWDM AND t2.BCSQHM = t1.BCSQHM " ' +

        '+ "WHERE 1=1 " ' +

        '+ "${if(len(tsmc) == 0,\\"\\",\\" AND BCTSMC LIKE \\'%\\" + tsmc + \\"%\\'\\")}" ' +  // 注意转义符

        '+ "${if(len(isbn) == 0,\\"\\",\\" AND BCISBN LIKE \\'%\\" + isbn + \\"%\\'\\")}" ' +

        '+ "${if(len(dshm) == 0,\\"\\",\\" AND BCDSHM LIKE \\'%\\" + dshm + \\"%\\'\\")}" ' +

        '+ "${if(len(htbh) == 0,\\"\\",\\" AND GCHTBH = \\'\\" + htbh + \\"\\'\\")}" ' +

        '+ "${if(len(htmc) == 0,\\"\\",\\" AND GCHTMC LIKE \\'%\\" + htmc + \\"%\\'\\")}", ' +

        '2, 1)'

);

alert(tsmc);alert(isbn);alert(dshm);alert(htbh);alert(htmc);alert(result);

_g().getParameterContainer().getWidgetByName("总条数").setValue('/' + result);

这里哪里有问题，现在alert参数是获取成功的，但是SQL函数一直走的是空值