Hi, has anyone try here to get the systemnotes old...
# suitescript
t
Hi, has anyone try here to get the systemnotes oldvalue/newvalue? I have the following script but it return null value for the oldvalue/newvalue of systemnotes. Thanks for the help in advance 🙂
const srch = search.*load*({
                
id: runtime.*getCurrentScript*().*getParameter*({name: config.PARAM.EMP_DET_SRCH_PARAM})
            
});
            
srch.filters.*push*(search.*createFilter*({
                
name: 'internalid',
                
operator: <http://search.Operator.IS|search.Operator.IS>,
                
values: empId
            
}));
            
srch.*run*().*each*(function(result) {
                
oldValue = result.*getValue*({name: 'oldvalue', join: 'systemnotes'});
                
newValue = result.*getValue*({name: 'newvalue', join: 'systemnotes'});
            
});
b
id start with checking that your first row has an old value and new value
and that the search has that column
t
thank @battk 🙂 got it.. i added the value on the saved search and just simply called it on my script