You need to sign in to do that
Don't have an account?
BobP
last modified date keeps updating automatically
My company uses field service appointments and something unusual is happening.
when i click from list view to list view on the service appointments the last modified date and time changes to the current date and time. I can not find why this is happening or if there is a process running to tell me where the issue is. I can not click on Where the Field is used because it is a standard field. Does anyone know if there is a way I can find what is updating this field every second?
when i click from list view to list view on the service appointments the last modified date and time changes to the current date and time. I can not find why this is happening or if there is a process running to tell me where the issue is. I can not click on Where the Field is used because it is a standard field. Does anyone know if there is a way I can find what is updating this field every second?
Try using query like below to fetch the users Name: The field 'LastModifiedBy.Name' should give you the name of the user who last modified the Service Appointment record.
And query like below should return you the ID(LastModifiedBy.Id) of the user who modified the Service Appointment record: Hope above information helps, Please mark as Best Answer so that it can help others in the future.
Thanks.
All Answers
The last modified date on Service Appointment records would not change with list view refresh until and unless some background operation is in process.
To verify what could have modified the Service Appointment shown in the list view, you can try running below query in Developer console, which should give the correct track with reference to the field - 'LastReferencedDate': Ensure to apply WHERE clause and check with specific ID to track the user.
'LastReferencedDate': The date when the service appointment was last modified. Its label in the user interface is Last Modified Date.
Reference:
https://developer.salesforce.com/docs/atlas.en-us.field_service_dev.meta/field_service_dev/sforce_api_objects_serviceappointment.htm
Hope above information helps, Please mark as Best Answer so that it can help others in the future.
Thanks.
Thank you fo helping
How would I add a user to this query, What ID? can you give m e an example
SELECT Id, LastModifiedDate, LastModifiedById, OwnerId, LastViewedDate, LastReferencedDate FROM ServiceAppointment
Try using query like below to fetch the users Name: The field 'LastModifiedBy.Name' should give you the name of the user who last modified the Service Appointment record.
And query like below should return you the ID(LastModifiedBy.Id) of the user who modified the Service Appointment record: Hope above information helps, Please mark as Best Answer so that it can help others in the future.
Thanks.