Case statement in Record Selection Editor 1

[kj27]

Hi All,

I have a parameter prompting the user to select a name, and in my record selection formula, I want to interpret that selection for the query (like an IN inside the WHERE clause):

{Table1.Field} = "Something" AND
{Table2.Field} in

Select {?User Parameter}
Case "Value1": "["6001", "6002"]"
Case "Value2": "["6005", "6008"]"
Default: ""

(i.e. I'd want the selection to be something like: {Table2.Field} in ["6001", "6002"]).

When hardcoding the statement like this, there are no errors. But I think because of the double-quotes, I get an error in the formula.

Any help is greatly appreciated.

 

[lbass]

{Table1.Field} = "Something" AND
(
Select {?User Parameter}
Case "Value1": {Table2.Field} in
["6001", "6002"]
Case "Value2": {Table2.Field} in
["6005", "6008"]
)

-LB

 

[kj27]

Thanks LB! I came up with a different solution - but this one is much cleaner.