Hi
I'm using XI and an Oracle DB, and I'm trying to filter the report based on whether or not the "FAMIS_REQ.DESCRIPTION" field contains "too hot" or "too cold" or the like. The field contains other text than just "too hot" or "too cold." For instance, if FAMIS_REQ.DESCRIPTION is the text string "Room 34590 ACF too hot recurring issue" then I want that record to be included in the report.
It seems relatively simple, but the command does not exist in Select Expert. I would appreciate any help. Thanks!