public void lookup()
{
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange queryBuildRange;
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(CustPaymFee), This);
;
//2daydate = today();
sysTableLookup.addLookupField(fieldNum(CustPaymFee, FeeId));
sysTableLookup.addLookupField(fieldNum(CustPaymFee, Description));
sysTableLookup.addLookupField(fieldNum(CustPaymFee, LedgerJournalType));
queryBuildDataSource = query.addDataSource(tableNum(CustPaymFee));
queryBuildDataSource.addRange(fieldNum(CustPaymFee, PSMFromdate)).value("<"+SysQuery::value(today()));
//queryBuildRange.value('<='+SysQuery::value(today())); <= its not working
queryBuildDataSource.addRange(fieldNum(CustPaymFee, PSMtodate)).value(">"+SysQuery::value(today()));
//queryBuildRange.value('>='+SysQuery::value(today())); >= its not working
sysTableLookup.parmQuery(query);
// Perform lookup
sysTableLookup.performFormLookup();
}
All Archives in this blog may be used for the Junior,Dummies or someone who just started for career at Dynamics Ax ... A Place Where U can Start ur Code - right here ...
Langganan:
Posting Komentar (Atom)
Cloud hosted environment di D365
Biasanya kita menginginkan sebuah environment yang sama dengan LIVE/PROD untuk mengtest sebuah proses. Maka kita bisa menggunakan fitur Clou...
-
When we work with entries data that contain sequence number sometime we need an improvement to create in another way, a Generate perhaps. ...
-
"Error while setting server report parameters. Error Message: The item ´/DynamicsAx/PurchPurchaseOrderreport.Report4´ cannot be found ...
-
Public Common lookupReference() { Common ret; ret = HcmWorker::PSM_LookupReffWorker_ByDept(this,strFmt("%1...
Tidak ada komentar:
Posting Komentar