I have a procedure with a drilldown to 'URL from field'. When I run the fex and click on the drill down link I get an error rather than web browser opening the link.
Here is the error:
HTTP Status 404 - /approot/tedd/www.larmgroup.com/
Apache Tomcat/5.5.25This message has been edited. Last edited by: Kathleen Butler,
7.6.8 Windows xp html
May 01, 2009, 03:24 PM
Anonymouse
A HTTP 404 message usually indicates an incorrect url (usually a misspelling).
Are you trying to link to an external website? (the 'www' makes me think you are)
If so, I think you need to remove the '/approot/tedd/' from the url.
Jeff WebFOCUS 8.0.09, Unix-Win-z/OS FOCUS 7.3.1 on z/OS
May 02, 2009, 05:01 AM
Clinton Side-Kick
Jeff is correct, If you are still having a problem, share your code with us and we should be able to assist you more specifically.
-------------------------------------------------------------------------------- prod: WF/AS 8.2.05; OmniGen; In FOCUS since 1991
May 04, 2009, 09:33 AM
LDW
It may be a Tomcat problem?
The field that I am directing the drill down to does not contain '/approot/tedd/' in it, WebFOCUS or Tomcat seems to be adding it.
Below is my code:
-SET &ECHO = ALL; SET EMPTYREPORT = ON SET NODATA = '' JOIN LISTING.LISTING.AUTHORIZATIONID IN LISTING TO UNIQUE HOMESALE.HOMESALE.AUTHORIZATIONID IN HOMESALE AS J0 END JOIN LISTING.LISTING.AUTHORIZATIONID IN LISTING TO UNIQUE AUTHORIZATIONS.AUTHORIZATIONS.AUTHORIZATIONID IN AUTHORIZATIONS AS J1 END TABLE FILE LISTING PRINT LISTING.LISTING.LISTINGPRICE BY LISTING.LISTING.LISTINGPRICE NOPRINT WHERE LISTING.LISTING.LISTINGTYPE EQ 'ORIGLIST'; WHERE AUTHORIZATIONID EQ '&AUTHORIZATIONID'; ON TABLE SAVE END -RUN -IF &LINES GT 0 THEN GOTO ORIGLIST ELSE NO_ORIGLIST ; -ORIGLIST -READ SAVE &ORIGLISTING1.A21. -GOTO RPT ; -NO_ORIGLIST -SET &ORIGLISTING1 = 0 ; -RPT DEFINE FILE LISTING MLS_IMG/A50=''; END TABLE FILE LISTING PRINT 'LISTING.LISTING.LISTINGDATE/MDYY' AS 'Listing,Date' 'LISTING.LISTING.LISTINGTYPE' AS 'Listing,Type' 'LISTING.LISTING.LISTINGSTATUS' AS 'Listing,Status' 'LISTING.LISTING.LISTINGPRICE/P12CM' AS 'Listing,Price' COMPUTE LISTPCT/D12.2% = LISTING.LISTING.LISTINGPRICE *100 /&ORIGLISTING1 ; AS '% of,Orignal List' MLS_IMG AS '' LISTUSER1 NOPRINT BY 'AUTHORIZATIONS.AUTHORIZATIONS.AUTHORIZATIONID' AS 'Move,ID' NOPRINT BY 'LISTING.LISTING.LISTINGDATE' NOPRINT WHERE LISTING.LISTING.AUTHORIZATIONID EQ '&AUTHORIZATIONID'; ON TABLE SET PAGE-NUM OFF ON TABLE SET BYDISPLAY ON ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, $ TYPE=REPORT, GRID=OFF, FONT='VERDANA', SIZE=9, $ TYPE=TITLE, STYLE=BOLD, $ TYPE=TABHEADING, SIZE=12, STYLE=BOLD, $ TYPE=TABFOOTING, SIZE=12, STYLE=BOLD, $ TYPE=TABHEADING, SIZE=10, STYLE=NORMAL, $ TYPE=TABHEADING, SIZE=12, STYLE=BOLD, LINE=1, COLOR='WHITE', BACKCOLOR=RGB(79 38 131), JUSTIFY=CENTER, $ TYPE=HEADING, SIZE=10, $ TYPE=DATA, COLUMN=N8, TARGET='_blank', JUSTIFY=CENTER, URL=(LISTING.LISTING.LISTUSER1), $ TYPE=FOOTING, SIZE=8, STYLE=BOLD, $ TYPE=SUBHEAD, SIZE=10, STYLE=BOLD, $ TYPE=TABFOOTING, SIZE=8, STYLE=NORMAL, $ TYPE=SUBTOTAL, BACKCOLOR=RGB(210 210 210), $ TYPE=ACROSSVALUE, SIZE=9, $ TYPE=ACROSSTITLE, STYLE=BOLD, $ TYPE=GRANDTOTAL, BACKCOLOR=RGB(210 210 210), STYLE=BOLD, $ ENDSTYLE END
7.6.8 Windows xp html
May 04, 2009, 09:43 AM
<JG>
quote:
www.larmgroup.com/
If you want to go to a URL that is not relative to the path that callled it then you must supply an absolute URL
Would become COMPUTE LISTUSER_URL/A200= 'HTTP://'||LISTUSER1; NOPRINT
and your drilldown URL=(LISTUSER_URL),
May 13, 2009, 09:15 AM
LDW
JG, your solution does work. Although I still think IBI needs to look at Dev Studio further to find out why this is happening. This procedure was created using Dev Studio and its option to drill down to a field that contains a URL. I would think it should work automatically if that is the case. Thanks for the assistance!
7.6.8 Windows xp html
May 13, 2009, 09:33 AM
Francis Mariani
As JG has suggested, coding the http:// will make the URL work.
I just created a test fex with Dev Studio Report Painter and created a drilldown with this URL "http://www.cnn.com", just typed it in - no computed field, and it works as expected.
The code generated by Dev Studio Report Painter:
TABLE FILE CAR
SUM
LENGTH
BY COUNTRY
BY CAR
BY MODEL
BY BODYTYPE
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
$
TYPE=DATA,
COLUMN=N5,
URL=http://www.cnn.com,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
END
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
May 13, 2009, 09:33 AM
<JG>
Good point, you need the raise a New Feature Request (NFR).
Dev Studio assumes that all URLs are relative to the ibi_apps application server setting.
There should be a check box when creating a URL drilldown such as 'absolute path'.
If you know about the issue it's easy, you just edit the code. However it's a GUI tool so it should really be accommodated.
May 13, 2009, 09:55 AM
Francis Mariani
As I mentioned, you don't need to edit the code, just code the URL with the http://.
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
May 30, 2012, 12:27 AM
Anatess
Hi Francis,
I just want to let you know that adding the http:// to the url does not solve this issue. It only solves the issue if you are hard-coding the URL in the CSS. If you're using a field value to pass the url, the presence of http:// doesn't eliminate the approot stuff.
Here's a code for you to try:
DEFINE FILE CAR
URLFLD/A255V='http://www.google.com';
END
TABLE FILE CAR
SUM
LENGTH
BY COUNTRY
BY CAR
BY MODEL
BY BODYTYPE
BY URLFLD NOPRINT
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
$
TYPE=DATA,
COLUMN=N6,
URL=(N5),
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
END
If anybody figured out a solution to this one using the URL= parameter, I'd appreciate it. I solved it by passing the url in the field to a fex as the drillmenuitem. Idiotic way to do it, but, alas, it's the only way I could find.