[CLOSED]Portal to Portal Linkage 8.2.02

January 18, 2018, 03:04 PM

Hi ,

Is there a way to have a initial page with links to other pages?

Like "home page" with links to the other pages in the portal.
Eg:
We have the following fex file in one portal and when we click on the car name( column 2), another portal pop up with the car details.

TABLE FILE CAR
SUM SALES

BY CAR
BY MODEL
WHERE CAR EQ '&CAR';
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
END

Fex file for 2nd portal:

TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR

ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
-INCLUDE IBFS:/WFC/Repository/Aerotek/Common/Style/aerotek_rpt.sty
$
TYPE=DATA, COLUMN=N2, FONT='ARIAL', SIZE=9, WRAP=OFF, SQUEEZE=.6, JUSTIFY=CENTER,
TARGET='_blank',
FOCEXEC=IBFS:/WFC/Repository/Test/Car_drill.fex( \
CAR = N2 \

),

$
ENDSTYLE
END

Thank you in advance.

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

January 18, 2018, 03:23 PM

Waz

That a very good question.

I would like to know too.

Perhaps someone from IBI can comment.

But MeM, you may have to put a case in through Tech Support

January 18, 2018, 04:11 PM

David Briars

This thread discusses calling a portal while passing parms:

http://forums.informationbuild...7062886?r=9137082886

I don't think there are too many other threads that discuss a solution.

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

January 18, 2018, 04:11 PM

FP Mod Chuck

MeM

I am not sure I am clear on what you want to do but on a portal page you can have multiple panels and a drill down from one can populate another.

January 18, 2018, 04:55 PM

Waz

I think MeM is asking if you can drill from one page to another, not panels in a page.

January 19, 2018, 04:47 AM

Tony A

A drill from one page to another page within the same portal can be achieved using the following drilldown syntax (obviously the column reference etc. would be relevant to your code) -

TYPE=DATA,
COLUMN=N1,
JAVASCRIPT=navigateToPage( \
           'page4' \
           'drilldownfex' \
           'variablename' \
           N1 \
           ),
$

Navigation will be passed to the page referenced.

You can find the page value from the Portal Editor - referred to as "Page Name".

The variable name and it's value will be passed to all procedures contained within that page.

T

January 19, 2018, 04:52 AM

Tony A

Just a note to add that this is portal navigation specific, therefore it will not function outside of a portal page - i.e. when run from App Studio.

You will also need to add a JSURL to your report -

SET JSURL = '/ibi_apps/tools/portalcanvas/iframeinterface.js'

January 19, 2018, 08:48 AM

MeM

quote:
Originally posted by Tony A:
Just a note to add that this is portal navigation specific, therefore it will not function outside of a portal page - i.e. when run from App Studio.

You will also need to add a JSURL to your report -
SET JSURL = '/ibi_apps/tools/portalcanvas/iframeinterface.js'
T

Thank you Tony. But I want drill down from one portal to another not within the same portal.

January 19, 2018, 09:24 AM

Tony A

I thought as much, but replied "just in case". I'm sure someone else will want the detail.

As for your request, I would suggest that you raise a case with tech support.

T

January 19, 2018, 12:30 PM

FP Mod Chuck

Hi MeM

I do not see a way to accomplish this. I suggest you submit a New Feature Request via techsupport, it seems like a good idea to me.

January 19, 2018, 01:25 PM

dbeagan

I found this: https://techsupport.informatio...om/sps/20403542.html

Which has the code:

<!DOCTYPE html>
<html lang="en" xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8" />
<title></title>
</head>
<body>
<button type="button"
onclick="parent.BipIframeInterface.navigateToPage('page1');">Open Page1</button>
<button type="button"
onclick="parent.BipIframeInterface.navigateToPage('page2');">Open Page2</button>
</body>
</html>

This worked for me in 8.2.02 when I made sure that 'page1' and 'page2' were each page's Name not the Title. You have to look at the pages properties for this.
If the portal page's properties shows a .page at the end like this:

Name Overview.page

Just use the 'Overview' part of the name like this:

<button type="button"
onclick="parent.BipIframeInterface.navigateToPage('Overview');">Open Page1</button>

January 19, 2018, 03:38 PM

MeM

