Focal Point Banner


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.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Testing the value in a field [SOLVED]

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Testing the value in a field [SOLVED]
 Login/Join
 
manglum
Platinum Member
posted
Hello! I am trying to figure out how to test the value in a table field. Here is the code I have below so far:

-SET &USER_NAME =myusername;

TABLE FILE EMPHIER
PRINT ACCESS_LEVEL USER_NAME
WHERE USER_NAME EQ '&USER_NAME';
ON TABLE HOLD AS USER_RECORD
END
-RUN

-*since there is only one record per USER_NAME in this table, the resulting table file request will always have one record unless the USER_NAME is invalid

What I want to do is check to see what the value of the field ACCESS_LEVEL (which is an alpha field) is and then do an IF statement to determine what to do depending on what the value of ACCESS_LEVEL is.

For instance, my thought would be something like this:

-IF ACCESS_LEVEL EQ 'LEVEL1' THEN GOTO LEVEL1ACCESS ELSE GOTO LEVEL2ACCESS;

This of course didn't work, which is why I am here :-)


Any help would be much appreciated and thanks in advance!

This message has been edited. Last edited by: manglum,


WebFOCUS 8
Windows, All Outputs
 
Posts: 111 | Registered: July 23, 2015Report This Post
Ricardo Augusto
Guru
posted Hide Post
You can handle this using a -READFILE or adding a global variable at server profile to get username and access_level.


I hope it helps.

See ya


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Report This Post
manglum
Platinum Member
posted Hide Post
Would the syntax for the -READFILE be something like this:

-SET &USER_NAME =myusername;

TABLE FILE EMPHIER
PRINT ACCESS_LEVEL USER_NAME
WHERE USER_NAME EQ '&USER_NAME';
ON TABLE HOLD AS USER_RECORD
END
-RUN
-READFILE USER_RECORDS
-TYPE ACCESS_LEVEL=&ACCESS_LEVEL


WebFOCUS 8
Windows, All Outputs
 
Posts: 111 | Registered: July 23, 2015Report This Post
Francis Mariani
Expert
posted Hide Post
YES!


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
j.gross
Virtuoso
posted Hide Post
Almost!

-READFILE USER_RECORDS
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Francis Mariani
Expert
posted Hide Post
Yikes!


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
manglum
Platinum Member
posted Hide Post
Yes, thanks for spotting the error!

Here is what I have now:

-SET &USER_NAME =myusername;

TABLE FILE EMPHIER
PRINT ACCESS_LEVEL USER_NAME
WHERE USER_NAME EQ '&USER_NAME';
ON TABLE HOLD AS USER_RECORD
END
-RUN
-READFILE USER_RECORD
-TYPE ACCESS_LEVEL=&ACCESS_LEVEL
-IF &ACCESS_LEVEL EQ 'LEVEL1' THEN GOTO LEVEL1ACCESS ELSE GOTO LEVEL2ACCESS;

However, when I run this code, it wants to know a value for ACCESS_LEVEL as if it doesn't know what it is?


WebFOCUS 8
Windows, All Outputs
 
Posts: 111 | Registered: July 23, 2015Report This Post
Waz
Expert
posted Hide Post
Add in before the TABLE FILE

-SET &ACCESS_LEVEL =;

OR

-DEFAULTH &ACCESS_LEVEL = {some dummy value} ;

The DEFAULTH will cause a warning of the amper variable being overwritten.

Also, you don't need USER_NAME in the TABLE FILE as you already have it


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
manglum
Platinum Member
posted Hide Post
quote:
-SET &ACCESS_LEVEL =;

THAT DID IT!

Thanks so much for your help!


WebFOCUS 8
Windows, All Outputs
 
Posts: 111 | Registered: July 23, 2015Report This Post
manglum
Platinum Member
posted Hide Post
THIS HAS BEEN SOLVED


WebFOCUS 8
Windows, All Outputs
 
Posts: 111 | Registered: July 23, 2015Report This Post
Waz
Expert
posted Hide Post
FYI

-SET &variable =;

Clears/removes/deletes the variable.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Testing the value in a field [SOLVED]

Copyright © 1996-2020 Information Builders