SQL查询系统表并排序

SELECT top 1000 t.name item_name,t.domain_id domainid,t.id item_id FROM ( SELECT name,domain_id,id FROM [BPMDB].[dbo].[T_DEPARTMENT]) t WHERE 1=1 order by t.NAME,t.domain_id,t.id

这是SQL   数据库能执行出来， 本来很简单的，我改了几次了 都不对。 一直说 **列无效。
Caused by: java.lang.Exception: Field:affiliationDept-值脚本出错
JavaScriptRunning:[Form.addGet.Field(11e4-9bca-dbd7f5fb-8e83-a1fec92c8832).affiliationDept.OptionsScript]: Wrapped java.sql.SQLException: 列名 'NAME' 无效。 (baselib#1247)
at cn.myapps.core.dynaform.form.ejb.Form.recalculateDocument(Form.java:2138)
at cn.myapps.core.dynaform.form.ejb.Form.createDocument(Form.java:1157)
at cn.myapps.core.dynaform.form.ejb.Form.createDocument(Form.java:1082)
at cn.myapps.core.dynaform.form.ejb.Form.createDocument(Form.java:1059)
at cn.myapps.core.dynaform.document.ejb.DocumentProcessBean.doNew(DocumentProcessBean.java:176)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
... 48 more

var ats=createOptions();
ats.add("","");
var sql="SELECT top 1000 t.name item_name,t.domain_id domainid,t.id item_id FROM ( SELECT name,domain_id,id FROM [BPMDB].[dbo].[T_DEPARTMENT]) t WHERE 1=1 order by t.NAME,t.domain_id,t.id";
println("sql="+sql);
var query = queryBySQL(sql);
/*
if(query!=null){
          var iter  =query.iterator();
          while(iter != null && iter.hasNext()){
               var doc = iter.next();
               ats.add(doc.getItemValueAsString("name"),doc.getItemValueAsString("id"));   
          }
}
*/
ats;

来  脚本   麻烦速度吧。。......

结贴。大神

感谢楼主反馈  该贴结贴