 |
|||||
|
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 [SOLVED] Issue with multiple IF clauses on the same column in multiple lines
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Issue with multiple IF clauses on the same column in multiple lines Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] Issue with multiple IF clauses on the same column in multiple lines | Login/Join |
| Platinum Member |
Hi, I have come across an issue while testing our reports on WF v8.1.03. The following code represents the issue that we are facing TABLE FILE CAR PRINT * IF COUNTRY IS '$*' IF COUNTRY EQ 'JAPAN' END I expect the code to output results related to just 'JAPAN', even if have an IF condition before that gets all the data from the same field. Instead, i end up getting entire CAR table. I see that WF8 is somehow ignoring the 2nd IF clause, after the 1st clause with '$*'. Is there a way to tell WF to consider both clauses. Because, we have similar code structure in many of our fex's, especially the use of $* and it is difficult to identify each one of them. Note: The code runs perfectly in v7.6.11. We recently started migrating to v8. Thanks in advanceThis message has been edited. Last edited by: WF1326, WebFOCUS 7703/7705/8105m/8201m/8202m | ||
|
| Expert |
Not sure why you are using '$*', doesn't that just get all records ? I would use WHERE instead and use and OR statement. WHERE COUNTRY LIKE '%' OR COUNTRY EQ 'JAPAN' Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Platinum Member |
Waz, Yep.. $* gets all records and i appreciate your suggestion. I only need records of 'JAPAN' alone using the same double IF statements. I do accept that its a bad way of writing the conditions. But, the reason why i have posted the code in an unusual manner, is because we are in a hard position to make any changes to the 1st IF statement. Its all over the place. So, i am looking for an alternate solution. By the way, the '$*' usually comes in the form of an & variable if the user does not select any value. So, keeping the structure as i posted, can i make WF8 to consider both statements?... The code had no issues in v7.6.11.This message has been edited. Last edited by: WF1326, WebFOCUS 7703/7705/8105m/8201m/8202m | |||
|
| Gold member |
Look for FOC_NONE if there is no value for your & variable | |||
|
| Master |
You need to write a search routine with lesser known commands like syscolum, etc., to find every instance of '$*'. This would enable you to isolate each fex using '$*' so you change them accordingly. Good luck Tomsweb WebFOCUS 8.1.05M, 8.2.x APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports Apache Tomcat/8.0.36 | |||
|
| Silver Member |
What happens if you add a semicolon to the end of each of the IF statements? 8009 Windows, HTML, AHTML, Excel In FOCUS since 1983 | |||
|
| Platinum Member |
Putting semicolon at the end of if statements does not work Using FOC_NONE or _FOC_NULL works, but the issue would be searching for every occurrence of '$*' in all the fex's. I tried the second condition with CONTAINS and it seem to work. The other thing is, this kind of issue occurs only on the indexed fields. Thats strange WebFOCUS 7703/7705/8105m/8201m/8202m | |||
|
| Guru |
I just tried it and it worked fine WF 7.6.11 Oracle WebSphere Windows NT-5.2 x86 32bit | |||
|
| Platinum Member |
On which version have you tried?... I had the issue when i run on v8 WebFOCUS 7703/7705/8105m/8201m/8202m | |||
|
| Guru |
Aha, I am on 7.6.11 WF 7.6.11 Oracle WebSphere Windows NT-5.2 x86 32bit | |||
|
| Platinum Member |
Yep.. It worked for us when we were in 7.6.11 too. I guess you are with me then.  WebFOCUS 7703/7705/8105m/8201m/8202m | |||
|
| Guru |
Did you try using a WHERE instead of the second IF ? WF 7.6.11 Oracle WebSphere Windows NT-5.2 x86 32bit | |||
|
| Platinum Member |
yes... it didn't work WebFOCUS 7703/7705/8105m/8201m/8202m | |||
|
| Master |
WF1326, I am running wf V8008 and I had no issues with your example. I tried it with the car file and with one of my oracle tables. Can you run a SQL trace on your query? maybe something isn't translating correctly. Its possible depending on your query that things aren't translating to SQL correctly. Unfortunately I can't recreate it, so I can't run the trace. Eric Woerle 8.1.05M Gen 913- Reporting Server Unix 8.1.05 Client Unix Oracle 11.2.0.2 | |||
|
| Virtuoso |
No problem with V.8.0.0.7. Maybe a downgrade is the solution?...  Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF | |||
|
| Platinum Member |
None of my options worked. I opened a case with ibi. WebFOCUS 7703/7705/8105m/8201m/8202m | |||
|
| Platinum Member |
IBI came up with a solution SET AUTOINDEX=OFF My code works now WebFOCUS 7703/7705/8105m/8201m/8202m | |||
|
| Expert |
It intrigues me as to how not using indexes makes it work. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Issue with multiple IF clauses on the same column in multiple lines
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Issue with multiple IF clauses on the same column in multiple linesCopyright © 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 |