Hi,
can someone give me an example of how to create a subject line dynamically.i want to display the parameters that i pass to the report in my subject line.
Thanks

Good Morning Chelsea :
Are you talking about email distribution via Report Caster ?

Please also update your signature to show your platform / WF release etc. It always helps when people try to answer your Q.

Thanks,
Sandeep M.

Chelsea,
Please also look at this previous forum entry on the same topic -

Linky

Hope that helps,
Sandeep M.

Hi BlueZone,
i tried the example that is there in the report-caster help and it worked when i assigned the parameter and the value in the advanced tab of the task option of the schedule and usedit in the subject line .what i want to see is if there is a way that we specify the parameter in the subject line and it takes the value of the parameter from the report rather then specifying the valued in the advanced option of reportcaster.
Thanks

HI,
any ideas on how this can be done
thanks
kumar

You may be able to do something with the RC API - maybe setMailSubject(String)function but that's probably not what your looking for since it's a bit complex.

Sounds like a new feature request.

I am trying to do have a subject line say: REPORT XX (followed by the current date).
I tried REPORT XX '&DATE' in the subject line but did not see the date appear in the actual subject line. Instead, I saw 'REPORT XX' and in the log i saw it say unknown parameter DATE.
Must I specify elsewhere this parm? How/where?

Thanks, Ira
wf 536 AIX533

I checked on this once. It is not supported.

Someone may have already requested and NFR (New Feature Request) but it doesn't hurt to give IBI more ammunition. So I would suggest that you open a case.

GinnyJakes - Thanks, I had opened up a case. I was wondering what do you think of this as a workaround (dare I say that?)

table &DATE to save file - read it back in to an &&variable. include that condition in a where clause somehow. Would subject line then recognize that &&? Not totally thought out yet as you can see - just a thought...


Ira
AIX 533 wf 5.3.6 (dev) 5.3.3 (prod) 7.6.1 (test)

I don't think that will work. Please see a very similar thread and Gerry's comments about what is allowed and not allowed. According to Gerry, the variable has to be in Report Caster, i.e. specified in the Advanced tab of the task.

https://forums.informationbuilders.com/eve/forums/a/tpc/...1057331/m/5351054062

why not build a quick jsp to do a one time submission and set the subject line as you see fit.

Simple Example (/rcaster/custom/scheduleExample.jsp) -- sorry, there was a wee typo:

