Lookup in AX 2012 and how to pass a Ranges

At the Datasource -> Field -> Methods -> Lookup



public void lookup(FormControl _formControl, str _filterStr)
{
    Query query = new Query();
    QueryBuildDataSource queryBuildDataSource;
    QueryBuildRange queryBuildRange;
    SysTableLookup  sysTableLookup;
    //super(_formControl, _filterStr);
    sysTableLookup = SysTableLookup::newParameters(tableNum(DMSChannelTable), _formControl);
               
    queryBuildDataSource = query.addDataSource(tableNum(DMSChannelTable));
    sysTableLookup.addLookupField(fieldNum(DMSChannelTable, ChannelCode));
    sysTableLookup.addLookupField(fieldNum(DMSChannelTable, Country));
    sysTableLookup.addLookupField(fieldNum(DMSChannelTable, DivisionCode));
    queryBuildRange = queryBuildDataSource.addRange(fieldNum(DMSChannelTable,DivisionCode),true);
    queryBuildRange.value(DMSPartnerBlockingTable_DivisionCode.valueStr());
    sysTableLookup.parmQuery(query);
    sysTableLookup.performFormLookup();
}



Comments

Post a Comment

Popular posts from this blog

Create RFQ through X++

static void CreateRFQ(Args _args) {     AxPurchRFQCaseTable         axPurchRFQCaseTable;     AxPurchRFQCaseLine          axPurchRFQCaseLine;     PurchRFQCaseTable           purchRFQCaseTable;     PurchRFQCaseLine            purchRFQCaseLine;     str         RFQCaseId;     NumberSeq numberSeq;     ;     numberSeq = NumberSeq::newGetNum(purchParameters::numRefPurchRFQCaseId());     numberSeq.used();     RFQCaseId = numberSeq.num();     axPurchRFQCaseTable = new AxPurchRFQCaseTable();     axPurchRFQCaseTable.parmRFQCaseId(RFQCaseId);     axPurchRFQCaseTable.parmBidType(PurchRFQBidType::Open);     axPurchRFQCaseTable.parmCurrencyCode('INR');     axPurchRFQCaseTable.save();     axPurchRFQCaseLine =...
Read more

Base enum values in Dynamics 365

By writing the statement 1 we will get the basenum id. And then writing the second statement we will get the list of total values. BaseEnum - 'LogisticsAddressElement Stataement 1 : select * from ENUMIDTABLE where name = 'LogisticsAddressElement' Stataement 1 : select * from ENUMVALUETABLE where ENUMID = 4709
Read more

Project Id through X++ code

void clicked() {     ProjTable                   projTable;     ProjInvoiceTable            projInvoiceTable;     ProjFundingSource           projFundingSource;     ProjFundingRule             projFundingRule;     ProjFundingRuleAllocation   projFundingRuleAllocation;     NumberSeq                   numberSeq,numberSeqInv;     NumberSequenceFormat        _numberSequenceMask;     ProjParameters      projParameters  = ProjParameters::find();     super();     ttsBegin;     numberSeq = NumberSeq::newGetNum(ProjParameters::numRefProjId());     numberSeqInv = NumberSeq::newGetNum(ProjParameters::numRefProjInvoiceProjId());     proj...
Read more