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

Threads.Text resulting in duplicate values in ROQL

Received Response
6
Views
1
Comments
edited Sep 7, 2017 6:37AM in Integrations and APIs 1 comment

Content

Hi,

I am trying to search a string in Threads.Text as

SELECT ReferenceNumber from Incident Group By Threads.Text HAVING Threads.Text LIKE '%test%'

This query is giving the duplicate result (i.e. ReferenceNumber)

None of the below queries are working

1) SELECT DISTINCT  ReferenceNumber from Incident Group By Threads.Text HAVING Threads.Text LIKE '%test%'

     Error: near "DISTINCT": syntax error

2) SELECT COUNT(DISTINCT ReferenceNumber), ReferenceNumber from Incident Group By Threads.Text HAVING Threads.Text LIKE '%test%'

Output : This query is also giving duplicate results.

Can anyone let me know how to fix this issue.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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