<%-- $Revision: 1.2 $: --%>
<%@ page language="java" import="ibi.broker.beans.*,ibi.broker.beans.handler.*,java.util.*,java.text.*" %>
<jsp:useBean id="schedFact" scope="request" class="ibi.broker.beans.DSTSchedFactory" />
<%

     /* 
      *  Expected parameters to be passed:
      *
      *  emailFrom = User email who processed the merchandise request.
      *  emailTo   = User who initialiated the merchandise request.
      *  merchId   = Unique merchandise request id.
      *  random    = Random number passed from the calling process.
      *
      */
		Date now = new Date();
		SimpleDateFormat formatter = new SimpleDateFormat( "yyyyMMdd" );
		
		DSTAuthenticate auth = new DSTAuthenticate();

                // expected parameters.
		String emailFrom = request.getParameter("emailFrom");
		String emailTo = request.getParameter("emailTo");
		String country = request.getParameter("COUNTRY");
                String car = request.getParameter("CAR");

		auth.setUser("admin");
		auth.setPass("");
		auth.setAgentProperty("localhost:8200");
		
		// build subject line with passed parms
		String emailSubject = "*** Some Description: Country: " + country + " Car: " + car + " ***"; 
		String interval = "O";
		String startdate = formatter.format(now);
		String starttime = "0600";
		String fex = "merchandise_request_confirmation";
		String[] parNames = {"COUNTRY","CAR"};
		String[] parValues = { country, car };

		schedFact.setAuthenticate(auth);

		schedFact.setIBIB_casteruser("admin");    
		schedFact.setIBIB_jobdesc("*** Some Description.  This will be deleted anyway ***");                            	
		schedFact.setIBIB_active("Y");                                    	
		schedFact.setIBIB_priority("3");                                  	

		schedFact.setIBIB_interval(interval); //Run Once   	
		schedFact.setIBIB_startdate(startdate);                            	
		schedFact.setIBIB_starttime(starttime);                                	
		schedFact.setIBIB_listtype(DSTSchedFactory.ADDRESSTYPE_SINGLEADDRESS); //send to one address	
		schedFact.setIBIB_distlist(emailTo); // access list name    	
		schedFact.setIBIB_method(DSTSchedFactory.METHOD_MAIL);   
		schedFact.setIBIB_mailfrom(emailFrom);
		schedFact.setIBIB_mailuser(emailFrom);
		schedFact.setIBIB_mailsubject(emailSubject);
		schedFact.setIBIB_asvalue("sent.htm");
		schedFact.setIBIB_mulpart("N");

		// notification 
		schedFact.setIBIB_notifyflag(DSTSchedFactory.NOTIFYFLAG_INACTIVE);  	
		schedFact.setIBIB_tasktype(DSTSchedFactory.TASKTYPE_EDA_FOCEXEC); 
		schedFact.setIBIB_servername("EDASERVE");
		schedFact.setIBIB_taskobj(fex); //URL being Schedled
		schedFact.setIBIB_execid("server-userid");
		schedFact.setIBIB_execpass("server-password");
		schedFact.setIBIB_sendformat(DSTSchedFactory.SENDFORMAT_HTML);

		schedFact.setIBIB_paramname(parNames);
		schedFact.setIBIB_paramvalue(parValues);

		schedFact.setIBIB_servername("EDASERVE");  
		
		// delete the job after execution.
		schedFact.setIBIB_deletejob("Y");

		DSTBeanHandler h = schedFact.getCreateScheduleHandler();
		h.processRequest();
		DSTAPIStatus status = h.getAPIStatus();
		int code = status.getErrorCode();
		if(code != DSTAPIStatus.NO_ERROR) {
			out.println("Code = " + code + "; Message = " + status.getErrorMessage());
			return;

		}

		DSTBeanResult result = h.getBeanResult();
		Vector xml = result.getXML();		
		String sid = null;
		String stag = "<IBIB_scheduleid>";
		String etag = "</IBIB_scheduleid>";
		for(int i = 0; i < xml.size(); i++) {
			String temp = (String)xml.elementAt(i);			
			int index = temp.indexOf(stag);
			if(index != -1) {
				int end = temp.indexOf(etag);
				sid = temp.substring(index + stag.length(), end);
				break;
			}
		}
		out.println("Schedule ID = " + sid);
	
%>
<html>
     <head>
     </head>
     <body>
          <h2>Some Confirmation message.</h2>
     </body>
</html>  

Call with:

  
http://server:port/rcaster/custom/scheduleExample.jsp?e...TRY=JAPAN&CAR=DATSON

This message has been edited. Last edited by: dhagen,

Hi Dhagen,
This is nice, the first time I see an example of this functionality.
This can be a good start to do something like this where we need a looping for a rather complex report where burst does not work.

Dhagen, I gotta check it out. This is good! Thanks. GinnyJakes and all other helpful ones - thank you. IBI has an NFR put in place. In the interim their official line is HTTP://TECHSUPPORT.INFORMATIONBUILDERS.COM/SPS/93411036.HTML (see the solution section)...

Ira

there is a little typo in your hyperlink, it looks ok, but it is not.

[URL=HTTP://TECHSUPPORT.INFORMATIONBUILDERS.COM/SPS/93411036.HTML]

Frank, you are absolutely correct. The link actually appeared as 'infromation' instead of 'information' . Try it now...

Dhagen,

This is good stuff. I was easily able to set this up with your example.

Much better than DSTRUN.

Cheers,

Francis.

Dhagen,

Where is this JSP stuff documented?

I searched for "setIBIB_sendformat" on the IBI Tech Support site and the only document displayed wasDSTSchedFactory for WebFOCUS 4.3.

Thanks,

Francis,

Go here:

http://documentation.informationbuilders.com/masterindex/webfocus_53.asp

Look under the API section.

Mickey,

Thank you. I have the API document. I have to say it is quite useless! It provides detailed Java syntax but very poor examples.

I cannot find the text "SENDFORMAT_HTML" anywhere on IBI.