How to display Field Changes captured in Activity Stream in Portal widget ?

[zaturntoshlance]

These are the field changes available in Activity stream from the Instance Platform View.

However, In the Portal form widget Only the Addl.Comments and Work Notes are visible. But I want to display the field changes too. How do I do it ?

I even cloned the widget-ticket-conversation and tried to log the $sp.getStream(data.table, data.sys_id) and this method does not retrieve field changes.

[sieusaopolo15]

Hi @zaturntoshlance,

Have you found any solutions for this ? Because i'm truggle like in your case. I can't figure any way but config the server code then load the data to HTML and that's a lot work. I want to know is there a way that service portal provides but i'm missing it.

[soumyagupta]

Have you found any solution?

[josteinenge]

I was trying to find a fix for the same problem. I found out that my values was stored in sys_audit_list, not sys_journal_field_list as work_notes are.

This is my code for retrieving field changes. Hope it helps.

var LatLngHistory = [];
var currentLat = null;

ImportOverviews.forEach(function(overview) {
var gr = new GlideRecord('sys_audit');
gr.addQuery('tablename', 'tablename');
gr.addQuery('fieldname', 'IN', 'latitude,longitude');
gr.addQuery('documentkey', overview.sys_id);
gr.query();

while (gr.next()) {
if (gr.fieldname == 'latitude') {
currentLat = parseFloat(gr.newvalue.replace(',', '.'));
} else if (gr.fieldname == 'longitude' && currentLat !== null) {
LatLngHistory.push({
lat: currentLat,
lng: parseFloat(gr.newvalue.replace(',', '.')),
sys_id: overview.sys_id, 
});
currentLat = null;
}
}
});

data.LatLngHistory = LatLngHistory;

[Roshni1]

Hi I am having this issue and this is the script I currently have. Is this where I update the sys_audit?