28 September 2017

AX 2012 lookup filter using query

public void lookup()
{
QueryBuildDataSource qbds;
Query query = new Query();
LanguageId language;

SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(EcoResProductTranslation), this);
sysTableLookup.addLookupfield(fieldNum(EcoResProductTranslation, Name));
qbds = query.addDataSource(tableNum(EcoResProductTranslation));
language = CompanyInfo::find().LanguageId;
qbds.addRange(fieldNum(EcoResProductTranslation, LanguageId)).value(queryValue(language));
qbds = qbds.addDataSource(tableNum(EcoResProduct));
qbds.joinMode(JoinMode::InnerJoin);
qbds.relations(True);

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

No comments:

Post a Comment

Give me the commetns and solutions

Ledger Voucher creation Framework and x++ code to create ledger voucher

 Please click her for MS reference file Below is the out of the box example reference and code. SalesInvoiceJournalPostSubBill_Extension->...