Thanks Ratnakar,
I took a look at permissions but nothing really stood out. After messing around and taking a look I did find where the issue is coming through. One of the fields does have a coalesce setup on it.
This runs the following script, and I believe this is all OOTB when the extension is installed.
answer = (function transformEntry(source) {
var gr = new GlideRecord('change_request');
var queryRecords = false;
var correlation_id = source.u_correlation_id;
var number = source.u_number;
var queryByNumber = false;
// 1. Lookup by correlation_id
if (correlation_id && !correlation_id.nil() && correlation_id != "" ){
log.info("["+correlation_id+"]coalesce script : Querying by correlation id : "+correlation_id);
queryRecords = true;
gr.addQuery('correlation_id',correlation_id);
} else if (number && !number.nil() && number != "" ){
// 2. Lookup by number
log.info("["+number+"]coalesce script : Querying by change request number :"+number);
queryRecords = true;
queryByNumber = true;
gr.addQuery('number',number);
}
var logId = correlation_id;
if (queryByNumber) {
logId = number;
}
if (queryRecords){
gr.query();
if (gr.next()) {
// Update existing record
var sys_id = gr.sys_id;
log.info("["+logId+"]coalesce script : Record found with sys_id :"+sys_id);
return sys_id;
} else {
// Insert new record
log.info("["+logId+"]coalesce script : Record not found. Will be creating new record.");
return "-2";
}
} else {
// insert new record
log.info("coalesce script : Will be creating new record.");
return "-2";
}
})(source);
I found when I disable the Coalesce this allows for the pipeline to run and create the Change. However, the problem comes when our pipeline tries to update the states. How our process works is, pipelines initiate (creates a change in new state) > Flow asks for approval and moves to implement (if approved) > then in the pipeline once the stage has ran, this will update the change request to review/Closed.
The issue I get now since disabling the Coalesce is a new Change with the same number will be created in the review state.
