查询有问题的流程 select t1.requestid,t1.requestmark,t1.createdate, t1.createtime,t1.creater, t1.creatertype, t1.workflowid, t1.requestname, t1.requestnamenew, t1.status,t1.requestlevel,t1.currentnodeid, t2.viewtype,t2.userid,t2.receivedate,t2.receivetime,t2.isremark,t2.nodeid,t2.agentorbyagentid, t2.agenttype,t2.isprocessed,t2.usertype,t1.deleted,t2.takisremark,t2.islasttimes,t1.currentstatus from workflow_requestbase t1,workflow_currentoperator t2…
SELECT TOP 30 = ROUND(avg_total_user_cost * avg_user_impact * (user_seeks + user_scans),0) , avg_user_impact , TableName…
–not in 优化 select RIGHT(MATNR,11) as MATNR,QUNTY,PLNMG,ERDAT from (select MATNR,QUNTY,PLNMG,ERDAT from ZZMAST union all select…
根据字段查流程 select c.id,c.workflowname,b.indexdesc,a.fieldname from workflow_billfield a, HtmlLabelIndex b ,workflow_base c where b.id = a.fieldlabel and…
–删除归档结点的doFieldSQL delete from workflow_nodefieldattr where nodeid in ( select nodeid from workflow_flownode where nodetype =3…
优化SQL必备： SELECT TOP 1000 ST. TEXT AS ‘执行的SQL语句’, QS.execution_count AS ‘执行次数’, QS.total_elapsed_time AS ‘耗时’, QS.total_logical_reads…
泛微明细表、子表， 数据删除后，再添加行，JS添加的数据不起作用的问题 function changeReq(){ var v = cus_getFieldValue(‘field11022’); var els0 = $(‘input’) // 获取子表，从0开始，此处为明细表1 var…
根据流程名称找流程表单 select a.workflowname,b.tablename from workflow_base a,workflow_bill b where a.formid = b.id
—— 顶部菜单，菜单排序 SELECT c.labelname,a.* FROM HrmUserMenuStatictics a,LeftMenuInfo b,HtmlLabelInfo c WHERE a.menuid=b.id and b.labelid=c.indexid and c.languageid=7…
Java实现文件下载
kim