Hi Cognoise,
I came across a requirement where based on the selection made in the 'Level' prompt either the [Column] has to be substringed ('Level' = 1) or if a user selects other than 'Level' = 1 then the choices/parameter values user has selected from the search & select prompt should be passed with a 'LIKE' wildcard that would mimic -->[Column] starts with 'parameter_value_1%' and [Column] starts with 'parameter_value_2%'
if (?Level? = 1)
then ( substring ([Column], 1, 6) in ?prompt_contract? )
else ( --- this where I believe the prompt macros would help if two or more parameter selection have been made from search and select prompt
[Column] LIKE 'abc%'
or [Column] LIKE 'xyz%'
or [Column] LIKE 'qrs%'
)
It would be nice if the expression above can be transformed into Prompt macros in its entirety. Your help on this would be greatly appreciated.