rowfei
asked on
Select Expert use "Like" formula with multiple values parameter
I have one parameter have to setup for use to enter multiple values. In the Select Expert, I am using "Like" formula below and keep getting the error message.
{Command.Code} like "*" & {?CodeSet} & "*"
How can I make this like formula works with parameter with multiple values?
Thanks,
{Command.Code} like "*" & {?CodeSet} & "*"
How can I make this like formula works with parameter with multiple values?
Thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Not sure you can directly.
Try this
{Command.Code1} Like "*" & {?CodeSet1} & "*"
AND
{@yourFormula}
mlmcc
Try this
{Command.Code1} Like "*" & {?CodeSet1} & "*"
AND
{@yourFormula}
mlmcc
ASKER
mlmcc- I do have another criteria in the formula (works fine since this parameter is not multi-value). Please see it below.
{Command.Code1} Like "*" & {?CodeSet1} & "*"
How to combine it with your codes below together?
Local NumberVar Index;
Local BooleanVar bResult := False;
For Index := 1 to UBound({?CodeSet}) do
bResult := bResult OR ({Command.Code} like "*" & {?CodeSet}[Index] & "*";
bResult
Thanks again!!!