Filter odata by enum in the URL

So apparently you cannot use simple string filter to filter odata by enum. You have to reference the enum that you are using in the URL.

For example if you want to filter salesLine data entity by SalesLineStatus field with value invoiced, you have to do the following$filter=SalesOrderLineStatus eq Microsoft.Dynamics.DataEntities.SalesStatus'Invoiced'


Data entity name –  SalesOrderLines

field name – SalesOrderLineStatus

Enum name – SalesStatus

Referenced enum value – Invoiced


Data import export in ax 2012. When we need to add few new fields to the exported document that exist in source table.

1. Add fields to the source table

2. Add fields to the entities tmp table

3. Create new processing group DAT/Data import export framework/Common/processing group/new

4. open entities and generate mapping

5. modify source mapping

6. Ensure target mapping is correct

– View target mapping

–  if incorrect

– DAT/Data import export framework/Common/Setup/Target entities, choose correct entity

– modify target mapping

– refresh diagram

– switch to mapping details

– Generate mapping 9 from scratch)

– update mapping if required

– save

7. (tiny button after entities button)From processing group get staging data

8. copy data to target

9. check if everything worked successfully
Tips: – when testing file, before import of staging data to the staging table ensure that the file that you’re working with, is closed.

How to order form grid by field that is not included in the data source

So this can be done by updating a query method init of the data source on which grid is based:


 QueryBuildDataSource qbds;
 QueryBuildDataSource qbds2;
 QueryBuildDataSource qbdsn;

//original data source
qbds = DataSource_ds.query().dataSourceTable(tableNum(DataSourceTable));

 qbds2 = qbds.addDataSource(tableNum(OtherTable));
 qbdsn = qbdsn-1.addDataSource(tableNum(OtherTableN));
 qbdsn.addSortField(fieldNum(OtherTableN, FieldYouWantToSortOn));

Manually order record in the form grid

You know those kind of forms where you can use buttons to order records in the right position?

It is quite easy to replicate. It won’t work for all solutions though,

Example of the standard code is a WHSLocDirTable form.

To implement this solution you would have to make changes to the source table ( Add additional field, index, field group , methods for update , insert and delete, as well as moving logic,)

add changes to the the form ( additional field, buttons for up and down and related code, as well as make changes to init method of the form ( to sort by position) and some changes that will have to be implemented on the data source. )



Compare two records in X++ D365FO

To compare tow records in dynamics 365 for operations you can use this code snippet that was created as a runnable class(job)

class job2Compare2Records
 /// <summary>
 /// Runs the class with the specified arguments.
 /// </summary>
 /// <param name = "_args">The specified arguments.</param>
   public static void main(Args _args)
     Table          table1,table2;
     RefRecid       recId1 = 68719517265;
     RefRecid       recId2 = 68719517264;

     container compareRecords(Common _record1, Common _record2)
          DictTable dictTable = new SysDictTable(_record1.TableId);
          DictField dictField;
          FieldId fieldId, extFieldId;
          container ret;
          int i, j;
          if (_record1.TableId != _record2.TableId)// checking if the same table records
               return conNull();
          int u = dictTable.fieldCnt();
          for (i=1; i<=u; ++i)
              fieldId  = dictTable.fieldCnt2Id(i);
              dictField = new SysDictField(_record1.tableId, fieldId);
              if (!dictField.isSystem())
                  for (j=1; j<= dictField.arraySize(); ++j)
                       extFieldId = fieldId2Ext(fieldId, j);
                       if (_record1.(extFieldId) != _record2.(extFieldId))
                            ret += [strfmt ("%1, %2, %3",fieldId2Name(_record2.TableId, extFieldId), _record1.(extFieldId), _record2.(extFieldId))];
          return ret;
      select table1 where table1.Recid == recid1;
      select table2 where table2.Recid == recid2;
      container a = compareRecords(table1 ,table2);

      for (int i=1; i <= conlen(a); i++)
          info(strFmt("container value %1 - : %2", i, conpeek(a, i)));


Lists in Dynamics 365 for Operation

There are 4 different data structures/collection classes/ that can be used when developing in D365.

  • Lists
  • Maps
  • Sets
  • Arrays
  • Structs

Most of these can be familiar from other languages. I will highlight the main points for these data structures, as well as provide examples of their usage. These data structures can be used to store any data types including objects.


List sequentially holds elements assigned to it. All values in the list must be of the same type.


To initiate the list you have to write following piece of code where instead of Types::Integer, you can use any type including objects.

List             list  = new List(Types::Integer);

Add values

To add values to already initialized list you can use one of the following functions.


Function addEnd ends a value in the end of the list. Alternatively, function addStart inserts new value in the beginning of the list.

Read values

To output all values from the list you can use following function.


if you want to get a specific value from the list, then you will have to use following code.

ListIterator     iterator;
enumerator = list.getEnumerator();
int i = enumerator.current();

ListEnumerator is the class that helps to iterate through list, by accessing each element of the list individually. To get a value of the list we are using function current()


    public static void main(Args _args)

        List                list  = new List(Types::Integer);
        ListEnumerator      enumerator;


        info( list.toString());

        enumerator = list.getEnumerator();


Line by line with visual explanation:

This line of code executes the initialization of the list.

List                list  = new List(Types::Integer);


description of the variable fro listEnumerator, that will help to get values from the list

ListEnumerator      enumerator;


Adding the first element with value 1 to the list from the end



Adding the second element with value 21 to the list from the end



Adding the third element with value 22 to the list from the end



Adding the fourth element with value 23 to the list from the end



Adding the fifth element with value 24 to the list from the end



Adding the sixth element with value 25 to the list from the end



Adding the seventh element with value 3 to the list from the beginning. If we were to start reading our list, the first element we will get will be the element with value 3



Initialization of the enumerator. Now enumerator is attached to the list. On the image below you may notice that enumerator looks like an arrow, and this arrow doesn’t point at any particular element.

enumerator = list.getEnumerator();


Because of that we have to reset the enumerators value to make sure that we will be pointing at the beginning of our list. After we use the function reset, the list enumerator “points” at the beginning of the list, not at the first element!



To move enumerator to the first element, you have to executed move next method. After that you can work with list elements. You can get the value of the list by using method current();



to move to the next element you can use the same operation. Notice you cannot move back, only move forward. If you need to start over,  you can use reset();





You can notice that there is no description of how to remove the value from the list. To do that you can use class listIterator method delete. As you may suggest , you have to be careful when using it, if you insert/ delete something from the list using iterator, when you have initialized enumerator, you will not be able to use enumerator without invoking error.

Jobs or Hello World in Dynamics 365 for Operations

There are no more jobs in D365 for Operations. Instead now you can use a runnable class.

Create project. Right click on the project/ add item/ dynamics 365 Items/code/ Runnable class (Job)


Enter the name,

Add some code to the method main.2

Right click on the new class select “Set as a startup object”

And press run