You need to sign in to do that
Don't have an account?
Varun Sharma 150
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.
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.
Can you try something like this?
SELECT Id, Status, ParentRecordId,ParentRecordType,WorkTypeId FROM ServiceAppointment where Status IN ('Preferred', 'Required Service') AND ParentRecordType = 'Workorder'
Anudeep
All Answers
Can you try something like this?
SELECT Id, Status, ParentRecordId,ParentRecordType,WorkTypeId FROM ServiceAppointment where Status IN ('Preferred', 'Required Service') AND ParentRecordType = 'Workorder'
Anudeep
Bhai Status (https://www.digitalkhabar.in/bhai-status-in-hindi/)
https://newgawai.wordpress.com https://hijaber.webnode.com