使用高级查询advQuery 来查询数据

function SelectMultiple1_onValueChangeScript(cxt: ScriptContext, cmp: SelectMultiple, ids:Array ) {
   if(Common.isNotEmpty(ids)){
        cmp.getPage().components.SqlDataSetBase1.loadWithPageParam({
        query: {
            advQuery: [
                {
                    name:'FUXKID', //in 的字段编号
                    type: 'in',
                    val: ids.join(',') //查询的in的字段的值的数组
                }
            ]
        }
    })}
    else{
        cmp.getPage().components.SqlDataSetBase1.reload({},true)
    }
}

使用mybati语法

• 注意:
  1. 需要平台版本5.0.231 以上版本

select A.* ,B.OBJNAME 
from CORE_APIBBGL A 
LEFT JOIN CORE_USER B ON A.SYS_CREATOR =B.RWID
where 1=1 and  A.APIID IN  
      <foreach collection="apiId" item="item" open="(" close=")" separator=",">  
          #{item}  
      </foreach>   
order by A.SYS_CREATETIME desc 

• 参数传递 apiId必须是传递数组,否则会出错,如下:

  function DesignerPage1_onLoadScript(cxt: ScriptContext, page: DesignerPageBase) {
    page.setParamsObj({ apiId: [page.getParamValue('apiId')] })
    page.components.Table1.loadData()
  }