Skip to main content

Posts

Showing posts with the label tableid

Query to get workflow last comment in Ax 2012

I want to highlight Query to get workflow last comment in Ax 2012. You can use ,WorkflowTrackingTable,WorkflowTrackingStatusTable  and WorkflowTrackingCommentTable   to get Last comment entered by used on submitting or approving workflow for module WorkflowTrackingTable workflowTrackingTable; WorkflowTrackingStatusTable workflowTrackingStatusTable; WorkflowTrackingCommentTable workflowTrackingCommentTable; PurchTable PurchTable; select PurchTable where PurchTable.PurchId ="PO13000003"; select ContextCompanyId, ContextTableId, ContextRecId from workflowTrackingStatusTable where workflowTrackingStatusTable.ContextCompanyId == curext() && workflowTrackingStatusTable.ContextTableId == PurchTable.TableId && workflowTrackingStatusTable.ContextRecId == PurchTable.RecId join firstonly TrackingId, CreatedDateTime from workflowTrackingTable order by CreatedDateTime desc where workflowTra...

Querybuilddatasource was not found error in Ax

Problem:-After implementation of CU 7, If you  have came across with this problem. Home > Activities > My Activities Solution: Define your position hierarchy and make sure it is working right and your user employee is assigned to a position. Q.how to define the position hierarchy and what is the relationship b/w position and hierarchy. In hr there is jobs and positions For each position you need to assign to which other position is it reporting and that is how you build position hierarchy