{"inframe":false,"title":"查询","hidden":false,"roles":{"dev":1},"children":[{"configs":{"serverScript":"var data = app.fetch(),\n  whereSql = [];\nif (data.fromDate)\n  whereSql.push('LOG_DATE>={?timestamp.fromDate?}');\nif (data.toDate)\n  whereSql.push('LOG_DATE<={?timestamp.toDate?}');\nif (data.userName)\n  whereSql.push('USER_NAME={?userName?}');\nif (data.ip)\n  whereSql.push('IP={?ip?}');\nif (data.logType)\n  whereSql.push('LOG_TYPE={?integer.logType?}');\nif (data.msg) {\n  request.setAttribute('msg', '%' + data.msg + '%');\n  whereSql.push('MSG like {?msg?}');\n}\nif (whereSql.length)\n  request.setAttribute('whereSql', ' where ' + whereSql.join(' and '));","itemId":"module"},"children":[{"configs":{"sql":"select * from WB_LOG {#whereSql#} {#sql.orderBy#}","itemId":"dataprovider1","dictTableNames":"WB_LOG"},"children":[],"expanded":false,"type":"dataprovider"}],"expanded":true,"type":"module"}],"pageLink":"","iconCls":""}