Has anyone linked through to Servicenow and looked to pull back the latest update on an incident? I am pulling back all of the comments/worklogs but it obviously is just text wrapping. I only need the latest update status. Any ideas?
Thanks as always
you can pull from the sys_journal_field table where element_id = sys_id of the task you are looking at
this will give you the worklog/comments as separate items with there own properties such as value and date (which can be sorted to get the latest)