Skip to main content
Topics#IntegrationVarun Sharma's Question
Varun Sharma (SalesForce India) asked in #Integration
Mar 24, 2020, 2:42 PM

SOQL to Get All Service Appointments scheduled to Preferred / Required Service Resources

HI,

I am looking to get an SOQL which can help to find all service Appointment which are scheduled to Preferred / Requried Service Resources. I am looking for a SOQL including ServiceAppointment, WorkOrder and WorkType.

 
4 answers
  1. Anudeep Gopagoni (Salesforce)
    Mar 24, 2020, 3:09 PM
    Hi Varun,

     Can you try something like this? 

    SELECT Id, Status, ParentRecordId,ParentRecordType,WorkTypeId FROM ServiceAppointment where Status IN ('Preferred', 'Required Service') AND ParentRecordType = 'Workorder'

    Hi Varun, Can you try something like this?

    Anudeep

     
Write an answer...
0/9000