Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Tuesday, February 13, 2018

Query not value enum in AX 2012

Hi,

    qbrLogStatus    = qbdsDASProjLogLines.addRange(fieldnum(DASProjLogLines,ProjLogStatus));
    qbrLogStatus.value(SysQuery::valueNot(enum2str(DASProjLogStatus::Superseded)));

Thanks,

Saturday, January 13, 2018

Dialog date field and OK CANCEL in job AX 2012

public static void dialogDate()
{
    Dialog      dialog;
    DialogField field;
    ;
    dialog = new Dialog("Submitted Date");
    dialog.addText("Select submitted date:");
    field = dialog.addField(identifierStr(TransDate));

    dialog.run();
    if (dialog.closedOk())
    {
        info(field.value());
    }
}

Get a table ID in SQL - D365

Hi select ID from SysTableIdView where  SysTableIdView .Name = 'CustTable' Regards,