You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Query WHERE Threads.Text

Accepted answer
10
Views
1
Comments
edited Apr 28, 2017 2:07PM in Integrations and APIs 1 comment

Content

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?

Code Snippet

             SELECT Threads.Text, Threads.ID  from Incident Where  ID = 4696558 AND Threads.Text LIKE '%FOOBar%' 
        

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!