Thursday, July 6, 2023

Add range of null (empty) string , d365 , x++

 Use following code to add range of empty or null string in any of the table , datasource field

  public void executeQuery()
  {
        QueryBuildDataSource qbds;
        QueryBuildRange         qbr;
        qbds = this.query().dataSourceTable(tableNum(CMSProspectParentTable));
        qbr = qbds .addRange(fieldNum(CMSProspectParentTable , ParentId));
        qbr.value("..");			//two dots are considers as empty string in ax
  }
Two dots are considered as empty string in ax

qbr.value("..");

No comments:

Post a Comment

Change SSRS Report Design Based On Condition , D365 ,X++

 To change Sales Invoice control document's design based on condition use following code. Here I have created COC of salesInvoiceControl...