Below is the code snippet.
Note: In below line the number 4 is showing the number of datasource n in my case it is 4th datasource.
sysMultiTableLookup.addLookupField(fieldNum(OMHierarchyType, Name),4);
Final output
Wednesday, 13 February 2019
SysMultiTableLookup - A way to show fields from multiple tables within custom lookup
Today , I will be discussing about one of the common issue which we might face while showing fields from multiple tables in lookup . As we all know SysTableLookup only pick up fields from first data source. However, in few cases we might need to show fields from multiple tables for instance I need to show operating unit number but as well as organization hierarchy Name which is field of 4th data source within my custom. In order to achieve this target I will be using SysMultiTableLookup class.
Below is the code snippet.
Note: In below line the number 4 is showing the number of datasource n in my case it is 4th datasource.
sysMultiTableLookup.addLookupField(fieldNum(OMHierarchyType, Name),4);
Final output
Below is the code snippet.
Note: In below line the number 4 is showing the number of datasource n in my case it is 4th datasource.
sysMultiTableLookup.addLookupField(fieldNum(OMHierarchyType, Name),4);
Final output
Subscribe to:
Post Comments (Atom)
Custom Business events Part 3 - (Activate custom business event) in D365 F&O
In this blog we will discuss about the steps to activate a custom business in D365 F&O. As we know that business event catalog does not...
-
Today, I will share another part of connecting azure blob storage with Dynamics 365 for finance and operations series. This part will be abo... -
Today I will be discussing about how to create batch job through x++. Before going in code lets discuss what are batch jobs. Batch job : ... -
Today, I will share another part of connecting azure blob storage with Dynamics 365 for finance and operations series. This part will be abo...
No comments:
Post a Comment
Note: only a member of this blog may post a comment.