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.
Does anyone have an example of using the responsive grid (tablesaw or footable)? I attended a user group meeting recently and they showed that. They sent us all a zip file with a ton of stuff in it, but it requires you to import it into your environment, and I'm too new with version 8 to want to try that. I have a few reports where I'd like so slide a few columns underneath, when the screen size is narrow like on a tablet or phone. This is so cool.This message has been edited. Last edited by: <Emily McAllister>,
LOL You guys crack me up. Good to hear this functionality is built into 8.2. Hope that comes out soon. I've tried using the footable.js plugin myself with mixed results.
8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
Posts: 1113 | Location: USA | Registered: January 27, 2015
Actually, they started in 8.1.05. They took away the "Edit in Text Editor". There are two options.
1. Rename all your HTML's to FEX and use -HTMLFORM BEGIN/END. 2. Go into property, change your html file to TXT, then open the file, then change it back to HTM when your done. I'm sure IBI will attempt to block this option in the future as they gave me a story about how a customer broke their HTML by changing the IBI code and they spent a week working on it, before they figure it out. This is their logic of taking away this menu option. I don't use their code at all, so people like me have to do the work around.
- FOCUS Man, just FOCUS! ----------------------------- Product: WebFOCUS Version: 8.1.04 Server: Windows 2008 Server
So, nothing new from 8.1.05 then. They don't have the "Edit in Text Editor" option for HTML documents in our release like your were saying. I've been using workarounds myself.
They didn't take "Edit in Text Editor" out for .fexes now also did they? That would be like the end for us with IBI if that was the case. haha
Thanks for the information and update!
8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
Posts: 1113 | Location: USA | Registered: January 27, 2015
Originally posted by CoolGuy: LOL You guys crack me up. Good to hear this functionality is built into 8.2. Hope that comes out soon. I've tried using the footable.js plugin myself with mixed results.
I just got the necessary files set up yesterday. I got it working on one of my reports in about 2 hours. That's the good news. The bad news is, I cannot seem to make it work if my report has Webfocus Page headings! That sticks an extra table into the HTML and screws it all up. I've been fighting that since yesterday morning and I'm just going in circles. Very frustrating.
Yeah, that bites. One would need to know how to modify existing jQuery to take into account the extra table element. I am somewhat familiar with the framework, but am no expert as of yet.
IBI should add some documentation for how a report/table request is generated in HTML (all case scenarios: with/without a header/footer, subtotals, etc.). In other words, what elements are used and when/why. Then again, I guess we could build out a few simple CAR file reports and look at the HTML where possible. Nevertheless...
8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
Posts: 1113 | Location: USA | Registered: January 27, 2015
I've been fighting it all day. I hate how they make it look so easy at the user group meetings. I notified Rene that it doesn't work with webfocus page headings. She said she'd look into it, but she's traveling right now, so I'm trying to figure it out on my own. Better hurry, I'm almost out of hair.
The JS below uses jQuery to alter the display behaviour of a table within a table (the HEADING in a WebFOCUS HTML report). Perhaps changing the display from the default "inline" will help solve the responsive issue (I set a red border to prove that the correct element is referenced):
I ended up removing the webfocus headings. Then I used jquery to add some h1 and h2 lines before the body of the page. That worked fine, but I had a line on the heading that said "xx Address Changes performed this month", where xx was a TOT.COUNT of the records. I put that into a subfoot instead, so as long as the main report was the FIRST table on the page, then the footable methods worked. I'm not good enough yet with jquery to figure out how to do it right.
Glad you found something that works for you. At some point I will need to revisit the responsive grid implementation for our reports.
Francis,
Thanks for your links and tips.
MattC,
I would love to believe IBI would be bringing the text editor back in the 8.2 release. From my experiences thus far with IBI in regard to that subject, I don't think it will be happening. Dare we throw an olive branch their way? lol
8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
Posts: 1113 | Location: USA | Registered: January 27, 2015
I asked Rene (the IBI rep who gave the user group presentation on this topic) if she could review the heading problem, so we'll see if they can come up with a proper work-around. I appreciate that they gave us at least a start on this, but I would really like to see them implement the thing completely. I'm still trying, but I'll be out of time pretty soon.
@CoolGuy said: I would love to believe IBI would be bringing the text editor back in the 8.2 release
They will not be bringing it back, even though, ever developer wants it there. My work around is simple, everything is done in FEX and the use of -HTMLFORM BEGIN/END
Since I do all my own HTML development anyway, I don't have to deal with half of their issues.
- FOCUS Man, just FOCUS! ----------------------------- Product: WebFOCUS Version: 8.1.04 Server: Windows 2008 Server
Any updates on an official or good workaround for adding headings into a report with tablesaw or footable Js in place??? My team lead is wanting me to revisit this functionality since AHTML sucks on mobile.
Any new developments on this front???
Thanks in advance!
8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
Posts: 1113 | Location: USA | Registered: January 27, 2015
Here is my -HTMLFORM block for implementing dataTables.js. It has Search, sorting, pagination, styling abilities, etc. all built in. Way nicer than jigsaw/sander (tablesaw) or footable.
Just plug the above block into the bottom of any of your report fexes, but inspect the page source first to see what class your table was given and your total row's and the following empty row's td tags were given and switch out any instances above of .x1 with your table class, and any instances of .x5/.x6 with your total row td tag class generated or what class the following empty row was given. The .x5 and .x6 classes are for getting rid of the extra blank row that generates at the end of your report if you choose/don't choose a total row to be included. Was having troubles with total rows in tablesaw.js so that was why this was implemented. Not sure if total rows are chill now with just datatables.js. Need to check! haha
EDIT: Forgot to mention that you'll need to modify the columnDefs.type targets with the right number of indexes specific to your report(s). Columns are 0 indexed.
UPDATE: Setting sScrollXInner to something larger that 100% will cause reports to crash on iOS browsers. Also, I don't have the fixed columns currently working in iOS either yet. Additionally, to get horizontal scrolling to work on Android for reports with fixed columns, you have to use 2 fingers to scroll.
Any questions, let me know!
Insta-make any of your HTML or AHTML reports far better than they were... lolThis message has been edited. Last edited by: CoolGuy,
8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
Posts: 1113 | Location: USA | Registered: January 27, 2015
@CoolGuy said: I would love to believe IBI would be bringing the text editor back in the 8.2 release
They will not be bringing it back, even though, ever developer wants it there. My work around is simple, everything is done in FEX and the use of -HTMLFORM BEGIN/END
Since I do all my own HTML development anyway, I don't have to deal with half of their issues.
As recently as this morning, I had to hack the HTML code that App Studio was generating for a project I'm working on. I wanted to remove a label component from within a panel and I could not click on it to select it. There is a drop down control in App Studio to select an element by name (ID), but selecting that way didn't work, either.
My solution was to edit the HTML directly and remove all references to the label. That fixed the problem, but of course now I get nag messages every time I open the HTML app saying what a naughty boy I was for using my brain to word around an App Studio bug.
This is not the first time I've had to do this, either.
App Studio WebFOCUS 8.1.05M Windows, All Outputs
Posts: 594 | Location: Michigan | Registered: September 04, 2015