<%@ page import = "com.crystaldecisions.sdk.occa.infostore.*,
com.crystaldecisions.sdk.framework.*,
com.crystaldecisions.sdk.exception.SDKException,
com.crystaldecisions.sdk.properties.*,
java.util.*"
%>
<%
IEnterpriseSession enterpriseSession = null;
try
{
String userName = "administrator";
String password = "";
String cmsName = "localhost";
String authType = "secEnterprise";
enterpriseSession = CrystalEnterprise.getSessionMgr().logon(userName, password, cmsName, authType);
IInfoStore infoStore = (IInfoStore)enterpriseSession.getService("", "InfoStore");
String query = "select top 1000000 si_id, si_name, si_scheduleinfo from ci_infoobjects where si_cuid in ('CUID1','CUID2','CUID3')";
IInfoObjects oInfoObjects = (IInfoObjects)infoStore.query(query) ;
for(int i=0; i< oInfoObjects.size(); i++)
{
IInfoObject oInfoObject = (IInfoObject) oInfoObjects.get(i);
if(oInfoObject.getSchedulingInfo() == null)
{
out.println(oInfoObject.getID() + " schedulinginfo null
");
}
else if(oInfoObject.getSchedulingInfo().properties() == null)
{
out.println(oInfoObject.getID() + " schedulinginfo properties null
");
}
else if(oInfoObject.getSchedulingInfo().properties().getProperty("SI_DESTINATION") == null)
{
out.println(oInfoObject.getID() + " si_destination does not exist
");
}
else
{
IProperties propBag = (IProperties)oInfoObject.getSchedulingInfo().properties().getProperty("SI_DESTINATION").getValue();
if (propBag != null)
oInfoObject.getSchedulingInfo().properties().remove("SI_DESTINATION");
}
}
infoStore.commit(oInfoObjects);
out.println("committed...exiting");
}
catch(SDKException sdkEx)
{
out.println(sdkEx);
}
finally
{
if(enterpriseSession != null)
enterpriseSession.logoff();
}
%>