Monday, February 10, 2025

Azure Devops configurations

The below link provides information on how to create a DevOps project and link it to LCS

Key points :

While creating a project Keep version control as Team Foundation Version Control.

Must copy the Public access token when linking with the LCS.

Setup Azure DevOps Project for Dynamics 365 Finance and Operations

...........................................................................................................................

The below link provides the information on how to create build server in LCS

how to create a Agent Pool, and branching

https://www.youtube.com/watch?v=k-Wnjf9T5YU

........................................................................................

The below link provides the information of how to create a Dev Machine.

How to connect VS to workspace.

https://www.youtube.com/watch?v=_r4qI94YaZk

Wednesday, February 5, 2025

Export data from all legal entities using DIXF

 Check the value of ‘Primary company context‘ in the entity. By default, it is set to ‘DataAreaId’. This means the data will be exported specific to the company.

Clear the value from this property if the requirement is to export data from all the legal entities in a single execution.



Tuesday, February 4, 2025

Code to get workflow assignee in X++

     public UserId getWorkflowAssignee()

    {

        WorkflowTrackingStatusTable workflowTrackingStatusTable;

        WorkflowWorkItemTable workflowWorkItemTable;

        UserInfo userInfo;

        UserId ret;

 

        select firstonly workflowWorkItemTable

            where workflowWorkItemTable.Type == WorkflowWorkItemType::WorkItem

                && workflowWorkItemTable.Status == WorkflowWorkItemStatus::Pending

            join workflowTrackingStatusTable

                where workflowWorkItemTable.CorrelationId == workflowTrackingStatusTable.CorrelationId

                    && workflowTrackingStatusTable.ContextTableId == this.TableId //your table id

                    && workflowTrackingStatusTable.ContextRecId == this.RecId 

                    && workflowTrackingStatusTable.TrackingStatus == WorkflowTrackingStatus::Pending

            join userInfo

                where workflowWorkItemTable.UserId == userInfo.id;

 

        if (workflowWorkItemTable.RecId)

        {

            ret = userInfo.id;

        }

        return ret;

    }

Workflow step name x++

I need to fetch the name of the "Step" of the workflow. 

For example:

In my workflow,  step1 : approved by teamlead (name of step)

step2: approved by manager (name of step)

so, I need to show the name i.e: approved by teamleader


public display Description currentStep()
{
    WorkflowTrackingTable             trackingTable;
    WorkflowTrackingStatusTable       trackingStatusTable;

    select RecId, User,Name, CreatedDateTime from trackingTable
    order by CreatedDateTime desc where
     trackingTable.TrackingType == WorkflowTrackingType::Creation &&
     trackingTable.TrackingContext == WorkflowTrackingContext::Step
    join trackingStatusTable
    where trackingTable.WorkflowTrackingStatusTable == trackingStatusTable.RecId &&
        trackingStatusTable.ContextRecId == this.RecId &&
        trackingStatusTable.ContextTableId == this.TableId;

    return trackingTable.Name;

}