Lookup in form level

/// <summary>



 /// Lookup for admin to select data projects of type import in DMF parameters form for users to use during quote import

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

[FormControlEventHandler(formControlStr(DMFParameters, KGSPP_DMFDefinitionGroup), FormControlEventType::Lookup)]

public static void KGSPP_DMFDefinitionGroup_OnLookup(FormControl sender, FormControlEventArgs e)



{

 SysTableLookup tableLookup;

Query query = new Query();

tableLookup = SysTableLookup::newParameters(tableNum(DMFDefinitionGroup), sender);

tableLookup.addLookupfield(fieldNum(DMFDefinitionGroup, DefinitionGroupName), true);

tableLookup.addLookupfield(fieldNum(DMFDefinitionGroup, OperationType));

QueryBuildDataSource qbds = query.addDataSource(tableNum(DMFDefinitionGroup));

qbds.addRange(fieldNum(DMFDefinitionGroup, OperationType)).value(queryValue(DMFOperationType::Import));



tableLookup.parmQuery(query);

tableLookup.performFormLookup();

}

Comments

Post a Comment

Popular posts from this blog

Event handlers and post handlers in D365

Event handlers and post handlers in D365 Shankar Das  Shankar Das     on 23 Mar 2018 2:03 PM  Let’s discuss today, how to get the table buffers, form control values, class parameters and method arguments etc., while writing our own event-handlers in D365. I’ll elaborate this using example code snippets in this post. There are already very useful posts on this topic you can look into. Here I required these event handlers while doing customization in Item master. Form data source event handler  [FormDataSourceEventHandler(formDataSourceStr(EcoResProductDetailsExtended, InventTable), FormDataSourceEventType::Written)] public static void InventTable_OnWritten(FormDataSource sender, FormDataSourceEventArgs e){     FormRun                 form           = sender.formRun();     FormDataSour...
Read more

How to Extend Sales Order Update Functionality to Custom Fields in D365 Finance and Operations

Image
How to Extend Sales Order Update Functionality to Custom Fields in D365 Finance and Operations by Bill Thompson | Feb 6, 2019 | Dynamics 365 for Finance and Operations , Dynamics AX My colleague Jeremy Dobler wrote this nice article on how to extend sales order update functionality to custom fields in AX 2012 . In this post, I’m going to show how to implement sales order update functionality to custom fields in Dynamics 365 Finance and Operations, and what changes are necessary when comparing to Dynamics AX. Sales Order Update Functionality D365 Finance and Operations vs. Dynamics AX New Fields Jeremy’s article states the following: “Once you have added the fields to the SalesTable and the SalesLine table and exposed the fields on the SalesTable form, add the new custom field to the HeaderToLineUpdate field group on the SalesTable Table.” In D365FO, the new fields will need to be added via a table exten...
Read more

Data entites method calling sequence in D365FO

Data entites method calling sequence in D365FO Here is a sequence of method’s calls during export: 1. initValue 2. validateField 3. validateWrite 4. update 4.1. doUpdate 4.1.1. persistEntity 4.1.1.1. doPersistEntity 4.1.1.1.1. initializeDataSources 4.1.1.1.1.1. initializeEntityDataSource Note: initializeDataSource is called once for each DataSource in Entity. 4.1.1.1.2. mapEntityToDataSources Note: initializeDataSource is called once for each DataSource in Entity. 4.1.1.1.3. saveDataSources 4.1.1.1.3.1. updateEntityDataSource 4.1.1.1.4. mapEntityToDataSource (maybe for another record) 4.1.1.1.5. saveDataSources 4.1.1.1.5.1. updateEntityDataSource for update operation and (insertEntityDataSource for insert) 4.1.1.1.5.1.1. mapDataSourceToEntity 4.1.1.1.5.1.2. doSaveDataSource 4.1.1.1.5.1.2.1. updateDataSource 4.1.1.1.5.1.2.1.1. preupInsertDataSource 4.1.1.1.5.1.2.1.1.1. validateWrite of table 5.0 postLoad Plus: postLoad This method is called during the exp...
Read more