Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Get the threads for the latest incident of a contact (single query) — Cloud Customer Connect
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

Get the threads for the latest incident of a contact (single query)

Accepted answer
112
Views
6
Comments
edited Nov 21, 2022 12:56AM in General Technical Discussions 6 comments

Summary:

Get the threads for the latest incident of a contact (single query)

Content (required):

We have a requirement for our vendor to retrieve all the threads for the latest incident of a contact. I am able to do this using two queries where I can find the latest incident based on createdTime and then use another query to pass this incident reference number from the first query. To avoid the network latency by making multiple calls, I need to accomplish this in a single query. I've tried using the joins, but it gives me an error. Also, I did not find much documentation related to ROQL and the defined objects.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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