MutiSelet Look up on tmp table in d365 fo x++

  public void lookup()

 {

     container AssetCon;

     FormRun frlocal = this.formRun();

     FormRun CallerFormRun = frlocal.args().caller();

     if( CallerFormRun.args().caller())

     {

         FormRun ParentCallerFormRun = CallerFormRun.args().caller();

         FormDataSource ParentCallerFormDatasource = ParentCallerFormRun.dataSource(formDataSourceStr(EntAssetWorkOrderTable,WorkOrderLine));

         MK_EntAssetTmpSchedule_MK_ObjectID_Tmp tmpTable;

         EntAssetWorkOrderLine   workOrderLine;


         MultiSelectionHelper        multiSelectionHelper    = MultiSelectionHelper::construct();

         multiSelectionHelper.parmDatasource(ParentCallerFormDatasource);

         workOrderLine = multiSelectionHelper.getFirst();

    

         while(workOrderLine)

         {

             tmpTable.clear();

             tmpTable.ObjectID = workOrderLine.ObjectTable().ObjectID;

             tmpTable.insert();

     

             workOrderLine = multiSelectionHelper.getNext();

         }

 


         SysTableLookup              sysTableLookup = SysTableLookup::newParameters(tablenum(MK_EntAssetTmpSchedule_MK_ObjectID_Tmp), this);

         Query                       query = new Query();

         QueryBuildDataSource        queryBuildDataSource;

         QueryRun Qr;


         queryBuildDataSource = query.addDataSource(tablenum(MK_EntAssetTmpSchedule_MK_ObjectID_Tmp));

         queryBuildDataSource.addSelectionField(fieldNum(MK_EntAssetTmpSchedule_MK_ObjectID_Tmp,ObjectID));


         Qr = new QueryRun(query);

         Qr.setCursor(tmpTable);

       

         sysLookupMultiSelectGrid::lookup(query,this,this,this,AssetCon,Qr);

    

     }

 }

Comments

Post a Comment

Popular posts from this blog

step 20 Update script for service model: AOSService on machine: CR-VM-Test-1

  Hi, Cause: This can be either happening because of timeout or files being temporarily blocked. A general approach to resolve this issue would be the following: 1. Restart the Environment and try deploying the package again. 2. If that doesn't work, restart the Services and try deploying the package again.  3. If that doesn't work and if you see the below-mentioned error in the Log file: The process cannot access the file 'K:\AosService\WebRoot\bin\Microsoft.Dynamics.ApplicationPlatform.XppServices.Instrumentation.dll' because it is being used by another process,  following the below mentioned Action Plan should resolve the issue. Action Plan: 1. Open a PowerShell prompt as Administrator 2. Navigate to <Services drive>\DeployablePackages\<Runbook ID>\AOSService\Scripts 3. Create a temporary directory for log files 4. Execute: .\AutoUpdateAOSService.ps1 -LogDir <Log directory from step 3>. (Will likely take 75-100 minutes to complete) 5. Once the manua...
Read more

create movement journal through code in d365 FO x++

  One of the most common requirements these days is to create Inventory Movement Journal through code. Mostly when the input is coming from another 3rd Party application. Here is the code show below :-        InventJournalTable              inventJournalTable;        InventJournalTrans              inventJournalTrans;        InventJournalNameId             inventJournalName;        InventDim                            inventDim;        JournalCheckPost               journalCheckPost;              // Creation of Inventory Journal Header              inventJournalTable.clear();         ...
Read more