Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     'Grid Object' Created Via HTML/JS/CSS?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
'Grid Object' Created Via HTML/JS/CSS?
 Login/Join
 
David Briars
Master
posted
I have an in-house WebFOCUS application that consists of:
1. Presentation Tier - HTML/JS/CSS rendered within an IE browser.
2. Business/Data Tier - z/OS focexecs/datasets.

We are on WF 5.2.8.

Our data maintenance pages currently, allow the user to update/add/delete one record at a time.

I'd like to create a page that allows for multiple record processing.

The Data Grid Object in VB .Net is good example of the type of thing I am looking for.

I did a quick search on the web for 'JavaScript Grid Object', but received too large of a result set to be of much value to me.

So my question is: Can you recommend a 'template' or have any suggestions, relative to building a grid using HTML, JS, and CSS?

I know WebFOCUS Maintain has a grid object, but for us Maintain is not an option.




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, 2003Report This Post
TexasStingray
Master
posted Hide Post
David, did you ever find what you needed?




Scott

 
Posts: 865 | Registered: May 24, 2004Report This Post
Rob Bowen
Member
posted Hide Post
David,

Check with Charles Kim about this. I did someting like this for proxies last year.

It involved adding a counter suffix to the variable name.

The modify portion is all instream data which is populated with a -REPEAT

Rob


WebFOCUS 8.1.04; SQL Server 2012; Windows 7; Windows Server 2012 R2;
 
Posts: 26 | Registered: November 21, 2005Report This Post
Rob Bowen
Member
posted Hide Post
Here is also an example....

For the Form data...
TABLE FILE CAR
SUM
  COMPUTE REC_COUNT/I2 = REC_COUNT + 1; NOPRINT
  COMPUTE AREC_COUNT/A2 = EDIT(REC_COUNT); NOPRINT
  COMPUTE DCOST_INPUT/A200 = '<INPUT TYPE=TEXT NAME=DCOST' | AREC_COUNT | ' WIDTH=10 VALUE='
     || FTOA(DEALER_COST,'(F7)','A7') || '>'; AS ''
  COMPUTE RCOST_INPUT/A200 = '<INPUT TYPE=TEXT NAME=RCOST' | AREC_COUNT | ' WIDTH=10 VALUE='
     || FTOA(RETAIL_COST,'(F7)','A7') || '>'; AS ''
  COMPUTE NCOUNTRY/A200 = '<input type=hidden name=COUNTRY' | AREC_COUNT | ' value="' || COUNTRY || '">'; AS ''
  COMPUTE NMODEL/A200   = '<input type=hidden name=MODEL'   | AREC_COUNT | ' value="' || MODEL   || '">'; AS ''
BY COUNTRY NOPRINT
BY MODEL AS ''
ON COUNTRY SUBHEAD
"<COUNTRY"
" <+0>Dealer Cost<+0>Retail Cost"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET HTMLCSS ON
ON TABLE HOLD AS HFORM FORMAT HTMTABLE
ON TABLE SET STYLE *
TYPE=REPORT, GRID=OFF,$
TYPE=SUBHEAD, HEADALIGN=BODY,$
TYPE=SUBHEAD, LINE=1, STYLE=BOLD, BACKCOLOR=SILVER, COLSPAN=3,$
ENDSTYLE
END
-RUN
-SET &MAXRECS = &LINES;
-HTMLFORM BEGIN
<HTML>
<BODY>
<FORM NAME=WFFORM ACTION='/ibi_apps/WFServlet' METHOD=POST>
<input type=hidden name=IBIF_ex value=formtest>
<input type=hidden name=MAXRECS value=&MAXRECS..>
<input type=hidden name=tmstmp value=&YYMD..&TOD..>
!IBI.FIL.HFORM;
<input type=submit value=Update>
</FORM>
</BODY></HTML>
-HTMLFORM END


FORMTEST.FEX
MODIFY FILE CAR
FREEFORM COUNTRY MODEL DEALER_COST RETAIL_COST
....
....
DATA
-REPEAT DATASECT FOR &COUNTER FROM 1 TO &MAXRECS;
-SET &ACOUNTER = IF &COUNTER LT 10 THEN '0' | &COUNTER;
&COUNTRY.&ACOUNTER, &MODEL.&ACOUNTER, &DCOST.&ACOUNTER, &RCOST.&ACOUNTER,$
-DATASECT
END


WebFOCUS 8.1.04; SQL Server 2012; Windows 7; Windows Server 2012 R2;
 
Posts: 26 | Registered: November 21, 2005Report This Post
David Briars
Master
posted Hide Post
Rob,

This is exactly what I needed.

I've incorporated the model, into my prototype, and it is working fine.

I've also extended the model, so that now one column consists of drop down list controls.

Thank you very much, for your contribution.

Regards,
Dave
 
Posts: 822 | Registered: April 23, 2003Report This Post
TexasStingray
Master
posted Hide Post
Please be aware that even though something might work. Does not mean you are licensed for it. Generally speaking from what I have been told is that if you are using Modify in a report request where the data is temporary (Only for that request) that it is generally ok to use MODIFY even if you do not have a MAINTAIN License however if the data that is being changed by the MODIFY will be around after the request completes that would require a MAINTAIN License. Just check with your IBI Sales Rep. to be safe.




Scott

 
Posts: 865 | Registered: May 24, 2004Report This Post
GinnyJakes
Expert
posted Hide Post
I thought you could use MODIFY if you had purchased the FOCUS data base adapter.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
TexasStingray
Master
posted Hide Post
If you purchase the FOCUS Database Adapter allows you to keep your focus database around after your request is complete. Because you have to maintain them in some way MODIFY or MAINTAIN, if you have a MAINTAIN License, then you should be able to use MODIFY for those FOCUS databases only.




Scott

 
Posts: 865 | Registered: May 24, 2004Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     'Grid Object' Created Via HTML/JS/CSS?

Copyright © 1996-2020 Information Builders