DE
ENA single search prompt can be more flexible when users need to find several terms at once.
Practical approach
Build carefully controlled parameter handling to convert multiple input terms into the intended query conditions, using prompt macros where appropriate.
Validation and limitations
Validate separators, empty values and escaping; never treat arbitrary prompt input as trusted SQL.
Expression or example from the original article
The following example is retained from the original technical article. Verify syntax before using it with your Cognos version.
[Produkttyp] contains ?p_suchwort?AI-assisted translation and adaptation.
