Home

HOW TO USE "LIKE" OPERATOR IN QUERYBUILDRANGE

To make something as the LIKE operator in a query, just assign a value to the QueryRange including a wildcard. static void QueryBuildRange_Sample(Args _args) { Query query = new Query(); QueryRun queryRun; QueryBuildDataSource qbds; QueryBuildRange queryRange; Cu...

Read more

DefaultValue ComboBox in Dynamics AX with X++

Beside modify metadata on form properties, as best practice we can use code like below to assign default value for combobox. You can use this code in the form’s init method after super(): ComboBoxName.selection(ComboBoxName::DefaultValue); If this is a table field we should you best practice overriding the initValue method in the table...

Read more

Rename a Database in SQL Server

Open Microsoft SQL Server Management Studio. Connect to the server where in the DB you want to rename is located. Modify the following script and run it -- Replace all MyDBs with the name of the DB you want to change its name USE [MyDB]; -- Changing Physical names and paths -- Replace all NewMyDB with the new name you wa...

Read more

AxBuild.exe for Parallel Compile on AOS

If you have only 10 mins to build ax, try this In AOS server, go to C:\Program Files\Microsoft Dynamics AX\60\Server\DAX\bin and open cmd from here then run this command axbuild.exe xppcompileall /s=01 /altbin="C:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin" Result Once compile complete, you can import compile log file at C:\...

Read more

List Page Interaction Class

Form interaction classes that allow user interface control logic to be shared across forms. For instance, controlling which buttons are available to a list page and the associated detail form. The interaction classes are extending a base ListPageInteraction class. This has some methods supported by the kernel to interact e.g. with initializatio...

Read more

How to deploy all the reports in AX2012 by using Management Shell

Login to the AX AOS server and follow below steps. Click Start > Administrative Tools. Right-click the Microsoft Dynamics AX 2012 Management Shell option. Click Run as administrator. Go to PowerShell command prompt and run with command Publish-AXReport –ReportName * Wait up to getting Deployment successful ...

Read more