Unable to read/print value of 'instance.vars.hoursDiffValue1' in Alert activity from previous Javascript activity

Pleas help me to fix this

​@ParthaSarathy, ​@Manoj_Kumar , @all-could you please help me here

Hi ​@DikshaGu1, 

I think that the issue might be coming from calculating HoursDiff(GetDate(), MAX(tsLog)) directly inside sqlSelect(), instead of pulling MAX(tsLog) first and then working out the time difference in JavaScript.

You should also update the counter logic so it increases +1 each time the workflow runds while the log is not updating, rather than adding the full hour difference on every run.

Try with the following code: 

// Getting the latest tracking log timestamp
var lastTrackingTs = sqlGetDate("SELECT MAX(tsLog) FROM NmsTrackingLogRcp");

var hoursDiff1 = 0;

// Making sure we actually get a timestamp back
if (lastTrackingTs != null) {
  var now = getCurrentDate();
  hoursDiff1 = Math.floor((now.getTime() - lastTrackingTs.getTime()) / 3600000);

  if (hoursDiff1 < 0) {
    hoursDiff1 = 0;
  }
}

// Storing the value in the workflow instance variable
instance.vars.hoursDiffValue1 = hoursDiff1;
logInfo("hoursDiffValue1: " + instance.vars.hoursDiffValue1);

// Getting the current option value
instance.vars.noTrackingLogCountValue = Number(getOption("avNoTrackingLogCount") || 0);

// Updating the counter only if the tracking log is not updating
if (instance.vars.hoursDiffValue1 >= 1) {
  instance.vars.noTrackingLogCount2 = instance.vars.noTrackingLogCountValue + 1;
  setOption("avNoTrackingLogCount", String(instance.vars.noTrackingLogCount2));
  logInfo("instance.vars.noTrackingLogCount2: " + instance.vars.noTrackingLogCount2);
} else {
  instance.vars.noTrackingLogCount2 = 0;
  setOption("avNoTrackingLogCount", "0");
  logInfo("Tracking log is updating normally, counter reset to 0.");
}

Hope it helps. 

Regards, 

Celia

Hi ​@DikshaGu1 Instead of using Javascript code, you can just query the tracking log workflow via query and use split check the count in last 1,2,3 hours.