 |
|||||
|
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
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 WebFOCUS/FOCUS Forum on Focal Point [STILL OPEN] DS HTML Composer: calling fex not compatible with drilldown to same fex
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [STILL OPEN] DS HTML Composer: calling fex not compatible with drilldown to same fex Read-Only TopicGo | Search | Notify | Tools |
| [STILL OPEN] DS HTML Composer: calling fex not compatible with drilldown to same fex | Login/Join |
| Expert |
I have a HTML Composer designed parameter screen that passes a bunch of parameters to a report fex. Some of these parameters are multi-select. Each of these get passed as one parameter with multiple values separated by OR: Parameter &PCLASS gets passed as 'A' OR 'B' OR 'C' In the report fex, these are used in a WHERE statement as: WHERE ( CLASS EQ &PCLASS ); which gets translated to: WHERE ( CLASS EQ 'A' OR 'B' OR 'C' ); This all works just fine. Now I would like to call the same report fex from a drilldown of another report: ... FOCEXEC=FEX1|( \ PCLASS=CLASS \ ... Parameter &PCLASS gets passed as &PCLASS=F which gets translated to: WHERE ( CLASS EQ F ); and ERROR! Sticking QUOTEDSTRING will work for the second but not for the first: WHERE ( CLASS EQ &PCLASS.QUOTEDSTRING ); gets translated to: WHERE ( CLASS EQ ''A' OR 'B' OR 'C'' ); and WHERE ( CLASS EQ 'F' ); ERROR OF COURSE ON THE FIRST WHERE! What to do, what to do?This message has been edited. Last edited by: Francis Mariani, 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 | ||
|
| Expert |
I would check the first character of &PCLASS for a single quote, and wrap if necessary. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Expert |
Thanks for that suggestion Waz - sure sounds like a quick way of taking care of the problem. I wonder what GUINauts would do? 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 | |||
|
| Expert |
Second Fex ? Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Virtuoso |
Use a javascript routine in your drill-down to make the call and hand-fashion your OR clause with basic javascript text functions. The call is relatively simple (I can send you an example if you like) and a little bit of js just prior to it lets you customize the argument string anyway you like. You can even customize which Focexec gets called and on which server. If it's a really long list you may need to create a form on the fly and I can send an example of that as well. It also allows you to embed the information in case you're in a secure socket environment. This sort of follows from your previous thread. Once you get out into clear air by creating your own server calls you have complete control and, in this case, can use identical logic on both screens to ensure you get the same result in the fex call. Much easier to debug, much easier to control, much easier to maintain. It's pretty simple to implement in the first place too. J.  | |||
|
| Expert |
Another option is to define or compute another field with the quotes around it, and pass that. QCLASS/A3 = '''' | CLASS | '''' ; ... FOCEXEC=FEX1|( \ PCLASS=QCLASS \ Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Expert |
I'm sitting here as a developer that knows a thing or two about codding, but am instructed to stick with the GUI as much as possible. So, here I am, wearing someone else's clothes. Let's say I'm a GUI-only, not-newbie. I create fantabulous parameter screens and reports. I create amazing B.I. Dashboards. I want to drilldown from a smashing graph to one of my pretty programs. Do I really have to play with apostrophes and JavaScript? Remember, I'm wearing a GUI uniform (or straightjacket)... 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 | |||
|
| Virtuoso |
If you never want to look at code and stay in a drag-and-drop environment, use HTML Composer. Understand that you'll need to play by its byzantine set of rules. If you want to produce code that is maintainable and doesn't break across versions, learn the API for wfservlet. It should take about an hour, and at that point you can set your own rules. J. | |||
|
| Expert |
Francis, I think you should go to bed, and have a good nights sleep.  What time is it there ? Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Expert |
11:30. I'm off to bed and taking a hard-earned day off. See you on Friday! Nighty-night. 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 | |||
|
| Expert |
Sweet non-work related dreams.  Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Silver Member |
DEFINE FUNCTION better_quotedstring...might be time consuming to make, but useful in the longer run WebFOCUS & DataMigrator 7.7.03M Windows 2003, Windows 2008 x64 | |||
|
| Virtuoso |
F, Is this in it's own window or is it in an iFrame with the calling HTML form (well, form like screen)? "There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott | |||
|
| Virtuoso |
Recently I dusted off the old WF skills and did something very much like this for a customer. Use 2 different params. It is very difficult and non-gui to try to manage the quotes. One param the multi-select, and one (as a simple param) for the drill down. WHERE CLASS EQ &PCLASS; WHERE CLASS EQ &DCLASS; note: D for drill ... get it? And very gui friendly! "There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott | |||
|
| Expert |
The one for the drilldown must have the quotes added - I do this with .QUOTEDSTRING: WHERE CLASS EQ &DCLASS.QUOTEDSTRING; In your example, we'd have to default both parameters to _FOC_NULL. I'm just surprised we have to do this kind of thing. Thanks for your input. 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 | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [STILL OPEN] DS HTML Composer: calling fex not compatible with drilldown to same fex
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [STILL OPEN] DS HTML Composer: calling fex not compatible with drilldown to same fexCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |