Query WHERE Threads.Text
Anyone have any idea how I can query Incidents by the text of a thread. I know that I would also have to include certain parameters such as a date range or something else to limit the results. I started simple with a specific Incident.ID that has 3 Thread entries, and I seem to be unable to query one specific entry by it's Text field using either exact field string or the LIKE operator. Is this a restriction of the system itself? Or just our DB schema?
SELECT Threads.Text, Threads.ID from Incident Where ID = 4696558 AND Threads.Text LIKE '%FOOBar%'