 |
|||||
|
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] Newbie-need help please. Trying to create a different kind of variable
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Newbie-need help please. Trying to create a different kind of variable Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] Newbie-need help please. Trying to create a different kind of variable | Login/Join |
| Member |
Here's my scenario: Need to create a variable from a field in my master file called Line Type. That field contains a number of different values. What I want to do is to collect certain of those values into a new report variable, certain others into another variable, and an ALL that I can pass in on the html for the user to select. I'm struggling with the documentation on how I can do that. Can anyone help? Thanks and any help is much appreciated, JulieThis message has been edited. Last edited by: Kerry, WebFOCUS 7.6 AS400, v5r4 All output types | ||
|
| Virtuoso |
I'm not exactly sure what it is you are trying to accomplish, but basically you can't create a variable from a field. Variables are set using Dialogue Manager which cannot be used with fields. What you probably want to do is write a report getting all of your desired values and ON TABLE SAVE. Then use -READ against the SAVE file to populate those values into the desired variables. Regards, Darin In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat | |||
|
| Virtuoso |
Then again, if you're just looking for field values to populate a drop-down box, they don't need to be variables. You just create a procedure that gets the values you want and call that procedure in the HTML painter for your dynamic list/drop-down box. Regards, Darin In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat | |||
|
| Member |
I thought my example was clear, but maybe not. Field1 contains values = BF, NF, F, S, SN Need to collect values BF, NF, & F into a variable called FREIGHT or something like that. Need to collect values S, SN into a variable called PRODUCT or something like that. Then those two variables, plus ALL will be put into a list box for the users to select. This is all to prevent the users from having to select so many values up front. Thanks, Julie WebFOCUS 7.6 AS400, v5r4 All output types | |||
|
| Virtuoso |
The possible solution depend on the type of database. A SQL database gives other solutions than an flat file (text file) or focus database. Are you putting the variables into one list box or two boxes?
| |||||||
|
| Member |
One list box. It's an OS2 database - on the AS400. j WebFOCUS 7.6 AS400, v5r4 All output types | |||
|
| Virtuoso |
I think you want to tranlate the variables to either FREIGTH or PRODUCT so if the user clicks on the code BF or S the value FREIGTH or PRODUCT is send to an other application do I understand that correct? If so you can use the DECODE formula.
| |||||||
|
| Member |
No. Let me put it another way. I'm creating a status list where the Values are one thing and the Display is another. Can I create multiple values in this way? WebFOCUS 7.6 AS400, v5r4 All output types | |||
|
| Gold member |
I always create a DEFINE grouping the field values together before the report, then all you have to do on your HTML is use the defined field as the display field. I have to do that alot with my data. If a client wants Order Class A, B, and C to be House orders and then Order Class D, E, and F to be Corporate orders then I write a DEFINE: ORDER_TYPE/A20=IF ORDER_CLASS EQ 'A' OR 'B' OR 'C' THEN 'HOUSE' ELSE IF ORDER_CLASS EQ 'D' OR 'E' OR 'F' THEN 'CORPORATE' ELSE 'UNKNOWN' You can format the variable to be a multi-select and when you create the drop down on the HTML page, you can select however many order types you want or you can include the option of ALL. I'm using Order Class because that's my world, but you get the idea. Hope this helps. PROD: WebFocus 7.6.9 on WinXP | |||
|
| Virtuoso |
Or the other way around - don't worry about handling the values in your HTML page, but instead do it in your code. &PARM1 is set to 'PRODUCT' or 'FREIGHT' from the HTML page. Then: -SET &VALUES=IF &PARM1 EQ 'PRODUCT' THEN ''''|'S'|''' OR '''|''''|'SN'|'''' ELSE - IF &PARM1 EQ 'FREIGHT' THEN ''''|'BF'|''' OR '''|'NF'|''' OR '''|'F'|'''' ELSE '''XX'''; Then you could say WHERE FIELD1 EQ &VALUSE.EVAL ; Regards, Darin In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat | |||
|
| 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] Newbie-need help please. Trying to create a different kind of variable
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Newbie-need help please. Trying to create a different kind of variableCopyright © 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 |