|

楼主 |
发表于 2018-12-27 10:55:10
|
显示全部楼层
是设置bizdata的read使用,你发的参考链接我看过了 action的参数都是有的 系统默认的queryaction有的参数我都有
public static Table queryCustomerCategoryData(List<DataPermission> range, String concept, String select, String from, String aggregate, String dataModel, String fnModel, String condition,
Boolean distinct, String idColumn, String filter, int limit, int offset, String columns, String orderBy, String aggregateColumns, Map<String, Object> variables) {
Map<String, String> sqlMap = new HashMap<String, String>();
String sql = "SELECT * FROM (SELECT P.*, T.CUSTOMERCATEGORYNAME AS levelCustomer FROM P_CustomerCategory P LEFT JOIN P_CustomerCategory T ON T.FID = P.PARENT)";
sqlMap.clear();
sqlMap.put("ORACLE", sql);
Table tab = SQL.select(sqlMap, null, dataModel);
tab.getProperties().put(Table.PROP_NAME_ROWID, "FID");
String countSql = "select count(*) as cnt from P_CustomerCategory";
Map<String, String> countMap = new HashMap<String, String>();
countMap.clear();
countMap.put("ORACLE", countSql);
Table countTable = SQL.select(countMap, null, dataModel);
BigDecimal num = countTable.iterator().next().getDecimal("CNT");
tab.getProperties().put(Table.PROP_DB_COUNT, num);
return tab;
}
action.m和ontology.m对应的也有相关参数 |
|