Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Multi-Select Filter Only Recognizes Last Selection
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Multi-Select Filter Only Recognizes Last Selection
 Login/Join
 
Member
posted
Hello!

I'm trying to code for a multi-select variable. The following code works for a single selection, but if multiple options are checked, only returns the last option selected:
  TABLE FILE CAR
	SUM SALES
	BY CAR
	WHERE (COUNTRY EQ &strCountry.(OR(FIND COUNTRY,COUNTRY IN CAR)).Country. );
END


I've dabbled with single quotes around the variable/find, to no avail.

Any suggestions on making a multiple option variable function correctly?

WF 8.1 for this project.

Thanks!
Jay

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8.1/8.2, Windows 10/Server 2012
 
Posts: 20 | Location: Baltimore, MD | Registered: April 30, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
You need an OR like this:
 
	WHERE COUNTRY EQ &COUNTRY.(OR(FIND COUNTRY IN CAR |FORMAT=A10,SORT=ASCENDING,REQUIRED=TRUE)).COUNTRY:.;


WebFOCUS 8206, Unix, Windows
 
Posts: 1716 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Master
posted Hide Post
Syntax: How to Add a Dynamic Multiselect List of Values:
 &variable.(operation (FIND return_fieldname [,display_fieldname] IN datasource[|SORT=sortoption] [|FORMAT=format] [,WITHIN=within])).[description.] 

Docs: https://infocenter.information...4b-9910-20CFB80AA381

Once there, click on "Adding a Multiselect List of Values" then "Add a Dynamic Multiselect List of Values"

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


Hallway
WF(Prod):8202M
WF(Test):8202M
OS/Platform:Win 10
Outputs:All
 
Posts: 493 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Multi-Select Filter Only Recognizes Last Selection

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.