How to retrieve the publication webi document prompts using Enterprise SDK

[aasavaribhave]

This code gets the prompt values used by publication's source webi documents using Enterprise Java SDK.

<%@ page import = "com.crystaldecisions.sdk.exception.SDKException,<br /> com.crystaldecisions.sdk.framework.*,<br /> com.crystaldecisions.sdk.occa.infostore.*,<br /> com.businessobjects.sdk.plugin.desktop.publication.*,<br /> java.util.*,<br /> com.businessobjects.rebean.wi.*,<br /> com.crystaldecisions.sdk.properties.*"%><%<br /> String username = "administrator";<br /> String password = "<password>";<br /> String cmsname = "<cmsname>";<br /> String authType = "secEnterprise";<br /> IEnterpriseSession enterpriseSession = null;<br /> <br /> enterpriseSession = CrystalEnterprise.getSessionMgr().logon(username, password, cmsname, authType);<br /> IInfoStore infoStore = (IInfoStore)enterpriseSession.getService("", "InfoStore");<br /> IInfoObjects oInfoObjects = (IInfoObjects)infoStore.query("select * from ci_infoobjects where si_kind='publication' and si_name='<publication name>'");<br /> for(int i=0;i<oInfoObjects.size();i++)<br /> {<br />      IInfoObject oInfoObject = (IInfoObject) oInfoObjects.get(i);<br />      IPublication publicationObject = (IPublication) oInfoObject;     <br />      Object[] idArray = publicationObject.getDocuments().toArray();<br />      String clause = "(";<br />      for ( int j=0;j<idArray.length;j++)<br />      {<br />           clause += ((Integer)idArray[j]).intValue() + ",";<br />      }<br />      clause = clause.substring(0,clause.length()-1) + ")";<br />      IInfoObjects webiObjects = infoStore.query("select * from ci_infoobjects where si_id in " + clause);<br />      for (int j=0;j<webiObjects.size();j++)<br />      {<br />           IInfoObject webiObject = (IInfoObject) webiObjects.get(j);<br />           IProperties promptsPropBag = (IProperties) publicationObject.getDocumentProcessingInfo(webiObject.getID()).getProperty("SI_WEBI_PROMPTS").getValue();<br />           int numOfPrompt = ((Integer)promptsPropBag.getProperty("SI_TOTAL").getValue()).intValue();<br />           for (int k=1; k <= numOfPrompt; k++)<br />           {<br />                out.println("Prompt Name = " + ((IProperties)promptsPropBag.getProperty("" + k).getValue()).getProperty("SI_NAME").getValue().toString());<br />                IProperties promptValuesBag = (IProperties) ((IProperties)promptsPropBag.getProperty("" + k).getValue()).getProperty("SI_VALUES").getValue();<br />                int numOfValues = ((Integer)promptValuesBag.getProperty("SI_TOTAL").getValue()).intValue();<br />                for(int l=1; l <= numOfValues; l++)<br />                {<br />                     out.println("Prompt Value = " + promptValuesBag.getProperty("" + l).getValue().toString() );     <br />                }<br />           }<br />      }<br /> }<br /> enterpriseSession.logoff();<br /> %>