Thank you all. I have opened up a case with IB and will update it over here once I get the solution from them.

January 19, 2018, 06:56 PM

CoolGuy

MeM,

Seeing as how you're on 8202, you are able to use the new "V4" portal architecture they've added. As you've seen, the portal pages you create have a .page extension on them. From what I was taught by a guy in the know at IBI about this, the pages no longer "belong" to a specific portal anymore. So, you could very well reference one page from another using (most likely) the method dbeagan has outlined. I haven't tried it myself, but it looks like it could do the trick. As for the target of the drill, I would think you could merely have it open in a new window (target='_blank'). I'm not sure if the portal container itself supports the ability to hot-swap pages on top of one another, but wouldn't see why it couldn't be done if you first ensure your .page houses a responsive panel container that can run an AppStudio HTML page with a reference to the new .page and hidden inputs with params (my workaround brain thinking).

January 21, 2018, 03:07 PM

Waz

quote:
A drill from one page to another page within the same portal

Awesome Tony

January 23, 2018, 11:02 AM

MeM

IB guy said its not possible. Does anybody have any alternate idea how I can implement this? I was thinking that the drill down report open up in a new tab of the same portal but that is also not possible. Is there any other way I can complete my project?

Thank you in advance.

January 24, 2018, 02:34 PM

FP Mod Chuck

MeM

I think the closest thing you can get is to use the Drill Down Type of Refresh BI Portal and have a second panel on the same portal tab where the results will display.

January 24, 2018, 03:09 PM

MeM

Thank you Chuck. Since there are 4-5 reports on the second panel, it will be difficult to display them on the same tab. Is it possible to have second tab on the same portal with all those reports?

January 24, 2018, 03:21 PM

FP Mod Chuck

You can use a tab or accordion object on a portal page to allow the reports to display and save on real estate.

January 24, 2018, 03:28 PM

MeM

Is it possible for you to provide me an example for this?

Thanks in advance.

January 24, 2018, 03:36 PM

CoolGuy

Just got our 8202 test environment up and running. About to dig into the new WF Designer to see what it can and can't do. Did see mention of what Chuck was saying that you can do accordion and tabbed containers within the docs. I'd search there for some help as well. Not sure if 8202 comes with new samples beyond what they had via the Retail Samples domain content, but will know soon enough.
8202 documentation link

January 24, 2018, 03:39 PM

FP Mod Chuck

MeM

It is not something that I can post. When you are in the portal designer under the Insert menu option there are icons for a tab container and accordian container and then you drop your content into them. It is pretty straight forward.

January 25, 2018, 01:50 PM

MeM

Thank you Chuck and cool guy, I will try this.

January 31, 2018, 08:04 AM

MeM

It can be done using a Global Variable "&&"

1) in Portal1 - create one report COUNTRY.fex

with a drill down to the Portal2 procedure : COUNTRY.fex

2) in this COUNTRY.fex (Portal2) Use GLOBAL variable &&COUNTRY to store the &COUNTRY from the Portal1 and open the Portal2

-SET &&COUNTRY=&COUNTRY;

-HTMLFORM BEGIN

<script type="text/javascript">

window.location='//csshxc:18080/ibi_apps/portal/Portal2/Portal2';

3) now

In each reports in Portal2 : COUNTRY_1 & COUNTRY_1_1

USE THE &&COUNTRY for the filter

WHERE CAR.ORIGIN.COUNTRY EQ '&&COUNTRY'

January 31, 2018, 12:57 PM

FP Mod Chuck

MeM

Thanks for the update. This is good to know!

March 26, 2019, 03:00 AM

Bajr

quote:
Originally posted by Tony A:
A drill from one page to another page within the same portal can be achieved using the following drilldown syntax (obviously the column reference etc. would be relevant to your code) -
TYPE=DATA,
COLUMN=N1,
JAVASCRIPT=navigateToPage( \
           'page4' \
           'drilldownfex' \
           'variablename' \
           N1 \
           ),
$
Navigation will be passed to the page referenced.

You can find the page value from the Portal Editor - referred to as "Page Name".

The variable name and it's value will be passed to all procedures contained within that page.

T

Can we pass multiple parameters to the landing page using 'navigatetopage()'?

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10