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

Missing_index in D365FO

 Refrence: sys.dm_db_missing_index_details (Transact-SQL) - SQL Server | Microsoft Learn