I'm trying to query a table on computer names and associated applications. This I don't have a problem with. My roadblock is that I want to provide the user with the ability to provide some keywords to exclude from the search of the application name.
I've created three parameters: Computer (single value string), Application (single value string), and Exclusions (multi-value string).
Here is the record selection formula that doesn't work because I haven't indexed my Exclusions array:
{vComputer.Name} like "*" + {?Computer} + "*" and
{Inv_AeX_OS_Add_Remove_Programs.Name} like "*" + {?Application} + "*" and
not(InStr({Inv_AeX_OS_Add_Remove_Programs.Name}, {?Exclusions}) = 0)
How can I accomplish what I'm trying to do?
I've created three parameters: Computer (single value string), Application (single value string), and Exclusions (multi-value string).
Here is the record selection formula that doesn't work because I haven't indexed my Exclusions array:
{vComputer.Name} like "*" + {?Computer} + "*" and
{Inv_AeX_OS_Add_Remove_Programs.Name} like "*" + {?Application} + "*" and
not(InStr({Inv_AeX_OS_Add_Remove_Programs.Name}, {?Exclusions}) = 0)
How can I accomplish what I'm trying to do?