Look up for Active Workers list with range applied to current legal entity only.

(1) Share

Report

Posted on by RSX

204

Hi,
I have a "worker" custom field in my table, for which I have given relation with HCMworker's personnel number in my table.
And I have added lookupreference method in form datasource field as following:

But the issue is, it is showing all legal entity values for workers.
Can you please suggest how to filter active workers for particular legal entity only?

 public Common lookupReference(FormReferenceControl _formReferenceControl)
            {
                Common ret;
                FormReferenceGroupControl callingReferenceGroupControl;
                FormRun lookupForm;
                Args args;
                HcmWorkerLookup hcmWorkerLookup;

                if (!_formReferenceControl)
                {
                    throw(error(strFmt("@SYS137393", Error::wrongUseOfFunction(funcName()))));
                }

                hcmWorkerLookup = hcmWorkerLookup::newOnlyActiveWorkersWithinCompany();// There are many methods in this, I've tried almost all

                args = new Args(formStr(HcmWorkerLookup));

                args.parmObject(hcmWorkerLookup);
                args.record(My data source table); // I have given my custom datasource table here
                args.caller(_formReferenceControl);

                lookupForm = classfactory.formRunClass(args);
                lookupForm.init();

                if (_formReferenceControl.handle() == classNum(FormReferenceGroupControl))
                {
                    callingReferenceGroupControl = _formReferenceControl;
                    callingReferenceGroupControl.performFormLookup(lookupForm);
                    ret = lookupForm.selectRecordModeSelectedRecord();
                }

                return ret;
            }

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Adis 6,868 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I am not a developer and therefore cant give you an exact answer. I can give you a hint in case you are using F&O, not sure which product you are referring to.

Nevertheless, the following form shows workers\employees, restricted to current legal entity, which are still active. If you check the code of this form and filter, you should have a solution I guess.

Hope it helps, Adis

Was this reply helpful? Yes No
Suggested answer

GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi RSX,

If you want to filter the worker of the particular legal entity, you need to use the HcmEmployment table. This table has a relation with HcmWorker table, and it have field called LegalEntity which will be used to identify the legal entity where the worked is working.

Thanks,

Girish S.

Was this reply helpful? Yes No
Suggested answer

Waed Ayyad 9,214 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Hi,

Since you were adding the relation with Personnel number in Homeworker table, so you should override lookup method not Lookup Reference method, and you can't use hcmWorkerLookup directly.

public void lookup() { QueryBuildRange validFromRange; QueryBuildRange validToRange; utcdatetime now = DateTimeUtil::utcNow(); Query query = new Query(); QueryBuildDataSource queryBuildDataSource; QueryBuildRange queryBuildRange; SysTableLookup sysTableLookup; QueryBuildDataSource queryBuildDataSource1; RecId _LegalEntity; ; //Create an instance of SysTableLookup with the form control passed in sysTableLookup = SysTableLookup::newParameters(tablenum(HcmWorker), this); //Add the fields to be shown in the lookup form sysTableLookup.addLookupfield(fieldnum(HcmWorker, PersonnelNumber), false); sysTableLookup.addLookupMethod(‘Name’); //create the query datasource queryBuildDataSource = query.addDataSource(tablenum(HcmWorker)); queryBuildDataSource1 = queryBuildDataSource.addDataSource(tableNum(HcmEmployment)); queryBuildDataSource1.joinMode(JoinMode::ExistsJoin); queryBuildDataSource1.relations(true); queryBuildDataSource1.addRange(fieldNum(HcmEmployment, LegalEntity)) .value(SysQuery::value(CompanyInfo::findDataArea(curExt()).recId)); validFromRange = queryBuildDataSource1.findRange(fieldNum(HcmEmployment, ValidFrom)); validToRange = queryBuildDataSource1.findRange(fieldNum(HcmEmployment, ValidTo)); query.validTimeStateDateTimeRange(now, now); validFromRange.value(SysQuery::valueUnlimited()); validToRange.value(SysQuery::valueUnlimited()); //add the query to the lookup form sysTableLookup.parmQuery(query); // Perform lookup sysTableLookup.performFormLookup(); }

Thanks,
Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
Waed Ayyad 9,214 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Is your issue resolved? If yes, mark the answers that helped you as verified.

Thanks
Waed Ayyad

Was this reply helpful? Yes No
Suggested answer

CU27061328-0 on at

Like (0)

Report
Copy link

Link copied!

Hi,

This might help you, Employment history has all the information of the legal entity, put in a validation here

Was this reply helpful? Yes No
RSX 204 on at

Like (2)

Report
Copy link

Link copied!
Hi Waed,
Thank you for the suggestion. I'm trying to verify the answer, but the page just keeps on loading and it is not verifying the answer.

I tried the look up updated and got "object reference error", when I debugged, it was showing the error at this line:
validFromRange.value(SysQuery::valueUnlimited());

Hence, I removed those lines and updated the code as following and it worked fine.
public void lookup() { QueryBuildRange validFromRange; QueryBuildRange validToRange; utcdatetime now = DateTimeUtil::utcNow(); Query query = new Query(); QueryBuildDataSource queryBuildDataSource; QueryBuildRange queryBuildRange; SysTableLookup sysTableLookup; QueryBuildDataSource queryBuildDataSource1; RecId _LegalEntity; ; //Create an instance of SysTableLookup with the form control passed in sysTableLookup = SysTableLookup::newParameters(tablenum(HcmWorker), this); //Add the fields to be shown in the lookup form sysTableLookup.addLookupfield(fieldnum(HcmWorker, PersonnelNumber), false); sysTableLookup.addLookupMethod(‘Name’); //create the query datasource queryBuildDataSource = query.addDataSource(tablenum(HcmWorker)); queryBuildDataSource1 = queryBuildDataSource.addDataSource(tableNum(HcmEmployment)); queryBuildDataSource1.joinMode(JoinMode::ExistsJoin); queryBuildDataSource1.relations(true); queryBuildDataSource1.addRange(fieldNum(HcmEmployment, LegalEntity)) .value(SysQuery::value(CompanyInfo::findDataArea(curExt()).recId)); //add the query to the lookup form sysTableLookup.parmQuery(query); // Perform lookup sysTableLookup.performFormLookup(); }

Was this reply helpful? Yes No
Verified answer

Waed Ayyad 9,214 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I'm glad your issue is resolved, try again and see if you can verify my answer, but I have one note why you remove this line?

query.validTimeStateDateTimeRange(now, now); As now your code is correct, but you are returning all workers who have employments regardless of if they have active or expired employments.

Thanks,
Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No