How to get user to whom workflow is assigned using X++ in Dynamics 365 Finance & Operation

 public WorkflowUser isWorkflowApprover(Common _common)

{WorkflowTrackingStatusTable workflowTrackingStatusTable;
WorkflowTrackingTable  workflowTrackingTable;select firstonly RecId from workflowTrackingStatusTable
join User from workflowTrackingTable
order by WorkflowTrackingTable.CreatedDateTime desc
where workflowTrackingTable.WorkflowTrackingStatusTable ==    workflowTrackingStatusTable.RecId
&& workflowTrackingStatusTable.ContextRecId == _common.RecId
&& workflowTrackingStatusTable.ContextTableId == _common.TableId
&& workflowTrackingTable.TrackingContext == WorkflowTrackingContext::WorkItem;return workflowTrackingTable.User;}

Comments

Post a Comment

Popular posts from this blog

step 20 Update script for service model: AOSService on machine: CR-VM-Test-1

  Hi, Cause: This can be either happening because of timeout or files being temporarily blocked. A general approach to resolve this issue would be the following: 1. Restart the Environment and try deploying the package again. 2. If that doesn't work, restart the Services and try deploying the package again.  3. If that doesn't work and if you see the below-mentioned error in the Log file: The process cannot access the file 'K:\AosService\WebRoot\bin\Microsoft.Dynamics.ApplicationPlatform.XppServices.Instrumentation.dll' because it is being used by another process,  following the below mentioned Action Plan should resolve the issue. Action Plan: 1. Open a PowerShell prompt as Administrator 2. Navigate to <Services drive>\DeployablePackages\<Runbook ID>\AOSService\Scripts 3. Create a temporary directory for log files 4. Execute: .\AutoUpdateAOSService.ps1 -LogDir <Log directory from step 3>. (Will likely take 75-100 minutes to complete) 5. Once the manua...
Read more

create movement journal through code in d365 FO x++

  One of the most common requirements these days is to create Inventory Movement Journal through code. Mostly when the input is coming from another 3rd Party application. Here is the code show below :-        InventJournalTable              inventJournalTable;        InventJournalTrans              inventJournalTrans;        InventJournalNameId             inventJournalName;        InventDim                            inventDim;        JournalCheckPost               journalCheckPost;              // Creation of Inventory Journal Header              inventJournalTable.clear();         ...
Read more