System date is different current zone date in AX

Hi,

static void AlfasithDateCompOfTodayWithServerTime(Args _args)
{
    utcDateTime startdate = DateTimeUtil::getSystemDateTime();
    print startdate;
    print DateTimeUtil::applyTimeZoneOffset(StartDate, DateTimeUtil::getUserPreferredTimeZone());
    pause;
}

Note: Same print statement whereas different value has been printed.

Regards,

QueryDataSourceLink in AX

Hi,

static void AlfasithQueryDataLink(Args _args)
{
    Query                   query;
    QueryBuildDatasource    datasource;
    ;

    query = new Query();

    datasource = query.addDataSource(tableNum(CustInvoiceJour));// Add Parent table

    datasource = datasource.addDataSource(tableNum(CustInvoiceSalesLink)); // Add child table

    datasource.joinMode(JoinMode::InnerJoin);       // Mode of join

    datasource.relations(false);        // Indicate you don't want to use relations DynamicLink

 
    datasource.addLink(fieldNum(CustInvoiceJour, SalesId),
        fieldNum(CustInvoiceSalesLink, SalesId));     // Add link between parent field and child field

    info(query.xml());
}

Regards,

Code to print only particular language label for any language environment in AX

Hi,

Code to print only particular language label for any language environment

info(SysLabel::labelId2String2(literalstr("@SYS87980"),"ar"));

Regards,

Assign null value to date datatype in AX

Hi,

DateLoc = utcDateTimeNull();

or

DateLoc = DateNull();

Regards,

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,