Thursday, 8 October 2020

Sales responsible / sales taker lookup filter

 [ExtensionOf(classStr(HcmWorkerLookup))]

final class EEMCHcmWorkerLookup_Extension

{

    public Query updateQuery(HcmWorkerRecId _workerRecId, Query _queryToUpdate)

    {

        _queryToUpdate =next updateQuery( _workerRecId ,  _queryToUpdate);

        if(includeContractors==true&&CustParameters::find().SalesManWorker==true)

        {

            _queryToUpdate.dataSourceTable(tableNum(HcmWorker)).addRange(fieldNum(HcmWorker,SalesMan)).value(queryValue(1));

            _queryToUpdate.dataSourceName('HcmEmployment').addRange(fieldNum(HcmEmployment, EmploymentType)).value(queryValue(HcmEmploymentType::Employee));

        }

        return _queryToUpdate;

    }

}

No comments:

Post a Comment