Unable to read/print value of 'instance.vars.hoursDiffValue1' in Alert activity from previous Javascript activity | Community
Skip to main content
Level 1
March 31, 2026
Question

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

  • March 31, 2026
  • 0 replies
  • 8 views

JAVASCRIPT ACTIVITY CODE:


var res = sqlSelect(
  "row,diff1:long",
  "SELECT HoursDiff(GetDate(), MAX(tsLog)) AS diff1 FROM NmsTrackingLogRcp"
);

var hoursDiff1 = 0;
if (res.row && res.row.length() > 0) {
  hoursDiff1 = Number(res.row[0].diff1.toString());
}

// Store in the workflow instance variable (available within this workflow run)
instance.vars.hoursDiffValue1 = hoursDiff1;

//logging the hoursDiffValue1
logInfo("hoursDiffValue1: " + instance.vars.hoursDiffValue1);

//Adding if condition

if(instance.vars.hoursDiffValue1 >=1)
{
instance.vars.noTrackingLogCountValue = Number(getOption("avNoTrackingLogCount"));

instance.vars.noTrackingLogCount2= instance.vars.hoursDiffValue1 + instance.vars.noTrackingLogCountValue;
// logging instance.vars.noTrackingLogCount2
logInfo("instance.vars.noTrackingLogCount2: " + instance.vars.noTrackingLogCount2);
// setting Option
setOption("avNoTrackingLogCount" , instance.vars.noTrackingLogCount2);
}

ALERT ACTIVITY CODE:

Hi Team,

<% if (instance.vars.sendtrackingmailpart1 == 1) { %>
Tracking log has not been updated for the past <%= instance.vars.hoursDiffValue1 %> hour.
<% } %>

 

<% if (instance.vars.sendbroadlogmailpart1 == 1) { %>
Broad log has not been updated for the past <%= instance.vars.hoursDiffValue2 %> hour.
<% } %>

 

<% if (instance.vars.sendtrackingmailpart2 == 1) { %>
Tracking log has not been updated for the past <%= instance.vars.hoursCheck1 %> hour.
<% } %>

 

<% if (instance.vars.sendbroadlogmailpart2 == 1) { %>
Broad log has not been updated for the past <%= instance.vars.hoursCheck2 %> hour.
<% } %>
Pleas help me to fix this
@ParthaSarathy, ​@Manoj_Kumar , @all