Tuesday, February 15, 2022

Lookup - Unique value and Non repeating value after selection

 

   We need to Group by for distinct values :

   QueryBuildDataSource.orderMode(OrderMode::GroupBy);

QueryBuildDataSource.addGroupByField(fieldNum(TableName, FieldName));
For lookup to not show duplicate value after selection use below:
sysTableLookup.parmUseLookupValue(False);

No comments:

Post a Comment

Sample Dialog Syntax - 1

 class AffiliationAutoAssignment extends RunBaseBatch {     // 1. Class Declaration and Pack variables     #define.CurrentVersion(1)     #de...