Difference between MR and EDASERVE / Applications variables

Do i need to have different variables passed to the WFServlet based on what way i want to access fex's from a html launch page that is not going through MRE but resides in the EDASERVE/Application directory?

For instance: The following hidden variables are passed when the launch page is set in MRE.

  < action=/ibi_apps/WFServlet method="GET" TARGET="_blank">
<INPUT id=ibiapp_app style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=certified_mail name=ibiapp_app>
<INPUT type=hidden value=MR_RUN_FEX name=IBIMR_action>
<INPUT type=hidden value=MR_STD_REPORT name=IBIMR_sub_action>
<INPUT type=hidden name=IBIMR_flags>
<INPUT type=hidden name=IBIMR_random>
<INPUT id=IBIMR_dir type=hidden value=#formqodotk83 name=IBIMR_dir>
<INPUT id=OUTFMT size=1 value=PDF name=OUTFMT>
<INPUT id=IBIMR_folder type=hidden value=certified_mail name=IBIMR_folder>
<INPUT type=hidden value=RUNNID name=IBIMR_drill>

Do these hidden variables "name" need to be different since its NOT sitting in the MRE enviroment but now residing in the EDASERVE/Application directory?

WF 7.1.7- Windows XP

Posts: 63 | Registered: August 28, 2007

Darin Lee

Virtuoso

posted

Hide Post

you can take out all the variables that are IBIMR_ or MR_ . The only thing you'll need is IBIF_ex with the value being the name of the fex in the server path (and, of course, the variables that you are passing like OUTFMT.)

Regards,

Darin

In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat

Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007

Ignored post by Darin Lee posted

Show Post

Erney

Gold member

posted

Hide Post

Thanks a bunch

Guess i spoke too soon, i removed the variable now im getting

WebFOCUS was called with an invalid request. error.. yay me

Anyway thanks for the help.

I have been playing with this now for 3 days and still cannot get it to work correctly. I have posted the whole code snippet below if anyone would like to take a crack at it, if not , no big deal..

thanks guys

  <SCRIPT id=IBI_ibigblloadCss type=text/javascript>
 ibigblloadCss(null);</SCRIPT>

 <SCRIPT id=IBI_RelCallBack type=text/javascript>function AdjustChildrenPosition(){
 }
 </SCRIPT>
 <TITLE>CITIES Collection ADHOC Report</TITLE>
 <SCRIPT id=clientEventHandlersJS type=text/javascript>
 function window_onload() {
 UpdateData();
 // TODO: Add your event handler code here
 }
 </SCRIPT>
<SCRIPT>
 function checkForm() {
    document.Form1.submit();
   }

</SCRIPT>

<!-- ****** Hidden values needed by the WFServlet\WebFocus ******-->

<FORM name="Form1" method="POST" TARGET="_blank">
<INPUT id=OUTFMT size=1 value=PDF name=OUTFMT>
<!-- *************** END HIDDEN VALUES *********** -->

<!-- Hidden Variables to distinguish the visible and invisible properties of the selectable values in the table. -->
 <INPUT type=hidden value=BeginningDate,EndingDate,CaseType,FormatType,DATE_BEGIN_CURRENT_MONTH,CaseTypeID,DATE_PRIV_MTH_END,OUTFMT name=LocStagVis>
 <INPUT type=hidden name=LocStagInvis>

 <INPUT type=hidden value=BeginningDate,EndingDate,CaseType,FormatType,DATE_BEGIN_CURRENT_MONTH,CaseTypeID,DATE_PRIV_MTH_END,OUTFMT name=OfficeVis>
 <INPUT type=hidden value=CaseType,CaseTypeID name=OfficeInvis>
 <SCRIPT for=window eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>
<!-- *********************************************************************************************************** -->
</HEAD>


