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     Multi-select variables and scheduling issue

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Multi-select variables and scheduling issue
 Login/Join
 
JDroke
Gold member
posted
When I try to schedule a fex with multi-select variables, I cannot select the values since the only option that is presented is "No selection". Is this a "feature" or am I doing something wrong?

i.e. WHERE SLSNAME EQ &Salesman.(OR(FIND SMNAME IN EISSM)).Salesman.; ---> works in MRE but not from ReportCaster scheduling


________________________________________________________________________________________
WebFOCUS 7.6.8 + Windows Server 2003 + DB2/400
 
Posts: 66 | Location: Nashville, TN, USA | Registered: January 16, 2008Report This Post
Hua
Guru
posted Hide Post
Your WHERE clause is built friendly for interactive jobs that users can see the drop down list of all salesmen in the file. When scheduling jobs, the scheduler expects you to supply a specific value for the salesman(one or all). You just have to change your WHERE clause to SALESMAN EQ &Salesman OR &Salesman EQ 'ALL', and supply proper value for the scheduled job.

I am currently schedule a bursting report by salesman. I wish WF allow a catch all email receipient, because I want some directly go to the salesmen, and the rest go the manager. And I have to specify every single salesman that goes to the manager.


Developer Studio 7.6.11
AS400 - V5R4
HTML,PDF,XLS
 
Posts: 305 | Location: Winnipeg,MB | Registered: May 12, 2008Report This Post
JDroke
Gold member
posted Hide Post
Thanks for the reply Hua and it appears that it's working the way you described but page 114 of the ReportCaster Development and Administration manual says it should work with a dynamic list just as I have coded it. I've opened up a case with IBI and they also said that it should work as the manual indicates and are looking into what I have wrong...


________________________________________________________________________________________
WebFOCUS 7.6.8 + Windows Server 2003 + DB2/400
 
Posts: 66 | Location: Nashville, TN, USA | Registered: January 16, 2008Report This Post
Rick Man
Platinum Member
posted Hide Post
I had a similar problem although it dealt with qualified names and your code doesn't seem to use that but maybe there is a relation. Here is my post: https://forums.informationbuilders.com/eve/forums/a/tpc/...451088692#2451088692


Reporting Server 7.6.10
Dev. Studio 7.6.8
Windows NT
Excel, HTML, PDF
 
Posts: 204 | Registered: March 31, 2008Report This Post
JDroke
Gold member
posted Hide Post
I looked a your thread Rick and I'm not using qualified names as you said. Thanks for the post. I guess I'm just waiting on IBI to figure something out.


________________________________________________________________________________________
WebFOCUS 7.6.8 + Windows Server 2003 + DB2/400
 
Posts: 66 | Location: Nashville, TN, USA | Registered: January 16, 2008Report 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     Multi-select variables and scheduling issue

Copyright © 1996-2020 Information Builders