Hi,
DateLoc = utcDateTimeNull();
or
DateLoc = DateNull();
Regards,
The purpose of this blog is for knowledge sharing and connect the relevant audience who are all into Microsoft Dynamics world.
Alfasith AX
Thursday, February 19, 2015
Wednesday, February 11, 2015
Multiple query values on same field in X++(Dynamic query)
Hi,
static void AlfasithMultipleQueryValue(Args _args)
{
HcmWorker HcmWorker;
QueryRun queryrun;
QueryBuildDataSource qbdsHCWorker;
QueryBuildRange qbr1, qbr2;
Query query;
;
query = new query();
qbdsHCWorker = query.addDataSource(tableNum(HcmWorker));
qbr1= qbdsHCWorker.addRange(fieldNum(HcmWorker,PersonnelNumber));
qbr1.value("0012547");
qbr2= qbdsHCWorker.addRange(fieldNum(HcmWorker,PersonnelNumber));
qbr2.value("002211457");
queryrun = new queryrun(query);
while(queryrun.next())
{
HcmWorker = queryrun.get(tablenum(HcmWorker));
info(strfmt('%1 – %2',HcmWorker.name(),HcmWorker.email()));
}
}
Regards,
static void AlfasithMultipleQueryValue(Args _args)
{
HcmWorker HcmWorker;
QueryRun queryrun;
QueryBuildDataSource qbdsHCWorker;
QueryBuildRange qbr1, qbr2;
Query query;
;
query = new query();
qbdsHCWorker = query.addDataSource(tableNum(HcmWorker));
qbr1= qbdsHCWorker.addRange(fieldNum(HcmWorker,PersonnelNumber));
qbr1.value("0012547");
qbr2.value("002211457");
queryrun = new queryrun(query);
while(queryrun.next())
{
HcmWorker = queryrun.get(tablenum(HcmWorker));
info(strfmt('%1 – %2',HcmWorker.name(),HcmWorker.email()));
}
}
Regards,
Subscribe to:
Posts (Atom)
How to invoke and iterate List as Contract methods in AX 2012/ D365
Hi, Public void performContractIterate(ClassContainsListAsContract _ListCarryClass) { List contractFieldList = new List(Types::Class); ...
-
Hi, AccountingDistribution ( accounting distribution 7452 ) AccountingDistributionEventTmp ( accounting distribution 100001 ) Accountin...
-
Hi, Create a EDT name it Gender then in properties enumType : //select the enum name Use the below code and enjoy. static v...