[SOLVED]WF8 - BIP - How to Load Panel 2 From Panel 1?

How to I trigger a focexec in panel 1, and have the results show in panel 2, on a given BIP page (8.0.07)?

I have two panels, each in its own column on a BIP page.

In 'panel2' I have the following report focexec:

-*
-* Focexec: panel2_report.fex
-*
-DEFAULTH &CAR = 'AUDI'
-*
TABLE FILE CAR
"Time: &TOD"
PRINT CAR
BY    COUNTRY
IF    CAR EQ &CAR
END

In 'panel1' I have the following launch page focexec:

-*
-* Focexec: panel1_launch.fex
-*
-SET &RANDOM = RDUNIF(D5) * RDUNIF(D5) * 10000;
-*
-HTMLFORM BEGIN NOEVAL
<!DOCTYPE html>
<html>
<head>
<title>Panel 1 - Launch</title>
<script language='javascript'>
//
// Function: fn_loadpanel2
// Purpose : Load panel 2 on BIP page.
//
function fn_loadpanel2() {
  var panel2url =  'http://myserver:8080/ibi_apps/view.bip?BIP_REQUEST_TYPE=BIP_LAUNCH';
      panel2url += '&BIP_folder=IBFS:/WFC/Repository/test/std_reports/davidbtestin';
      panel2url += '&BIP_item=panel2_report.fex&WF_STYLE_HEIGHT=495&WF_STYLE_WIDTH=984';
      panel2url += '&WF_STYLE_UNITS=PIXELS&IBIWF_redirNewWindow=true&BIP_CACHE=100000&CAR=' + document.form1.car.value;
      panel2url += '&BIP_rand=!IBI.AMP.RANDOM;' ;
  // alert(panel2url);
  window.open(panel2url);
}
</script>
</head>
<body>
<form name="form1">
Car: <input type="text" name="car" value="BMW"> <br><br>
<button type="button" onclick="javascript:fn_loadpanel2();">Run Panel 2 Report</button>
</form>
</body>
</html>
-HTMLFORM END

At them moment, upon clicking the 'run' button, the report appears AOK in a new window.

How do I get the report to appear in 'panel 2'?

This message has been edited. Last edited by: <Emily McAllister>,

Pilot: WebFOCUS 8.2.06 Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2016/Tomcat Standalone Workstation: Windows 10/IE11+Edge Database: Oracle 12c, Netezza, & MS SQL Server 2019 Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer & ReportCaster

Posts: 822 | Registered: April 23, 2003

CoolGuy

Virtuoso

posted

Hide Post

First off, I am sorry you have to work in the 8.0.07 release. Secondly, I am not sure what you could do to accomplish that within that release. I had that same issue/desire and found I wouldn't be able to do that until they added to their product interface API in 8.1.05. Luckily, we are on that now. They've added a new Js function to their iframeinterface.js scripts found at \\serverName\ibi\WebFOCUS81\webapps\webfocus\tools\portalcanvas called navigateToPage() that allows the dev to pass in the page to navigate to (could be the same page you are already on), and which panels (can be more than one, or just one) to refresh with any params you'd like to pass as well.

Once in 8.1.05, study the following: Page/panel "drills" (or just per panel execution)

This is only available as of 8.1.05 though, sadly.

8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.

Posts: 1113 | Location: USA | Registered: January 27, 2015

Ignored post by CoolGuy posted

Show Post

David Briars

Master

posted

Hide Post

A couple of minor updates, and now panel 1 is loading panel 2:

