3 thoughts on “Purging data provider queries using BO RE Java SDK”

1. Balaji July 27, 2012 at 7:08 pm

   Hi,
   Can you pls provide me this code in and JSP SDK format so that I can use this in our BO plant.

   Your help will be really great and I was looking for this kind long time

   Thanks
   Balaji Karunakaran

   LikeLike

   Reply ↓
2. Balaji July 27, 2012 at 8:34 pm

   Hi bukhantsov,

   Can you plsssss help me out to redefind this purge code to run in Eclipse

   Thanks
   Balaji Karunakaran

   ———————-
   package org.BK.javatool;

   import com.businessobjects.rebean.wi.DataProvider;
   import com.businessobjects.rebean.wi.DataProviders;
   import com.businessobjects.rebean.wi.DocumentInstance;
   import com.businessobjects.rebean.wi.ObjectQualification;
   import com.businessobjects.rebean.wi.ReportDictionary;
   import com.businessobjects.rebean.wi.ReportEngine;
   import com.businessobjects.rebean.wi.ReportEngines;
   import com.businessobjects.rebean.wi.SQLDataProvider;
   import com.businessobjects.rebean.wi.VariableExpression;
   import com.crystaldecisions.sdk.exception.SDKException;
   import com.crystaldecisions.sdk.framework.CrystalEnterprise;
   import com.crystaldecisions.sdk.framework.IEnterpriseSession;
   import com.crystaldecisions.sdk.framework.ISessionMgr;
   import com.crystaldecisions.sdk.occa.infostore.IInfoObject;
   import com.crystaldecisions.sdk.occa.infostore.IInfoObjects;
   import com.crystaldecisions.sdk.occa.infostore.IInfoStore;

   public class SDKBO {

   public static void main(String[] args) {
   IEnterpriseSession enterpriseSession = null;
   ReportEngines reportEngines = null;
   try {
   System.out.println(“Connecting…”);
   ISessionMgr sessionMgr = CrystalEnterprise.getSessionMgr();
   enterpriseSession = sessionMgr.logon(“Administrator”, “”,
   “Coq3bobjapp01:7400”, “secEnterprise”);
   reportEngines = (ReportEngines) enterpriseSession
   .getService(“ReportEngines”);
   ReportEngine wiRepEngine = (ReportEngine) reportEngines
   .getService(ReportEngines.ReportEngineType.WI_REPORT_ENGINE);
   IInfoStore infoStore = (IInfoStore) enterpriseSession
   .getService(“InfoStore”);
   String query = “select SI_NAME, SI_ID from CI_INFOOBJECTS ”
   + “where SI_KIND = ‘Webi’ and SI_INSTANCE=0”;
   IInfoObjects infoObjects = (IInfoObjects) infoStore.query(query);
   for (Object object : infoObjects) {
   IInfoObject infoObject = (IInfoObject) object;
   String path = getInfoObjectPath(infoObject);
   if (path.startsWith(“/”)) {
   DocumentInstance widoc = wiRepEngine
   .openDocument(infoObject.getID());
   String doc = infoObject.getTitle();
   System.out.println(path + “/” + doc);
   printDocumentVariables(widoc);
   //addReplaceVariable(widoc, “VERSION”, “=\”12.00.18.00\””);
   //purgeQueries(widoc);
   widoc.closeDocument();
   }
   }
   } catch (SDKException ex) {
   ex.printStackTrace();
   } finally {
   if (reportEngines != null)
   reportEngines.close();
   if (enterpriseSession != null)
   enterpriseSession.logoff();
   }
   System.out.println(“Finished!”);
   }

   public static void purgeQueries(DocumentInstance widoc) {
   DataProviders dps = widoc.getDataProviders();
   for (int i = 0; i < dps.getCount(); ++i) {
   DataProvider dp = (DataProvider) dps.getItem(i);
   if (dp instanceof SQLDataProvider) {
   System.out.println("Data provider: " + dp.getName());
   SQLDataProvider sdp = (SQLDataProvider) dp;
   sdp.purge(true); // true means purge prompt values
   sdp.generateQuery();
   sdp.resetSQL();
   }
   }
   )

   LikeLike

   Reply ↓
3. Balaji August 1, 2012 at 5:42 pm

   Hi Any update on the above ??

   Thanks
   Balaji Karunakaran

   LikeLike

   Reply ↓