How to add subquery result in X++ FO D365

 If you want to add a subquery result in the lookup x++, Kindly follow the following steps;

1 - You have to create a temp table;

  TableTmp tableTmp;

2- Add all records of TableA in the temp table as show below;

      tableTmp.clear();

            while select TableA 

            {

                tableTmp.RequestId = TableA .RequestId;

                      tableTmp.doinsert();      

            }

3- Remove the record you don't need in the tempTable, Which exists in TableB as shown below;

    while select TableB

            {   

                select firstonly tableTmp where tableTmp.RequestId == TableB.RequestId;

                

                if(tableTmp )

                {

                    tableTmp .doDelete();

                }

            }

            select tableTmp ;

4- The complete code for the lookup field is shown below;


             TableA tableA ;

            TableB tableB ;

              TableTmp tableTmp;

            tableTmp.clear();

            while select tableA 

            {

                 tableTmp.RequestId = TableA .RequestId;

                      tableTmp.doinsert();   

            }


           while select TableB

            {   

                select firstonly tableTmp where tableTmp.RequestId == TableB.RequestId;

                

                if(tableTmp )

                {

                    tableTmp .doDelete();

                }

            }

            select tableTmp ;


            SysTableLookup   sysTableLookup = SysTableLookup::newParameters(tableNum(TableTmp ), this);

            Query                   query = new Query();

            QueryBuildDataSource    queryBuildDataSource;

            QueryBuildRange         queryBuildRange;


            queryBuildDataSource = query.addDataSource(tableNum(TableTmp ));


            queryBuildDataSource.addRange(fieldNum(TableTmp ,RequestId));


            sysTableLookup.addLookupfield(fieldNum(TableTmp , RequestId));

            sysTableLookup.parmTmpBuffer(tableTmp );

            sysTableLookup.parmQuery(query);

            sysTableLookup.performFormLookup();


Comments

Post a Comment

Popular posts from this blog

Create custom workflow in D365 X++

Image
 For the creation of Custom Workflow in Dynamics 365 F&O, Kindly follow the following steps; 1. Create a custom Enum WorkflowStatus or you can use an existing one.   2. Create a new table EmployeeLeave as defined below and add the above Enum as a field and name it LeaveStatus . 3. Create a new form EmployeeLeaveForm by using the above table as a data source.   4. Create a new Display Menu Item EmployeeLeaveForm for the above form and add to any  Module by creating an extension of the Module Menu from the application Explorer. 5. Create a new Query EmployeeLeaveQuery  and add  EmployeeLeave as a data source.                 6. Create a new Workflow Category EmployeeLeaveCategory .   7. Create a new workflow type EmployeeLeaveWorkflowType .   • Category: Select the workflow category from the previous step • Query: Select the query created for the document table • Document menu item: Sel...
Read more

Convert amount from one currency to another currency using X++

  You can use the following X++ code snippet for currency amount conversion.     CurrencyExchangeHelper currencyExchangeHelper;     AmountMst amountMST;     CurrencyCode FromCurrency =  'PKR';     AmountCur amountCur = 5000;     currencyExchangeHelper = CurrencyExchangeHelper::newExchangeDate(Ledger::current(), systemDateGet());     amountMST =  currencyExchangeHelper.calculateCurrencyToCurrency(fromCurrency, SLDFabCostSheetsCalculation.Currency,amountCur,true);        info(strFmt("%1", amountMST));
Read more

How to Create Extended Data Types (EDTs) in Finance and Operations of Dynamics 365 -- F&O Customization Part 2

Image
For Creating Extended Data Types (EDTs) in Finance and Operations of Dynamics 365 follow the following steps: Step # 1:        Right-click on the project to Add -> New Items as shown in the figure;     When you click the New Item ,  the new window is open as shown in the figure;     Select the Data Types from the Side Bar and click on the Add button as shown in the figure; Step # 2:          Now right click on the EDT and select the Properties as shown in the figure;               When you click the Properties button, the left panel is open, you can set the properties of EDT here,           mostly used properties are Label and Help Test. I have created four EDTs as shown in the figure;           You can check the EDTs in the Application Object Tree ( AOT ) as shown in the figure;          If ...
Read more