query
RESULTSET
query
  ACKNOWLEDGED ASSIGNEDTO CREATEDATE CREATEDBY DISPOSITION DISPOSITIONDATE DISPOSITIONUSER DUEDATE DUEDATENOTIFICATION EMAIL FREQUENCY JSONDATA OWNERID OWNERTYPE PARTNERCONTACTID PARTNERID PARTNERTYPE PRIORITY PROJECTID REMINDERDAYS REMINDERSENT REPEATFROM REPEATING REPEATUNTIL REQUESTEDBY SOURCEID SOURCETASKID SOURCETYPE SUBJECTID SUBJECTTYPE TASKCOMMENT TASKDESCRIPTION TASKID TASKTEMPLATEID TASKTYPE TASKTYPEID UPDATEDATE UPDATEDBY WORKFLOWREQUESTID
CACHED false
EXECUTIONTIME 7
SQL select tsk.*, mem.email from tbl_WRK_Tasks tsk with (nolock) inner join tbl_FSPRO_Members mem with (nolock) on mem.ownerId = tsk.ownerId and mem.fsl_tablecode = tsk.ownerType and mem.fspro_userId = tsk.assignedTo where tsk.ownerId = 207 and tsk.ownerType = 'MFR' and tsk.disposition = '?' and nullif( tsk.dueDate, 0 ) is not null and dateDiff( day, tsk.reminderSent, GetDate() ) <> 0 --and tsk.dueDateNotification = 1