Finance | Project Operations, Human Resources, ...

Bypass the limited access to legal entities in "Assign Organizations" for user roles

(0) Share

Report

Posted on by Waed Ayyad

7,245 Super User 2025 Season 1

As you know in SysAdmin form, I can assign organization for a user role. This will cause the user to only see data for the organization he/she has access to.

Is there a way I can bypass this restriction?

Here's my scenario:

I created a form with three grids:

left grid, should show all companies (even if it was specified in /Assign organization/ that the user can't see specific companies), how can I do that? because currently it's showing only the companies that the user has access to and not all of them.

middle grid, should show the sites for the company I selected in the first grid

third grid, should show the addresses for the site selected in the second grid.

Here is the form datasources:

LogisticsLocation:/Link Type/= Delayed, / Cross Company Auto Query/ = No

LogisticsPostalAddress : OuterJoin with LogisticsLocation, / Cross Company Auto Query/ = No

CompanyInfo: /Link Type/= Delayed, / Cross Company Auto Query/ = Yes

InventSite: /Link Type/= Delayed, / Cross Company Auto Query/ = Yes

Here is the code for the datasources:

[DataSource]
class CompanyInfo
{
public void init()
{
super();
this.query().dataSourceTable(this.table()).clearDynalinks();
}

public int active()
{
int ret;

Query query = InventSite_ds.query();
query.clearCompanyRange();
query.addCompanyRange(CompanyInfo.DataArea);
InventSite_ds.executeQuery();
element.executeQueryLogisticsLocation(tableNum(InventSite));
ret = super();

return ret;
}

/// <summary>
/// Execute query of CompanyInfo DataSource
/// </summary>
public void executeQuery()
{
Query query = new Query();
QueryBuildDataSource qbdCompany;

query.allowCrossCompany(true);
qbdCompany = query.addDataSource(tableNum(CompanyInfo));
element.addRangeToCompanies(qbdCompany);
this.query(query);

super();

if(buyingLegalEntity)
{
CompanyInfo_ds.positionToRecord(CompanyInfo::findRecId(buyingLegalEntity));
}

}

}

[DataSource]
class InventSite
{
public void init()
{
super();
this.query().dataSourceTable(this.table()).clearDynalinks();
}

public int active()
{
int ret;

element.executeQueryLogisticsLocation(tableNum(InventSite));
ret = super();

return ret;
}

}

All responses (3)

Answers (0)

Waed Ayyad 7,245 Super User 2025 Season 1 on at

Like (0)

Report

Bypass the limited access to legal entities in "Assign Organizations" for user roles

Hi Andre,

" You can try to remove the statement with addCompanyRange as this is setting additional security."==== But I want to get the data from Invent site based on the active company

Query query = InventSite_ds.query();
query.clearCompanyRange();
query.addCompanyRange(CompanyInfo.DataArea);

"the security framework will apply security filters per legal entity. " === Here you mean the restriction on security level will only return data from unrestricted legal entities?
Suggested answer

André Arnaud de Cal... 292,074 Super User 2025 Season 1 on at

Like (1)

Report

Bypass the limited access to legal entities in "Assign Organizations" for user roles

Hi Waed,

The contents of the CompanyInfo table are not restricted based on the organization assignment, unless you have a security policy (XDS) implemented on this table. You can try to remove the statement with addCompanyRange as this is setting additional security.

Otherwise, the current behavior can be caused by the table InventSite as this table has a field to keep data separate per legal entity. Even though you have set this table to run cross-company, the security framework will apply security filters per legal entity.

In case you have an XDS policy on the CompanyInfo table, you can bypass that by creating a view with the CompanyInfo table as data source.
GirishS 27,821 Super User 2024 Season 1 on at

Like (1)

Report

Bypass the limited access to legal entities in "Assign Organizations" for user roles

Hi Waed,

For the first grid I would suggest you to create a table for that and insert all the companies details to that table - Use that table as a DataSource inside the form.

Thanks,

Girish S.

Bypass the limited access to legal entities in "Assign Organizations" for user roles

Helpful resources

News and Announcements

Quick Links

Announcing Our 2025 Season 1 Super Users!

Vahid Ghafarpour – Community Spotlight

Congratulations to the January Top 10 leaders!

Leaderboard

Featured topics

Product updates

Bypass the limited access to legal entities in "Assign Organizations" for user roles

Helpful resources

News and Announcements

Quick Links

Announcing Our 2025 Season 1 Super Users!

Vahid Ghafarpour – Community Spotlight

Congratulations to the January Top 10 leaders!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates