Focal Point
FOCEXEC with SET FOCEXURL
February 24, 2016, 08:45 AM
SWESFOCEXEC with SET FOCEXURL
Hi,
I'm having a fex in domain 'B' which uses SET FOCEXURL = /ibi_apps/WFServlet to open a fex in domain 'A' via an INCLUDE. This works fine. The INCLUDE fex has a FOCEXEC to open a fex also residing in domain 'A'. However, i get the FOC 227 Procedure not found error when opening the FOCEXEC.
Question is: how can I combine the FOCEXEC command with the SET FOCEXURL needed?
ps. still on version 7, not 8
Thanks,
SWES
WebFOCUS 8105m
Windows 7, All Outputs
Member of the Benelux Usergroup
February 24, 2016, 08:55 AM
BabakNYCThis might be a shot in the dark but have you tried:
-MRNOEDIT INCLUDE focexec
WebFOCUS 8206, Unix, Windows
February 24, 2016, 10:25 AM
Francis Mariani-MRNOEDIT -INCLUDE is used to include fex files that are located on the reporting server.
SET FOCEXURL is used to set up the location of the WebFOCUS Servlet and is used in fex files that have drill-downs, so that the drill-downs work properly - particularly useful for PDF and Excel reports.
In your main fex, you have SET FOCEXURL and -INCLUDE - I don't see how SET FOCEXURL helps you to use -INCLUDE to include a fex file located in another domain.
I don't have WF 7 any more so I can't verify, but have you tried -INCLUDE domain-name/app/fex-name.fex ?
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 26, 2016, 09:17 AM
SWESThank you for your suggestion Babak, its what came to mind to me as well, but unfortunately no cigar.
Francis, I don't see how SET FOCEXURL helps me either, but it works with it, so all fine by me.
The problem is:
$
TYPE=DATA,
COLUMN=TEST,
FOCEXEC=app/drilldown.fex( A=A B=B ),
I cannot put it like this:
$
TYPE=DATA,
COLUMN=TEST,
-INCLUDE FOCEXEC=app/drilldown.fex( A=A B=B ),
It's not how the stylesheet works I guess... but the trouble is there with the FOCEXEC.
WebFOCUS 8105m
Windows 7, All Outputs
Member of the Benelux Usergroup
February 29, 2016, 08:11 AM
Ricardo AugustoWhy do you want INCLUDE a fex to perform a drill down?
WebFOCUS 8.1.05 / APP Studio
February 29, 2016, 09:11 AM
Francis MarianiEither you're not explaining things correctly or you're not doing things correctly.
1) It appears you DO NOT have an include, but rather, a drill-down (that second form of stylesheet drilldown is definitely not correct.
2) Please try:
TYPE=DATA,
COLUMN=TEST,
FOCEXEC=domain-name/app/fex-name.fex ( A=A B=B ), $
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server