0

Is it possible to retrieve the SQL queries from a report in business objects using the SDK.

Any tutorials or code would be useful.

regards, nithen

user727272
  • 475
  • 2
  • 9
  • 20

1 Answers1

0

I'll assume you know how to get a WebI DocumentInstance object via the Java SDK.

DocumentInstance docInst; // get your DocumentInstance object via preferred route
DataProvider dp = docInst.getDataProviders().getItem(0); // retrieve the DataProvider that you would like the SQL for
String sql = dp.getQuery().getSQL(); // the SQL out of the DataProvider

getSQL() is depreciated so it may vanish in the next version

shrub34
  • 796
  • 6
  • 17