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);

I have the same question (0)

All responses (7)

Answers (0)

Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Muhammad,

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

Was this reply helpful? Yes No
André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
M Anas Khan 1,424 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report

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);

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No