 |
|||||
|
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] Using a Field in Dialogue Manager
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Using a Field in Dialogue Manager Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] Using a Field in Dialogue Manager | Login/Join |
| Gold member |
I am trying to compare the current date to a field from a table and am not sure how to tell dialogue manager which table to reference the field in. So I only want to be able to run this report on days we do a data load, the Load Date field is being pulled from my data table and I want to compare that to the current day and if they mirror and i execute the fex i want it to run the report and distribute output, else if the load date does not mirror the current dateand i execute the fex i want it to automatically exit and not run the report. This is what i currently have: -SET &RUN_REPORT = -IF LOAD_DATE EQ &MDYY THEN GOTO OUTPUT_REPORT - ELSE GOTO EXIT; I am tagging my report as -OUTPUT_REPORTThis message has been edited. Last edited by: <Kathryn Henning>, WebFOCUS 7.7 and WebFOCUS 8 Windows, All Outputs | ||
|
| Virtuoso |
Lynsi, Welcome to the forum. Your question shows that you are not schizophrenic enough! Jokes aside, this is how WebFOCUS executes a procedure: The procedure is loaded from disk WF reads the lines. If a line starts with a - this is executed immediately. If not the line is sent to the stack. Once all lines are read, then, and only then, are commands executed from the stack. This means that you have no way of comparing a field value to a variable (&VAR) in a dialog manager line (one starting with a -). What you have to do is extract the value of LOAD_DATE form your file, output it to a HOLD or SAVE file, read (-READ or -READFILE) the value from output file to a variable and then perform your comparison. I hope I'm clear. Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF | |||
|
| Virtuoso |
What may be easier in this case is to move the filter into your table request and check whether you get any lines of output, using the automatically filled variable &LINES. If that number equals zero, you can abort right away. If it's > zero, the report can continue on. WHERE LOAD_DATE EQ &MDYY; END -RUN -IF &LINES GT 0 THEN GOTO OUTPUT_REPORT; -EXIT WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010 : Member of User Group Benelux : | |||
|
| Gold member |
I was able to get this to work. Thank you very much for the suggestions. WebFOCUS 7.7 and WebFOCUS 8 Windows, All Outputs | |||
|
| 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] Using a Field in Dialogue Manager
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Using a Field in Dialogue ManagerCopyright © 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 |