|
本帖最后由 qweasdzxc 于 2017-3-29 15:56 编辑
饼图为什设置了data属性,没设置config,以后显示像014
我的代码如下:
var libraryId=row.row.SAM_LIBRARY.value.latestValue;
var params = new biz.Request.ActionParam();
params.setString("libraryId", libraryId);
biz.Request.sendBizRequest({
"context" : this.getContext(),
"action" : "getPie",
"parameters" : params,
"directExecute" : true,
"callback" : function(data) {
debugger
}
});
public static Table getPie(String libraryId){
System.out.println("libraryId:"+libraryId);
String sql = "select flag2.fenleiId,flag2.fFacetID,flag2.fFacetName,nvl(count(*),0) as num from (SELECT c.fID as fAssetID,c.fName as fAssetName,c.fFacet as fFacetIds,"+
"c.fFacetLabel as fFacet FROM SAM_ASSET c WHERE c.fLibraryId='"+libraryId+"') flag1 LEFT JOIN (SELECT b.fID as fFacetID,"+
"b.fnAME as fFacetName,a.fid as fenleiId,a.FNAME as fenlei FROM SAM_FacetTerm b LEFT JOIN SAM_FacetTerm a ON b.fParentId = a.fid "+
"WHERE a.fLibraryId = '"+libraryId+"') flag2 on instr(flag1.fFacetIds,flag2.fFacetID) > 0 "+
"GROUP BY flag2.fenleiId,flag2.fFacetID,flag2.fFacetName";
Table table=SQL.select(sql, null, "/SAM/assetManage/data", null);
return table;
}
debugger能看到有数据返回
|
|