In CR, you would use a mult-value parameter to do exact string matches using the IN operator: {VIEW.HOST} IN {?ParameterName}
Yep, that works.
I wasn't clear of the type of a multi-valued parameter and how it expanded when used. It turns out that a multi-valued parameter is an array of strings. These are both string arrays:
["hdmcjunapp1", "hyp-app"]
["*app*", "mx*"]
Either can be used in a record selection formula:
{VIEW.HOST} in {?ParameterName}
{VIEW.HOST} like {?pHostName}
IN will do exact mathes; LIKE will match simple patterns. CR translate the LIKE into this:
WHERE ("VIEW"."HOST" LIKE '%app%' OR "VIEW"."HOST" LIKE 'mx%')
I'm letting users enter patterns by setting the 'Allow custom values' property of the parameter to true.
Thanks for the help!
PS: Why does the font of my post get small and turn blue? :-)
Edited by Tim Wise - 02 Jun 2008 at 7:42pm