Tuesday, February 6, 2018

Relation Between HcmWorker and HcmPosition.

select PersonnelNumber,Recid from hcmWorker
          where hcmWorker.PersonnelNumber == '000006'
      join Position,worker from hcmPositionWorkerAssignment
          where hcmPositionWorkerAssignment.Worker == hcmWorker.Recid
      join PositionId,RecId from hcmPosition
          where hcmPosition.RecId == hcmPositionWorkerAssignment.Position;

    info(strFmt("%1,%2",hcmWorker.PersonnelNumber,hcmPosition.PositionId));

Get Worker Information

static void GetWorkerInfo(Args _args)
{
HcmWorker Worker;
;
Worker = HcmWorker::findByPersonnelNumber(“000006”);
info(strFmt(“Name : %1”, Worker.name()));
info(strFmt(“Telepon : %1”, Worker.phone()));
info(strFmt(“Email : %1”, Worker.email()));
info(strFmt(“Departemen : %1”, Worker.primaryDepartmentName()));
info(strFmt(“Position : %1”, Worker.primaryPositionId()));
info(strFmt(“Address : %1”, Worker.primaryAddress()));
}

Monday, February 5, 2018

Get particular day based on today date.

Public void getFridayDate()
{
             date  sysdate ,getDate;
             str   dyname   ;
    sysdate = today();
    dyname   = dayName(dayOfWk(sysdate));
    switch (dyname)
    {
        case  "Monday":
                getDate = sysdate+4;
                break;
        case  "Tuesday":
                getDate = sysdate+3;
                break;
        case  "Wednesday":
                getDate = sysdate+2;
                break;
        case  "Thursday":
                getDate = sysdate+1;
                break;
        case  "Friday":
                getDate = sysdate;
                break;
        case  "Saturday":
                getDate = sysdate+6;
                break;
        case  "sunady":
                getDate = sysdate+5;
                break;
    }

TFS Work space configuration

Refer below link:  https://d365byjp.blogspot.com/2018/10/steps-to-configure-tfsvsts-workspace-in.html