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

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.