<BODY style="OVERFLOW: auto" bgcolor="DCD8A2">
<!-- ************ Javascript to tell what report was selected form the drop down menu ************* -->
<!-- **** And also displays what items can be selected in the table based on the hidden values above. ********* -->

 <SCRIPT type=text/javascript>
  function DisplayBoxes(SelectedReport)
  {
  switch (SelectedReport)
  {
  case "ynv8ittb.fex":
    //Collections Summary by Location and Stage
   var VisFields = document.getElementsByName("LocStagVis").item(0).value.split(",")
   var InvisFields = document.getElementsByName("LocStagInvis").item(0).value.split(",")
     break

  case "la5vfg61.fex":
    //Collections Summary by Office
   var VisFields = document.getElementsByName("LocStagVis").item(0).value.split(",")
   var InvisFields = document.getElementsByName("LocStagInvis").item(0).value.split(",")
   break

  case "adtb8kb3.fex":
    //Collections Summary by Office
   var VisFields = document.getElementsByName("LocStagVis").item(0).value.split(",")
   var InvisFields = document.getElementsByName("LocStagInvis").item(0).value.split(",")
   break

  case "ofukdg80.fex":
    //Wage Garnishment Agent Referral
   var VisFields = document.getElementsByName("OfficeVis").item(0).value.split(",")
   var InvisFields = document.getElementsByName("OfficeInvis").item(0).value.split(",")
   break

  case "u7rbb97e.fex":
    //Wage Garnishment Create Employee Cases
   var VisFields = document.getElementsByName("OfficeVis").item(0).value.split(",")
   var InvisFields = document.getElementsByName("OfficeInvis").item(0).value.split(",")
   break

  case "fvprv462.fex":
    //Wage Garnishment Compliance Referral
   var VisFields = document.getElementsByName("OfficeVis").item(0).value.split(",")
   var InvisFields = document.getElementsByName("OfficeInvis").item(0).value.split(",")
   break

  case "t54ebbft.fex":
    //Wage Garnishment Spin-Off
   var VisFields = document.getElementsByName("OfficeVis").item(0).value.split(",")
   var InvisFields = document.getElementsByName("OfficeInvis").item(0).value.split(",")
   break

  case "fn561cnm.fex":
    //Activity Count by Office
   var VisFields = document.getElementsByName("OfficeVis").item(0).value.split(",")
   var InvisFields = document.getElementsByName("OfficeInvis").item(0).value.split(",")
   break

  case "a776rqpc.fex":
    //Activity Count by Employee and Stage
   var VisFields = document.getElementsByName("OfficeVis").item(0).value.split(",")
   var InvisFields = document.getElementsByName("OfficeInvis").item(0).value.split(",")
   break

  case "ax3dgftk.fex":
    //Action / Activity Count by Employee and Stage
   var VisFields = document.getElementsByName("LocStagVis").item(0).value.split(",")
   var InvisFields = document.getElementsByName("LocStagInvis").item(0).value.split(",")
   break

  case "zyho6smv.fex":
    //Action / Activity Count by Stage
   var VisFields = document.getElementsByName("OfficeVis").item(0).value.split(",")
   var InvisFields = document.getElementsByName("OfficeInvis").item(0).value.split(",")
   break

  case "action__.fex":
    //Action / Activity Case Detail by Employee
   var VisFields = document.getElementsByName("OfficeVis").item(0).value.split(",")
   var InvisFields = document.getElementsByName("OfficeInvis").item(0).value.split(",")
   break

  case " ":
   break

  default:
 // alert(SelectedReport)
   break

  }
  for (i=0;i<VisFields.length;i++)
  {
   if (document.getElementsByName(VisFields[i]).length > 0)
   {
    var aElement = document.getElementsByName(VisFields[i]).item(0);
    aElement.style.visibility="visible"

   }
  }
  for (i=0;i<InvisFields.length;i++)
  {
   if (document.getElementsByName(InvisFields[i]).length > 0)
   {
     var aElement = document.getElementsByName(InvisFields[i]).item(0);
     aElement.style.visibility="hidden"
   }
  }
  }
 </SCRIPT>
<!-- ************************* End Javascript for report selection ************ -->

<!-- *********    HTML For selectable items inside the table ****************  -->

