[SOLVED] how to show field or system variable on HTML page

You can HOLD the fields you want... -READ them in to &Variables... Display them in a -HTMLFORM using !IBI.AMP.VariableName;.

I hope this helps

In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206

Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005

Ignored post by Doug posted

MartinY

Virtuoso

posted

Also can use !IBI.GLB.variablename; for a global variable

WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007

Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013

Ignored post by MartinY posted

Doug

Expert

posted

Thanks for the GLB refresher

There's a list of all values for the 2nd arg, !IBI.2ndArg.variablename;, someplace...

Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005

Ignored post by Doug posted

Silver Member

posted

Doug,

Thanks for the info. I know how to do the HOLD. And I know how to do the -READ.

But I don't know how to display them in a -HTMLFORM using !IBI.AMP.VariableName;. I don't know what that means.

Thanks,
Mark

WF 8.2.02
App Studio
DataMigrator
ReportCaster
Windows Server 2016

Posts: 42 | Registered: September 08, 2003

Ignored post by folkie posted

dbeagan

Platinum Member

posted

@Doug, searching through the Developing Reporting Applications manual I find six of them. Run the following code to see five of them in action:

-SET &Variable = 'foo ';
-SET &&Variable = 'globfoo';

 SET EMBEDDABLE=ON

 TABLE FILE car
 PRINT CAR
 WHERE READLIMIT IS 2
 ON TABLE HOLD AS holdfile FORMAT ALPHA
 END

-HTMLFORM BEGIN 
<html>
<head>
</head>
<body style="font-family:consolas;">
    &|#33;IBI.AMP.Variable; = !IBI.AMP.Variable; 
<br>&|#33;IBI.GLB.Variable; = !IBI.GLB.Variable; 
<br>&|#33;IBI.AML.Variable; = !IBI.AML.Variable; 
<br>&|#33;IBI.GLL.Variable; = !IBI.GLL.Variable;
<br>&|#33;IBI.FIL.holdfile; = !IBI.FIL.holdfile; 
<br>&|#33;IBI.OBJ.Variable; {html/js code embedding} 
<body>
</html>
-HTMLFORM END

@folkie You are asking about HOLD and -HTMLFORM ... the example above and the documentation give you an idea of what that is all about. I'm guessing that you are creating your html page in App Studio's HTML Canvas tool? If so, then you could also use the !IBI.AMP.Variable; and !IBI.FIL.Variable; with HTML Canvas. With the !IBI.FIL.Variable; you would avoid having to do a -READ OR -READFILE.

WebFOCUS 8.2.06

Posts: 210 | Location: Sterling Heights, Michigan | Registered: October 19, 2010

Ignored post by dbeagan posted

Silver Member

posted

dbeagan,

Sorry about the delay in getting back to this. Yes, I’m creating my HTML page in the App Studio design canvas. I only mentioned HOLD and HTMLFORM because that’s what previous replies mentioned.

I was hoping I could select an object (a Component or Control such as Text, or Hyperlink or whatever) and have that object display a variable or field from a TABLE FILE (that I assume would be listed in the Request & Data Sources tab). Can that be done with things like !IBI.AMP.Variable or !IBI.GLB.Variable? I’ve never heard of these things (don’t even know what you call them). I see examples on page 420 in the Developing Reporting Applications PDF, but I still don’t understand where they go. How do I use that in the GUI (canvas) to place the info where I want to place it?

I’ll look at that again (page 420) but I got the hang of doing it the only way I could figure out. But I had to create 6 additional TABLE FILEs to get the six fields on my HTML page using 6 Report Components. So far, I can’t figure out how these !IBI.Variables are any easier.

Thanks,
Mark

WF 8.2.02
App Studio
DataMigrator
ReportCaster
Windows Server 2016

Posts: 42 | Registered: September 08, 2003

Ignored post by folkie posted

dbeagan

Platinum Member

posted

The variables are literal text typed in an HTML Canvas Text Component as shown in this image:

WebFOCUS 8.2.06

Posts: 210 | Location: Sterling Heights, Michigan | Registered: October 19, 2010

Ignored post by dbeagan posted

Silver Member

posted

dbeagan,

Ahh. Now I see. I did a little test (copied your example) and it worked. I'll try to see if I can adapt it to what I'm trying to do.

I'm starting with opening an HTML page and having the main report run in a Report object (it's the first time I'm doing something like that). Whereas with your example the TABLE FILE is run first (to get certain variables) to populate the HTML page.

It may be a while, but I'll let you know if I can figure out how to use what you have with what I'm doing.

Thanks again for starting me in the right direction.

Thanks,
Mark

WF 8.2.02
App Studio
DataMigrator
ReportCaster
Windows Server 2016

Posts: 42 | Registered: September 08, 2003

Ignored post by folkie posted

Silver Member

posted

After adapting what dbeagan has to what I'm doing, it works. I guess I had to do it for myself to see and understand it.

Now, instead of running/opening the HTML page, the user runs the TABLE FILE first. It creates the HOLD file of variables I want to use and then opens the HTML page, which is the same as my original HTML page but it now also has the new text boxes with the !IBI.AMP variables.

Now, I can do this webpage without most of the extra TABLE FILEs I had been using and putting into the webpage as individual report objects. And it's easier to deal with these new smaller text boxes than the bigger report objects in the HTML canvas.

Thanks for all your help.

Mark

WF 8.2.02
App Studio
DataMigrator
ReportCaster
Windows Server 2016

Posts: 42 | Registered: September 08, 2003

Ignored post by folkie posted

dbeagan

Platinum Member

posted