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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Need to Filter Auto-Prompt Multi-select Parameter

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Need to Filter Auto-Prompt Multi-select Parameter
 Login/Join
 
Platinum Member
posted
Hello,

I need to filter down my results that I pull into a multi-select parameter that's being used in Designer. As of right now, the results that pull back into the multi-select is everything in the database.

In the example below, can someone advise how I can filter out England from the selections in the auto-prompt multi-select below?

 

TABLE FILE CAR
BY COUNTRY
WHERE COUNTRY EQ &COUNTRY.(OR(FIND COUNTRY, COUNTRY IN CAR)).
END

 

This message has been edited. Last edited by: Brandon Andrathy,


WebFOCUS 8204
 
Posts: 152 | Registered: July 10, 2018Report This Post
Platinum Member
posted Hide Post
Update, I found this code:

 

-DEFAULT &TEST = 'Midwest'
-DEFAULT &aregion = '_FOC_NULL';
-DEFAULT &ast     = '_FOC_NULL';
-DEFAULT &acity   = '_FOC_NULL';
 TABLE FILE ibisamp/ggsales
 SUM UNITS
  BY REGION
  BY ST
  BY CITY
  BY DATE
  ACROSS PCD
  WHERE
	WHERE REGION EQ &TEST.(FIND REGION IN GGSALES|FORMAT=A11).TEST.QUOTEDSTRING)
	AND	( REGION EQ &aregion.(FIND REGION IN GGSALES|FORMAT=A11, WITHIN=TEST).Region.QUOTEDSTRING )
    AND ( ST EQ &ast.(FIND ST IN GGSALES|FORMAT=A02,WITHIN=aregion).State code.QUOTEDSTRING )
    AND ( CITY EQ &acity.(FIND CITY IN GGSALES|FORMAT=A20,WITHIN=ast).City.QUOTEDSTRING );
 END


 


The only problem I am having now is I want to pull in the code part of the value than what is displayed in the front-end. When I try to modify the code, I get the error "Internal exception processing IBFSService.runAdHocFex ".

Does anyone know what I need to do to fix my syntas below?

 

WHERE
     WHERE AND  ACTIVE EQ &ACTIVE.(FIND ACTIVE IN _DST_STAR|FORMAT=I11).Active.QUOTEDSTRING ) 
		AND (_DIMQUALITYMEASUREKEYID EQ &MEASUREFULLNAME.(OR(FIND DIMQUALITYMEASUREKEYID, MEASUREFULLNAME IN _DST_STAR|FORMAT=I11, WITHIN=ACTIVE)).)

 


WebFOCUS 8204
 
Posts: 152 | Registered: July 10, 2018Report This Post
Platinum Member
posted Hide Post
never mind. It was all regarding my syntax.

for anyone else running into issues with parameter prompt chaining, here's my solution

 

-DEFAULT &COUNTRY = 'ENGLAND';
-DEFAULT &MODEL = '_FOC_NULL';

TABLE FILE CAR
BY COUNTRY
WHERE 
	WHERE COUNTRY EQ &COUNTRY.(OR(FIND COUNTRY, COUNTRY IN CAR)).
			AND(MODEL EQ &MODEL.(OR(FIND MODEL, MODEL IN CAR|WITHIN=COUNTRY)).)
END

 


You need have "|" between your master file and WITHIN clause.


WebFOCUS 8204
 
Posts: 152 | Registered: July 10, 2018Report 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     [SOLVED] Need to Filter Auto-Prompt Multi-select Parameter

Copyright © 1996-2020 Information Builders