{"title":"查询人员","inframe":false,"hidden":false,"roles":{"demo":1,"dev":1},"pageLink":"","children":[{"configs":{"itemId":"module"},"children":[{"configs":{"sql":"select\na.FIRST_NAME,a.LAST_NAME,b.BIRTH_DATE,b.SEX,b.VACATION_HOURS,c.DEPT_NAME\nfrom WB_CONTACT a, WB_EMPLOYEE b, WB_EMP_DEPT c\nwhere a.CONTACT_ID=b.CONTACT_ID and b.DEPT_ID=c.DEPT_ID order by a.FIRST_NAME,a.LAST_NAME","fieldsTag":"[{\n  name: 'VACATION_DAYS',\n  type: 'float',\n  convert: function(value, record) {\n    /* 如果从数据库中提取数据，建议在SQL表达式中直接生成计算列，如select a, b, a + b as \"c\" from table */\n    if (value)\n      return value;\n    else\n      return record.get('VACATION_HOURS') / 8;\n  }\n}]","itemId":"dataprovider1"},"children":[],"type":"dataprovider","expanded":false}],"type":"module","expanded":true}],"iconCls":""}