Finance | Project Operations, Human Resources, ...

Disable record level security on a form in X++

(0) Share

Report

Posted on by M Anas Khan

1,424

Is there a way to disable record level security on a single form in X++? I tried doing the following on form datasource executeQuery method but it didn't work:

formDatasource_ds.query().recordLevelSecurity(false);
formDatasource_ds.queryRun().recordLevelSecurity(false);

All responses (7)

Answers (0)

Suggested answer

André Arnaud de Cal... 294,000 Super User 2025 Season 1 on at

Like (0)

Report

RE: Disable record level security on a form in X++

Hi Muhammad,

Are the tables on the datasource also used on other forms and part of the XDS policy?

Another workaround would be creating a new view with the contents of the table you want to show unrestricted. The view is considered as a new table name and in this way you can bypass the XDS policy on the original table.
Sergei Minozhenko 23,091 on at

Like (0)

Report

RE: Disable record level security on a form in X++

Hi Muhammad,

In this case, you need to consider if SaveDataPerCompany parameter. If it's enabled on the table used on the form, you need to activate cross-company selects.

q.allowCrossCompany(true);
M Anas Khan 1,424 on at

Like (0)

Report

RE: Disable record level security on a form in X++

Hi Ludwig,

Yes you are correct. This is kind of a contracting business requirement! There is custom inquiry form which should be global (cross-company), showing records from all companies. At the moment, customer assigns organisations at the user role level to restrict access to limited companies for a user. However for this particular form they want users to see data from all companies.
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Disable record level security on a form in X++

Hello Muhammad,

That is an interesting request. If I read this thread I wonder why you need XDS but not for a specific form? Is this an exception for a specific group of people that can use the form or what is the reasoning behind?

Just curious ... :-)

Ludwig
Blue Wang on at

Like (0)

Report

RE: Disable record level security on a form in X++

Hi Muhammad Anas Khan ,

Record-level security is bypassed in the following situations:

1,Using display and edit methods

2,Using FormListControl, FormTreeControl or TableListControl to show data

3,Using a temporary table as a data source

docs.microsoft.com/.../record-level-security
André Arnaud de Cal... 294,000 Super User 2025 Season 1 on at

Like (0)

Report

RE: Disable record level security on a form in X++

Hi Muhammad,

Like Sergei mentioned, you can try the init method on the datasource or the form.

There is also another command which can be used to enable or disable XDS: XDSServices.setXDSState
Sergei Minozhenko 23,091 on at

Like (0)

Report

RE: Disable record level security on a form in X++

Hi Muhammad,

Have you tried to apply this code in the data source init method?