Finance | Project Operations, Human Resources, ...

Legal entity range in AOT View

(1) Share

Report

Posted on by Waed Ayyad

9,135 Super User 2026 Season 1

Hi All,

I want to return data from worker only from current legal entity, can I add range on dataArea field on view?

I have the same question (0)

All responses (10)

Answers (0)

Sort by

Suggested answer

Martin Dráb 239,511 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

HcmWorker doesn't have any DataAreaId to filter by. What you can do is joining it with HcmEmployment table, which is also shared, but it has LegalEntity field that you can utilize. You could also use HcmWorkeerLegalEntity view.

A view doesn't have a "current" legal entity - that depends on user session, not on the view definition in SQL database.

Either add a range at runtime, or create an AOT query and use (CompanyInfoHelper::currentLegalEntity()) as the filter value (don't forget the parenthesis).

Was this reply helpful? Yes No
André Arnaud de Cal... 304,837 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi Waed,

You didn't provide that much of detail, but I assume you want to have a list of workers belonging to a specific legal entity. This is stored in the Employment table (HCMEmployment). You can join this table with the worker details.

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

Like (0)

Report
Copy link

Link copied!

Hi Martin,

Can I add range on data area field on Company info data source by joining it with HcmEmployment ?

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

Like (0)

Report
Copy link

Link copied!

Hi Andre,

Yes I want to get all worker in the current company, but I tried to add range in the below image, but no data is returned.

Was this reply helpful? Yes No
Suggested answer

GirishS 27,843 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi Wayed,

There is already standard query available for this with current company filter.

HcmWorkerListPage_Employees. Refer to the below screenshot.

Thanks,

Girish S.

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

Like (0)

Report
Copy link

Link copied!

Hi GirishS,

IS it not possible to add range on AOT View.

Also If I need to create data entity to return current company worker how can I achieve this?

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

Like (0)

Report
Copy link

Link copied!

Hi Martin,

"
A view doesn't have a "current" legal entity - that depends on user session, not on the view definition in SQL database.

Either add a range at runtime, or create an AOT query and use (CompanyInfoHelper::currentLegalEntity()) as the filter value (don't forget the parenthesis)."

you mean I can't use range on View? How can I achieve it at runtime?

Was this reply helpful? Yes No
GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

You can add a range in the view also. There is no restriction.

Also, there is a range node available in the Data entity also. You can try adding the range there also.

Thanks,

Girish S.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 239,511 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Waed, you surely add ranges to view, but if have three companies and you filter the view by single company, it'll never return any data for the remaining two companies. I doubt it's what you want.

If you used currentLegalEntity() as a range in a view definition, the method would run at DB synchronization and the view would contain hard-coded filter for this single legal entity ID.

But if you use currentLegalEntity() as a range in a query, it'll be interpreted when running the query and you'll get a filter based on which company you're logged in.

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

Like (0)

Report
Copy link

Link copied!

Hi Martin,

I tried currentLegalEntity on View to be as a range for the legal entity, but it returns Dat legal entity. I need when I open the Company A to get data from Company A, if I change to Company B to get data from company B.

Regards,

Waad

Was this reply helpful? Yes No