Fetch number of children associated with a worker

Little code snippet as provided below can help you get the number of children associated with a particular worker.

    public static void getEmployeeTotalChildren(Args _args)

    {       

        DirPartyRelationship            partyRelationship;

        DirRelationshipTypeTable        relationshipTypeTable;

        DirPerson                                                                               dirPerson;

        HcmWorker                                                                                          worker;

        DirPartyTable                                                                        partyTable;

      

        ///get the worker by personnel number

       worker         = HcmWorker::findByPersonnelNumber('NNNNN');

        select           firstonly dirPerson

        where          dirPerson.RecId == worker.Person

            join           partyTable

                where partyTable.PartyNumber == dirPerson.PartyNumber;

        select count(RecId) from partyRelationship

            join  RelationshipTypeId, SystemType from relationshipTypeTable

            where partyRelationship.ParentParty == partyTable.RecId

            &&    relationshipTypeTable.RelationshipTypeId == partyRelationship.RelationshipTypeId

            &&    relationshipTypeTable.SystemType ==  DirSystemRelationshipType::Child;

        info(strFmt("Total Children of Worker %1, are %2", worker.name(), partyRelationship.RecId));

    }