这里加一个选中的按钮在哪里加？视图数据是用sql来获取的

【myApps/OBPM版本号】：v4.4- sp XX
【浏览器类型】：Chrome/其他
【联系方式-QQ】：请留下您的QQ号码
【联系电话】:    请留下您的联系电话，以便技术同事更好解决您的问题
【问题描述】：


Q : 这里加一个选中的按钮在哪里加？视图数据是用sql来获取的



A: 查询的时候把domainid也查出
例如select domainid，a，b from tlk_abc

Q: 已经添加的了,OK了,还需要获取一个ID的字段

(function () {   
   var qDoc = getCurrentDocument();
  var start_time = qDoc.getItemValueAsString("start_date").trim();
  var end_time = qDoc.getItemValueAsString("end_date").trim();
  var sql = "SELECT t1.DOMAINID,t1.formid, t1.FORMNAME AS item_FORMNAME, t1.item_grid,t1.item_emp_hide,COUNT(*) as item_sum,t1.created AS item_created FROM tlk_environment_inspection t1 WHERE t1.created BETWEEN '"+start_time+"' and '"+end_time+"' GROUP BY t1.item_emp_hide UNION all SELECT  t2.DOMAINID,t2.formid,t2.FORMNAME, t2.item_grid,t2.item_checker,COUNT(*),t2.created from tlk_appearance_inspection t2 WHERE t2.created BETWEEN '"+start_time+"' and '"+end_time+"' UNION all SELECT   t3.DOMAINID,t3.formid,t3.FORMNAME, t4.item_grid_plan,t3.item_checker,COUNT(*),t3.created FROM tlk_safecheck_task t3 LEFT JOIN tlk_company t4 ON t3.item_company = t4.ITEM_NAME WHERE  t3.created BETWEEN '"+start_time+"' and '"+end_time+"' GROUP BY t3.item_checker"  
        println("sql--->"+sql);
        return sql;            
      })()