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,

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)).)

 

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.