Dynamics Community Forum Thread Details

How to display lookup of two different fields of two different data sources in D365FO X++ using lookup method.

Below is my code and not working

Query query;
QueryBuildDataSource queryBuildDataSourceTable;
QueryBuildDataSource queryBuildDataSourceLine;
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(AVADayPlanLine), _control);
query = new Query();
queryBuildDataSourceTable = query.addDataSource(tableNum(AVADayPlanLine));
queryBuildDataSourceLine = queryBuildDataSourceTable.addDataSource(tableNum(AVADayPlan));
queryBuildDataSourceLine.relations(false);
queryBuildDataSourceLine.joinMode(JoinMode::InnerJoin);
queryBuildDataSourceLine.addLink(fieldNum(AVADayPlanLine, DayPlanRefRecId), fieldNum(AVADayPlan, RecId), queryBuildDataSourceTable.name());

queryBuildDataSourceLine.fields().dynamic(NoYes::No);
queryBuildDataSourceLine.fields().clearFieldList();

queryBuildDataSourceTable.fields().dynamic(NoYes::No);
queryBuildDataSourceTable.fields().clearFieldList();

if (menuCycle.value())
{
queryBuildDataSourceLine.addRange(fieldNum(AVADayPlan, MenuCycleId)).value(queryValue(menuCycle.value()));
}

sysTableLookup.addLookupfield(fieldNum(AVADayPlan, MenuCycleId));
sysTableLookup.addLookupfield(fieldNum(AVADayPlanLine, MenuPlanDayParts), true);

sysTableLookup.parmQuery(query);
//sysTableLookup.performFormLookup();

SysLookupMultiSelectGrid::lookup(query,_control, _control, _control, conNull());

Categories:

Development / Customization / SDK

Quick Links

Leaderboard