Microsoft Dynamics Ax/D365 FO: 2023

Sunday, April 2, 2023

Create URL for specific record in D365FO using X++

To create a URL for a specific record, you'll need to know the unique identifier for that record. This could be a record ID, a customer number, or some other unique identifier that you use in your system.

Once you have the unique identifier, you can create a URL that includes that identifier. Here's an example:

Let's say you have a customer with the ID "12345". To create a URL for that customer, you could use the following code:

using Microsoft.Dynamics.AX.Framework.Utilities;

class DemoClass
{
    
    private static str buildAXURL(MenuItemName _menuItemName, MenuItemType _menuItemtype, DataSourceName _dataSource='', FieldName _field='', str _value='' )
    {
        UrlHelper.UrlGenerator generator = new UrlHelper.UrlGenerator();
        System.Uri currentHost = new System.Uri(UrlUtility::getUrl());

generator.HostUrl = currentHost.GetLeftPart(System.UriPartial::Authority);
        generator.Company = curExt();
        generator.MenuItemName = _menuItemName;
        generator.MenuItemType = _menuItemtype;
        generator.Partition = getCurrentPartition();
        generator.EncryptRequestQuery = true;

if(_dataSource != '')
        {
            UrlHelper.RequestQueryParameterCollection requestQueryParameterCollection;

requestQueryParameterCollection = generator.RequestQueryParameterCollection;
            requestQueryParameterCollection.UpdateOrAddEntry(_dataSource, _field, _value);
        }

System.Uri fullURI = generator.GenerateFullUrl();

return fullURI.AbsoluteUri;
    }

public static void main(Args _args)
    {
        str link;
        AccountNum accountNum = '12345';
        link = DemoClass::buildAXURL(menuItemDisplayStr(CustTable), MenuItemType::Display, formDataSourceStr(CustTable, CustTable), fieldstr(CustTable, AccountNum ), accountNum );

info(link);
    }

}

You can use this same code to create URLs for other types of records as well. Just replace "AccountNum" with the unique identifier for the record you want to link to.

Done!

The Statistics '_dta_dams_stat_2126801566_113_114_101_126' is dependent on column 'XXXXX'

Database synchronization is a crucial aspect of any application that relies on a database for storing and retrieving data. However, there can be times when the synchronization process encounters issues, causing data to be inconsistent or lost altogether. In this article, we'll explore a common cause of database synchronization issue and how to fixed it.

Error:

Sometimes during database synchronization we faced this kind of error:

Solution:

In order to fix this error, just run the below query in SQL server. After that run DB sync again. It'll run successfully.

Enjoy :)