-*
-* Focexec: panel1_launch.fex
-*
-HTMLFORM BEGIN NOEVAL
<!DOCTYPE html>
<html>
<head>
<title>Panel 1 - Launch</title>
<script language='javascript'>
//
// Function: fn_loadpanel2
// Purpose : Load panel 2 on BIP page.
//
function fn_loadpanel2() {
  var rand = 0;
  rand = Math.round(Math.random() * 100000);
  var panel2url =  'http://server:8080/ibi_apps/view.bip?BIP_REQUEST_TYPE=BIP_LAUNCH';
      panel2url += '&BIP_folder=IBFS:/WFC/Repository/test/std_reports/davidbtestin';
      panel2url += '&BIP_item=panel2_report.fex&WF_STYLE_HEIGHT=495&WF_STYLE_WIDTH=984';
      panel2url += '&WF_STYLE_UNITS=PIXELS&IBIWF_redirNewWindow=true&BIP_CACHE=100000&CAR=' + document.form1.car.value;
      panel2url += '&BIP_rand=' + rand;
  //alert(panel2url);
  parent.window.frames['Panel_2_1'].location=panel2url;
}
</script>
</head>
<body>
<form name="form1">
 Car: <input type="text" name="car" value="BMW"> <br><br>
 <button type="button" onclick="javascript:fn_loadpanel2();">Run Panel 2 Report</button>
</form>
</body>
</html>
-HTMLFORM END

Posts: 822 | Registered: April 23, 2003

Ignored post by David Briars posted

Show Post

stur0063

Platinum Member

posted

Hide Post

quote:
new Js function to their iframeinterface.js scripts found at \\serverName\ibi\WebFOCUS81\webapps\webfocus\tools\portalcanvas called navigateToPage()

I followed these instructions - I got it to work BUT...... it seems to only hop to the page once and change the parameter. Subsequent drill downs don't change my parameter. Only the "first" one does.

Anyone else have this issue with navigateToPage()?

-* File: IBFS:/dev81/WFC/Repository/Testing/navigateBIP/Report1.fex Created by WebFOCUS AppStudio
-DEFAULTH &COUNTRY = _FOC_NULL;
TABLE FILE CAR
BY  CAR.ORIGIN.COUNTRY
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE SET JSURLS '/ibi_apps/tools/portalcanvas/iframeinterface.js'
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
-* This works if we just want to refresh all (tabs of BIP I assume) - but it doesn't JUMP to the page
-*TYPE=REPORT,
-*     DRILLMENUITEM='PassCountryToBI_Tab',
-*          JAVASCRIPT=drillRefresh( \
-*     'AMPERS_PORTAL' \
-*     'COUNTRY' \
-*     N1 \
-*     ),
-*          TARGET='_self',
-*$


-*page5 is my "PickHopHere" page - this does the hopping
-*hopToMe2 is the Panel I want ot refresh.  Sounds like we can have a single BIP page with multipe panels with the data that consumes these variables.
-*COUNTRY is the variable I'm passing...and the receiving end should recive it.

TYPE=REPORT,
     DRILLMENUITEM='Hope To Tab',
          JAVASCRIPT=navigateToPage( \
     'page5' \										
	 'hopToMe2' \									
     'COUNTRY' \									
     N1 \
     ),          
          TARGET='_self',
$

ENDSTYLE
END

webFOCUS 8207.15
WindowsServer 2019

Posts: 120 | Location: Minnesota | Registered: August 26, 2013

Ignored post by stur0063 posted

Show Post

stur0063

Platinum Member

posted

Hide Post

FYI: I did get this to work - but I had to toggle the BIP page "Refresh on Click" - but I'm not certain I should have done that - it feels like overkill - and if we had a complicated page with many *.fex - I'm not sure I'd want it to refresh all the time.

Anyone got an alternative way to make the navigateToPage function honor the passed in parameter each time?

webFOCUS 8207.15
WindowsServer 2019

Posts: 120 | Location: Minnesota | Registered: August 26, 2013

Ignored post by stur0063 posted

Show Post

CoolGuy

Virtuoso

posted

Hide Post

Thanks David and stur0063 for your code and updates! Way great to have as reference.

8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.

Posts: 1113 | Location: USA | Registered: January 27, 2015

Ignored post by CoolGuy posted