Monday, September 12, 2016

Get Workflow Comment ax 2012

//Workflow Comment ax 2012

WorkflowTrackingStatusTable trackingStatusTable;
 WorkflowTrackingTable trackingTable;
 WorkflowTrackingCommentTable trackingCommentTable;
    WorkflowComment comment;
while select trackingStatusTable
            where trackingStatusTable.ContextRecId == 5637154368
    join trackingTable
        where trackingTable.WorkflowTrackingStatusTable == trackingStatusTable.RecId
            join trackingCommentTable
                where trackingCommentTable.WorkflowTrackingTable == trackingTable.RecId
 {
    comment = trackingCommentTable.Comment;
     info(strFmt("%1",comment));
 }

No comments:

Post a Comment

Disabling the flight in D365FO (CHD - Tier 1)

 INSERT INTO dbo.SYSFLIGHTING(FLIGHTNAME, ENABLED)  VALUES ('<FlightObjectName>_KillSwitch', 1)  or  INSERT INTO dbo.SYSFLIGHT...