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.
I have 2 comboboxes with autocomplete javascript code and focus set to the first box. When I tab from the first box to the second, chaining will not work. If I mouse click on the select in the first box then the chaining will work. So, I think it's something with the autocomplete. I just can't figure it out.
Anyone have any suggestions?? Thanks.This message has been edited. Last edited by: Kerry,
WebFOCUS Server 8.1.05 Windows 2008 Server WebFOCUS AppStudio 8.1.05 Windows 7 Professional IE 11 and Chrome Version 43.0.2357.124 m. Mostly HTML, PDF, Excel, and AHTML
I also have custom buttons that are actually images. Don't know if it was a glitch or not but couldn't get focus to work with buttons. All the commented out code is stuff I have tried that didn't work. I have looked at the functions in IBIRLS3, nothing seems to work.
WebFOCUS Server 8.1.05 Windows 2008 Server WebFOCUS AppStudio 8.1.05 Windows 7 Professional IE 11 and Chrome Version 43.0.2357.124 m. Mostly HTML, PDF, Excel, and AHTML
I unfortunatly cant duplicate the issue as I am on 7.6 and dont have the appropriate release of files.
Can you confirm your tab order? Are you positive that you are in fact tabbing from Last Name to First Name directly or is it stopping somewhere else on the page?
Nope, I checked the tab order. Tabs directly from LastNameCB to FirstNameCB
WebFOCUS Server 8.1.05 Windows 2008 Server WebFOCUS AppStudio 8.1.05 Windows 7 Professional IE 11 and Chrome Version 43.0.2357.124 m. Mostly HTML, PDF, Excel, and AHTML
My only suggestion would be to tear everything else out of the HTML portion of your page and do the following:
1. Add some debugging into the javascript (Call a custom function and make sure it is executing) 2. Toss some traces on in WF to check to see if the fex is executing 3. Use firebug in firefox to trace the js 4. Cross your fingers
Thank you. We run on IE, how do we set it to Firefox so I can use Firebug? I think what is happening is when I reset the selectedIndex to 0 the first combobox is still "remembering" the selection which makes the second combobox list the limited selections instead of the full list. I have tried changing the selectedValue to 0 but also does not work. I have been crossing my fingers but that doesn't seem to be working for me either. Argh!
WebFOCUS Server 8.1.05 Windows 2008 Server WebFOCUS AppStudio 8.1.05 Windows 7 Professional IE 11 and Chrome Version 43.0.2357.124 m. Mostly HTML, PDF, Excel, and AHTML
Either set it as your default browser or you can construct a URL to your HTML file. The URL will look differently based on whether it is in the MRE or an app.
When "ibirls2.js" was first implemented (5.2.3?), one of the things "achieved" on page load was to remove all the onchange events for chained combo boxes and replace those event calls with a chaining solution. If I remember correctly, there was a "fix" that prepended (or appended?) the new onchange event call instead of replacement, but it was a long time ago and we are several releases forward of that point.
Whether this is stil the case with "ibirls3" in 7.7. I do not know because I have not had the time to analyse it and understand exactly what is going on in the JavaScript.
My first attempt at testing for the error would be to remove the autocomplete calls on every one of the controls and retest. Either keep a copy of the code as it is, before you make changes, or use HTML commenting (<!-- and -->), so that you can get back to where you started. Reintroduce the events one at a time to see which one breaks the chain.
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004
Okay, I guess I've had an "Ah-Ha" momemt. I will share it with everyone. It would appear that WF has built in auto complete (here's the catch) as long as you set focus to the combobox. No where in any of my reading and searching did I see this in print, but it works, in 7.7 anyway. Tony suggested I take out the autocomplete code and add it back in one at a time to see where it is breaking. So, I did this. I took out all of the autocomplete code, but left the code to set focus to my combobox. I ran it and the autocomplete still worked. I thought my computer had some VooDoo going on, so I saved everything, closed down my launch page, re-opened it and ran it again. It still worked. So, I think my problem was that the autocomplete code I added was fighting with the furnished functionality from WF. I wish I would have thought to set focus to the box before I added the autocomplete code. I wouldn't have had this issue but then I would not have learned this valuable lesson to share with everyone. Autocomplete and tabbing to the next field works now. I have yet to figure out the code to add to my homegrown reset to reload the chained box that is dynamiclly populated with an external procedure. I want it to look smooth and not reload the entire page like the WF furnished Reset Button does.
WebFOCUS Server 8.1.05 Windows 2008 Server WebFOCUS AppStudio 8.1.05 Windows 7 Professional IE 11 and Chrome Version 43.0.2357.124 m. Mostly HTML, PDF, Excel, and AHTML
Tony, I put your code in instead of mine and I get the same result, second combobox still does not show all available name. Is there a way to call or force the on click event of the first combobox after the selectedIndex has been set to o in the on click event of the reset? I say this because if I click on the 'All' in the first box it will give me all the names in my second box, which is what I want.
WebFOCUS Server 8.1.05 Windows 2008 Server WebFOCUS AppStudio 8.1.05 Windows 7 Professional IE 11 and Chrome Version 43.0.2357.124 m. Mostly HTML, PDF, Excel, and AHTML
One of the problems with what you want to do is that with chaining, the combo contents are completely reloaded. e.g. when you select a value in the first chained combo, the second combo is reloaded with relevant values. Reseting the selectedIndex to 0 will only do that, it will not reset the contents back to what they should be in relation to the All beinging selected in the first combo. To have that functionality then you would need to reset the chaining (which is what the reset button would do if you allowed it to).
My suggestion is to decide how you want the combos to behave and then work forward from that. My guess is that you would need the correct chaining method and have to use the proper reset function rather than your own.
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004
I hope you don't think this is a stupid question.... I am pretty new to WebFOCUS and both my partner and I can not figure out how to run WF in FireFox. I have set my default browser to FF but WF still opens in IE. Is there a WF setting I need to change? I read in the help files that WF only runs on IE, I'm assuming this in incorrect? I would much rather use FF and for testing I'd like to see how reports display on both IE and FF.
Any help would be appreciated.
Thanks Michelle
WebFOCUS Server 8.1.05 Windows 2008 Server WebFOCUS AppStudio 8.1.05 Windows 7 Professional IE 11 and Chrome Version 43.0.2357.124 m. Mostly HTML, PDF, Excel, and AHTML
When you say "WF still opens in IE", do you mean IE opens when you run a report from Developer Studio? Developer Studio has always relied on IE, and I wouldn't be surprised that setting the default web browser to Firefox is not enough. Perhaps there's a web browser setting in Developer Studio v7.7.
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
Yes that's what I mean. I have been searching for the Dev Studio setting but I'm starting to think there isn't one. From reading other posts it sounds like others are using Firefox so not sure what I am doing wrong. I am going to have our admin try a setting in site.wfs to add the HTTP Header Variable for browser detection, maybe this will work.
WebFOCUS Server 8.1.05 Windows 2008 Server WebFOCUS AppStudio 8.1.05 Windows 7 Professional IE 11 and Chrome Version 43.0.2357.124 m. Mostly HTML, PDF, Excel, and AHTML
I would love for WebFOCUS to open Firefox. Many threads have discussed it and I cannot remember ever seeing a way to do it. I have 7.7.02 for development. I will take a fresh look at its settings. Maybe this will be the version where we get to make a choice of the default browser.
Posts: 60 | Location: Ellensburg Washington | Registered: May 22, 2009
Thanks for the info. We can hope and pray for this feature in a new release.
WebFOCUS Server 8.1.05 Windows 2008 Server WebFOCUS AppStudio 8.1.05 Windows 7 Professional IE 11 and Chrome Version 43.0.2357.124 m. Mostly HTML, PDF, Excel, and AHTML
I'm running on IE 8, I changed my signature. I'm wondering if this could be causing some of my troubles. Ref the chained comboboxes. I did try the WF provided reset button and it still did not reset my first name combobox. My other issue(one of many I'm sure...) is the fact that whenever I set focus to the last name combobox(or any box for that matter), it doesn't work if I have a button, radio button or check box on my html page. If I remove the buttons then it works fine. We have opened a case on that one. My directory takes a very long time to load also, I have tried populating my combos with embedded and external procedures. Doesn't seem to make much difference. All of my combos are populated on load, the first name is chained to the last name, but user can also search by only first name so needs to load entire list on initial load and reset. I thank you for all your advise. I have yet to get these issues figured out.
WebFOCUS Server 8.1.05 Windows 2008 Server WebFOCUS AppStudio 8.1.05 Windows 7 Professional IE 11 and Chrome Version 43.0.2357.124 m. Mostly HTML, PDF, Excel, and AHTML
I've used your exact code as a base - obviously had to create the external fexes and change other references etc. to use sample database data - and I can see that the chaining is not working.
I also use IE8 but I can create a working chain using the composer. I am also checking this out on 7.7.01 (32bit) on a 64bit system, so I do not think that there problem lies there.
I've even compared your code to a working chain model that I have created but the code is soooo much more complex than in earlier releases that it's not easy to see where there may be problems.
If I spot anything then I'll let you know.
I have found that when you get to this situation that it is sometimes easier to trash and rebuild than it is to continue to try and debug the existing one.
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004
Tony, Thank you so much for helping me out. I tried starting with a new launch page and it didn't work any better. I really am stuck.
WebFOCUS Server 8.1.05 Windows 2008 Server WebFOCUS AppStudio 8.1.05 Windows 7 Professional IE 11 and Chrome Version 43.0.2357.124 m. Mostly HTML, PDF, Excel, and AHTML
If I've copied your code from above correctly without introducing anything (other than using local data), I think that your problem might be with caching.
For your first combo in the chain you do not have caching turned on but you do for your second one.
When I remove the caching from the second combo in my copied version, chaining starts working as it should.
Try that and let me know how it goes.
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004
Tony, I thought about caching and I removed it from one of my copies and it still didn't work. I started a new launch page and used WF controls for the search and reset and made sure caching was off, and even the WF reset button did not reset the first name combobox. It also didn't "re-load" the page like I have seen it do in the past. Here is my first name fex. We are using a data mart for our tables. Our data mart has a people table which has students and employees in it. That's a lot of data to sift through so Yesterday I suggested we make another table just for employees, this should speed it up I would think. We'll see, I'm doing that today.
PS, which is better to use or more efficient, embedded procedures or external fex's? I notice when I use the embedded procedures it is a little quicker but the chain won't work unless I use an external procedure for the first name combo.
-* File FName.fex
-*------------------------------------------------------------------------
-* Programmer: Michelle Adams
-* Date: September 23, 2010
-*------------------------------------------------------------------------
-* Program Purpose: Produces a list of employees by FirstName and LastName
-* displaying Lastname, Firstname and Pidm. Report is ordered by FirstName.
-* For employees with active status.
-*-------------------------------------------------------------------------
-* Output type: XML
-*-------------------------------------------------------------------------
-* Other Programs: Used to populate FirstName parameter dropdown ComboBox in
-* HTML launch page, KvccWebDirectoryFinal.html
-*-------------------------------------------------------------------------
-* Parameters: none.
-*-------------------------------------------------------------------------
-* Tables: PEOPLE_DIM
-*-------------------------------------------------------------------------
-* UPDATES:
-*
-*
-*
-*-------------------------------------------------------------------------
TABLE FILE PEOPLE_DIM
PRINT
'PEOPLE_DIM.PEOPLE_DIM.FIRST_NAME'
'PEOPLE_DIM.PEOPLE_DIM.PIDM'
BY TOTAL 'PEOPLE_DIM.PEOPLE_DIM.FIRST_NAME' NOPRINT
BY 'PEOPLE_DIM.PEOPLE_DIM.LAST_NAME'
WHERE PEOPLE_DIM.PEOPLE_DIM.EMPLOYEE_STATUS EQ 'A';
WHERE PEOPLE_DIM.PEOPLE_DIM.PHONE NE 'na';
ON TABLE SET PAGE-NUM OFF
ON TABLE SET BYDISPLAY ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT XML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END
WebFOCUS Server 8.1.05 Windows 2008 Server WebFOCUS AppStudio 8.1.05 Windows 7 Professional IE 11 and Chrome Version 43.0.2357.124 m. Mostly HTML, PDF, Excel, and AHTML
As your fname is the second combo in the chain, then I would have expected your fex to look like this -
-DEFAULTH &LAST_NAME = 'FOC_NONE'
TABLE FILE PEOPLE_DIM
SUM FST.'PEOPLE_DIM.PEOPLE_DIM.FIRST_NAME'
BY 'PEOPLE_DIM.PEOPLE_DIM.FIRST_NAME'
WHERE 'PEOPLE_DIM.PEOPLE_DIM.LAST_NAME' EQ '&LAST_NAME'
WHERE PEOPLE_DIM.PEOPLE_DIM.EMPLOYEE_STATUS EQ 'A';
WHERE PEOPLE_DIM.PEOPLE_DIM.PHONE NE 'na';
ON TABLE PCHOLD FORMAT XML
END
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004
I just put your code into my fname.fex re-ran it and then refreshed the html page and still the first name box will not reset.
WebFOCUS Server 8.1.05 Windows 2008 Server WebFOCUS AppStudio 8.1.05 Windows 7 Professional IE 11 and Chrome Version 43.0.2357.124 m. Mostly HTML, PDF, Excel, and AHTML
One of the problems with what you want to do is that with chaining, the combo contents are completely reloaded. e.g. when you select a value in the first chained combo, the second combo is reloaded with relevant values. Reseting the selectedIndex to 0 will only do that, it will not reset the contents back to what they should be in relation to the All being selected in the first combo. To have that functionality then you would need to reset the chaining (which is what the reset button would do if you allowed it to).
Instead of doing what you've coded, you need to ensure that the contents are reset as well.
I managed to replicate what you are doing and this code worked for me.
//Begin function ResetSelects
function ResetSelects() {
var ctrl = document.getElementById("LastNameCB");
ctrl.selectedIndex = 0;
DoResetDownChainControls(ctrl);
}
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004
T you are a genius!! That did the trick! I looked all over for the right function to use to reset the chain and you found it. Thank you soooo much. If I don't talk to you again before the holiday, Have a Merry Christmas!
WebFOCUS Server 8.1.05 Windows 2008 Server WebFOCUS AppStudio 8.1.05 Windows 7 Professional IE 11 and Chrome Version 43.0.2357.124 m. Mostly HTML, PDF, Excel, and AHTML