ITPub博客

首页 > 应用开发 > IT综合 > 【BO-SDK】-(RAS) Get all Available and Userd Fields_@old_devlib_02

【BO-SDK】-(RAS) Get all Available and Userd Fields_@old_devlib_02

原创 IT综合 作者:xiangjinling 时间:2010-09-21 15:17:23 0 删除 编辑
Get all Available and Userd Fields[@more@]

--------------------call side-----

myClientDocument = myReportfactory.openDocument(oInfoObject, 0, Locale.ENGLISH);
Fields usedF = null;
usedF=getUsedDatabaseFields(myClientDocument);
for(int j=0;jSystem.out.println(usedF.getField(j).getLongName(Locale.ENGLISH));
}
System.out.println("*************");
Fields availableF = null;
availableF=getAvailableDatabaseFields(myClientDocument);
for(int j=0;jSystem.out.println(availableF.getField(j).getLongName(Locale.ENGLISH));
}

-----------------------------------------

static Fields getUsedDatabaseFields(ReportClientDocument reportClientDocument){
Fields usedFields = new Fields();
Fields resultFields = null;
try {
resultFields=reportClientDocument.getDataDefController().getDataDefinition().getResultFields();
for(int i=0;iif(resultFields.getField(i).getKind()== FieldKind.DBField){
usedFields.add(resultFields.getField(i));
}
}

} catch (ReportSDKException e) {e.printStackTrace();}

return usedFields;
}

static Fields getAvailableDatabaseFields(ReportClientDocument reportClientDocument){
Tables tables=null;
try {
tables = reportClientDocument.getDatabaseController().getDatabase().getTables();

} catch (ReportSDKException e) {e.printStackTrace();}

Fields fields = new Fields();
for(int k=0;kfor(int r=0;rIField field=tables.getTable(k).getDataFields().getField(r);
fields.add(field);
}
}
return fields;
}

-------------------------Console result:-----------------

Customer.Country
Customer.City
*************
Customer.Customer ID
Customer.Customer Credit ID
Customer.Customer Name
Customer.Contact First Name
Customer.Contact Last Name
Customer.Contact Title
Customer.Contact Position
Customer.Last Year's Sales
Customer.Address1
Customer.Address2
Customer.City
Customer.Region
Customer.Country
Customer.Postal Code
Customer.E-mail
Customer.Web Site
Customer.Phone
Customer.Fax
Orders.Order ID
Orders.Order Amount
Orders.Customer ID
Orders.Employee ID
Orders.Order Date
Orders.Required Date
Orders.Ship Date
Orders.Courier Website
Orders.Ship Via
Orders.Shipped
Orders.PO#
Orders.Payment Received

--------------------.rpt file view:------------------

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/24167472/viewspace-1038725/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-06-29

  • 博文量
    19
  • 访问量
    26371