WBS key for a project activity X++ code

WBS key for a project activity X++ code 

Using following SQL Query you can retrieve all activities of one project.

select PURPOSE,ACTIVITYNUMBER from smmActivities
where ACTIVITYNUMBER in (
select ActivityNumber from SmmActivityParentLinkTable
join projTable
            on  projTable.Recid=SmmActivityParentLinkTable.refRecId
   and  SmmActivityParentLinkTable.parentType=7


   where projTable.ProjId='PROJ-0000003')



Using following AX Query you can retrieve all activities of one project.

    SmmActivityParentLinkTable  activityParentLinkTable;
        ProjTable                   projTable;
        ProjectActivityNumber           projectActivityNumber;
        smmActivities               smmActivities;
         
            
            
            
         while   select PURPOSE,ACTIVITYNUMBER from smmActivities
           exists join activityParentLinkTable
            where activityParentLinkTable.ActivityNumber==smmActivities.ActivityNumber
           exists join projTable
            where projTable.Recid==activityParentLinkTable.refRecId
            && activityParentLinkTable.parentType==smmActivityParentType::Project
            && projTable.ProjId=="PROJ-0000003"
        {
         //   projectActivityNumber=new ProjectActivityNumber();

           // projectActivityNumber.ActivityNumber=activityParentLinkTable.ActivityNumber;
           info(strFmt("%1 %2",smmActivities.Purpose, smmActivities.ActivityNumber));
     //       _objContract.addProjectActivity(projectActivityNumber);
        }

Support Faryal's Cusine

Compare Records D365FO & AX 2012

How to compare two records buffer field to field. 

public static container compareRecords(Common _record1, Common _record2)

{

    SysDictTable    dictTable = new SysDictTable(_record1.TableId);

    SysDictField    dictField;

    FieldId         fieldId, extFieldId;

    container       ret;

    int             i, j;

    ;

    if (_record1.TableId != _record2.TableId)

        return conNull();

    for (i=1; i<=dictTable.fieldCnt(); ++i)

    {

        fieldId = dictTable.fieldCnt2Id(i);

        dictField = new SysDictField(_record1.tableId, fieldId);

        if (!dictField.isSystem())

        {

            for (j=1; j<= dictField.arraySize(); ++j)

            {

                extFieldId = fieldId2Ext(fieldId, j);

                if (_record1.(extFieldId) != _record2.(extFieldId))

                {

                    ret += [extFieldId, _record1.(extFieldId), _record2.(extFieldId)];

                }

            }

        }

    }

    return ret;

}

For Demo purpose you can use below code in job/runnable class.

static void demoCompareRecords(Args _args)
{
    VendTable vendTable_1 = VendTable::find('ABC'); 
    VendTable vendTable_2 = VendTable::find('XYZ'); 
 
    container   con;
    int         i;
    ;
 
    con = MyClass::compareRecords(vendTable_1 , vendTable_2 );
 
    for (i=1; i<=conLen(con); i+=3)
    {
        info(strFmt("%1, %2 ,%3"
                   ,fieldId2Name(tableNum(VendTable), conPeek(con, i))
                   ,conPeek(con, i+1)
                   ,conPeek(con, i+2)
                   )
             );
    }
}

Support Faryal's Cusine