<TABLE border=3  align=center style="Z-INDEX: 1;  POSITION: absolute; TOP:75px" bgcolor="EDECD1">
  <TBODY>
   <TR colspan="4">
    <TD>Select Report:
     <SELECT onchange=DisplayBoxes(value) size=1 name=ibif_ex>
      <OPTION></OPTION>
      <OPTION value=fn561cnm.fex>Activity Count by Office</OPTION>
      <OPTION value=a776rqpc.fex>Activity Count by Employee and Stage</OPTION>
      <OPTION value=ax3dgftk.fex>Action / Activity Count by Employee and Stage</OPTION>
      <OPTION value=zyho6smv.fex>Action / Activity Count by Stage</OPTION>
      <OPTION value=action__.fex>Action / Activity Case Detail by Employee</OPTION>
      <OPTION value=ynv8ittb.fex>Collections Summary by Location and Stage</OPTION>
      <OPTION value=la5vfg61.fex>Collections Summary by Office</OPTION>
      <OPTION value=adtb8kb3.fex>Collections Summary by Office and Employee</OPTION>
      <OPTION value=ofukdg80.fex>Wage Garnishment Agent Referral</OPTION>
      <OPTION value=u7rbb97e.fex>Wage Garnishment Create Employee Cases</OPTION>
      <OPTION value=fvprv462.fex>Wage Garnishment Compliance Referral</OPTION>
      <OPTION value=t54ebbft.fex>Wage Garnishment Spin-Off</OPTION>
     </SELECT>
    </TD>
    <TD></TD>
    <TR>
     <TD></TD>
     <TD align=left><LABEL id=BeginningDate title="Select the beginning Date" name=BeginningDate>Beginning Date:</LABEL></TD>
     <TD><INPUT id=DATE_BEGIN_CURRENT_MONTH accept=0 size=10 name=DATE_BEGIN_CURRENT_MONTH elementtype="14" sourcetype="typeMaster" datafieldtype="CHAR" datatype="0" requiredfield="126935600" addalloption="0" ibiformat="MDYY" calendardata="1/1/2000;12/31/2015" calendardatatype="0"></TD>
    </TR>
    <TR>
     <TD></TD>
     <TD><LABEL id=EndingDate title="Select the ending date for the repot" name=EndingDate>Ending Date:</LABEL></TD>
     <TD><INPUT id=DATE_PRIV_MTH_END accept=0 size=10 name=DATE_PRIV_MTH_END elementtype="14" sourcetype="typeMaster" datafieldtype="CHAR" datatype="0" requiredfield="126935600" addalloption="0" ibiformat="MDYY" calendardata="1/1/2000;12/31/2015" calendardatatype="0"></TD>
    </TR>
    <TR>
     <TD></TD>
     <TD><LABEL id=CaseType title="Select the case type for the report" name=CaseType>Case Type ID:</LABEL></TD>
     <TD>
      <SELECT size=1 name=CaseTypeID width="100%">
       <OPTION value="(C.CASE_TYPE_ID = 1 or c.case_type_id=2)" selected>PIT and IT</OPTION>
       <OPTION value="C.CASE_TYPE_ID = 2">PIT</OPTION>
       <OPTION value="C.CASE_TYPE_ID = 1">IT</OPTION>
      </SELECT>
     </TD>
    </TR>
    <TR>
     <TD></TD>
     <TD><LABEL id=FormatType title="Select the output format of the report." name=FormatType>Output Format:</LABEL></TD>
     <TD><SELECT size=1 name=OUTFMT>
       <OPTION value=PDF selected>Adobe Acrobat PDF</OPTION>
       <OPTION value=HTML>HTML</OPTION>
       <OPTION value=EXL2K>Excel 2000</OPTION>
      </SELECT>
     </TD>
    </TR>
    <TR>
     <TD></TD>
     <TD>MRE User<input type="data" name=IBIC_user value=""></td>
     <TD>MRE Password<input type="password" name=IBIC_pass value=""></td>


    </TR>
     <TD colspan=3 align=center><INPUT onclick=checkForm() type=button value="Run Report"></td>

    <!--<TD colspan=3 align=center><INPUT type="SUBMIT" value="Run Report" name=submit></TD>-->
    </TR>
   </TR>
  </TBODY>
 </TABLE>
 </FORM>
<!-- ***************** END HTML FOR SELECTABLE ITEMS *********** -->

<!-- ************ BANNER DISPLAYED ALONG THE TOP OF THE PAGE ******** -->
<!-- *** Note: The src name is the name web focus assigns to the .gif *** -->
 <IMG id=image1 style="Z-INDEX: 1; LEFT: 0px; POSITION: absolute; TOP: 0px" tabIndex=1 src="mdmm65yv.gif" border=0 name=image1>
<!-- *** END BANNER DISPLAY *** -->

</BODY>
<SCRIPT id=IBI_loadcalendar type=text/javascript>
 if(ibigblInitInfo.testOptions(dyncalendar)){
      setDateRange();
      setupDocCalendars();
  }
</SCRIPT>
</HTML>

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

WF 7.1.7- Windows XP

Posts: 63 | Registered: August 28, 2007

Ignored post by Erney posted

Show Post

GinnyJakes

Expert

posted

Hide Post

Don't forget IBIAPP_app should point to the directory where the focexec is in ibi/apps. That is especially important if that directory is not in the global path and you are running from a browser.

Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google

Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006

Ignored post by GinnyJakes posted

Show Post

GamP

Virtuoso

posted

Hide Post

Erney,

The error you're getting: ' WebFOCUS was called with an invalid request' is the result of some parameters being absent or mistyped in the request.
In this case it concerns your ibif_ex variable, which is misspelled.
It should read IBIF_ex (the servlet are quite case sensitive....).
This should solve your invalid request problem.

GamP