When we amend the code to explicitly add the comma...
# suitescriptk
Kushington
05/29/2024, 3:40 PMWhen we amend the code to explicitly add the comma seperate externalid in the suitescript, it works
Copy code
if (datareceived.externalid != null) {
const extId = datareceived.externalid.toString();
if (extId.indexOf(",") > 0){
log.debug("externalid has comma");
formattedExtId = "\"" + extId.replace(",", "\",\"")+ "\"";
} else {
formattedExtId = extId;
}
log.debug("formattedExtId: " + formattedExtId);
filterArray.push("AND");
filterArray.push(["externalid", "anyof", "order1","order2"]);
log.debug("externalid is provided: " + datareceived.externalid);
}a
Anthony OConnor
05/29/2024, 3:50 PM Copy code
if (datareceived.externalid != null) {
let extId = datareceived.externalid.toString();
if (extId.indexOf(",") > 0){
log.debug("externalid has comma");
extId = extId.split(",");
}
log.debug("extId : " + extId );
filterArray.push("AND");
filterArray.push(["externalid", "anyof", extId]);
log.debug("externalid is provided: " + datareceived.externalid);
}Anthony OConnor
05/29/2024, 3:50 PMjust make your incoming string list into an array with
.splitk
Kushington
05/29/2024, 3:52 PMthank you both inc @Clay Roper, will give these a go!
a
Anthony OConnor
05/29/2024, 3:52 PMif its still not working post logs, without knowing the data we're just guessing
k
Kushington
05/29/2024, 4:01 PMreceived an error stating
Copy code
missing ; before statementKushington
05/29/2024, 4:03 PMwhen we replace, 'let' with 'const' we are able to save the script.
Kushington
05/29/2024, 4:04 PMgot it working now 🙂 final code
Copy code
f (datareceived.externalid != null) {
const extId = datareceived.externalid.toString().split(",");
log.debug("extId : " + extId );
filterArray.push("AND");
filterArray.push(["externalid", "anyof", extId]);
log.debug("externalid is provided: " + datareceived.externalid);
}🎉 1
a
Anthony OConnor
05/29/2024, 4:05 PMk well the code sample is reusing extid, so const wouldn't work, hence why i used let
Anthony OConnor
05/29/2024, 4:05 PMoh yeah actually that's fine, you don't need to test for comma, cos split will just give you an array of size 1
🎯 1
k
Kushington
05/29/2024, 4:06 PMThanks for your help, defo a good starting point for us
👍 1
3 Views