Monday, January 16, 2012
Making string field a custom lookup on user selection
Sometimes we just compile our posts to keep the things at one place so we or someone can get it easily when we in need. This post belongs to the same concept :)
Requirement was to filter the records in grid according to the selection of base enum values from a lookup. Easy task :) but then I had to make a string field a custom lookup on selection of first value from base enum and to make it a read only on selection of second value of the base enum.
This is what I did;
public boolean modified()
ret = super();
if(str2enum(enum_variable,this.valueStr()) == enum::firstvalue)
stringField .text(' ');
// This lookup is populating users
Public void lookup()
Query query = new Query();
//Create an instance of SysTableLookup with the form control passed in
sysTableLookup = SysTableLookup::newParameters(tablenum(UserInfo), this);
//Add the fields to be shown in the lookup form
sysTableLookup.addLookupfield(fieldnum(UserInfo, id), true);
sysTableLookup.addLookupfield(fieldnum(UserInfo, name), false);
//create the query datasource
queryBuildDataSource = query.addDataSource(tablenum(UserInfo));
queryBuildRange = queryBuildDataSource.addRange(fieldnum(UserInfo, Id));
//add the query to the lookup form
// Perform lookup
// Method to get users
str 100 getusers()
str 100 Users;
While Select UsersTable where UsersTable .UserId == Curuserid()
Select Firstonly SysCompanyUserInfo where SysCompanyUserInfo.EmplId == UsersTable.Emplid ;
Users+= SysCompanyUserInfo.UserId +',';
Return '\"\"' ;
Return Users ;
As the LCS website gets slower and slower and the database backups get bigger and bigger. Use AZCopy to download objects out of LCS asset l...
This post focuses on the integration technologies available to have the Microsoft Dynamics 365 Finance Operations data available in Datavers...
One of the features of the dual-write is initial sync where you copy data from the source app (Finance Operation OR DataVerse) to the target...
MS D365 FinOps: How to create new LCS project and deploy Tier 1 (DEV) VM - Even you are not a MS customer or partner :) - Part IScenario: You are willing to work on Microsoft Dynamics 365 Finance Operations product and want to get your hand dirty with some developmen...