Section Access is not working

[dewan_abdullah]

Hello,

I'm trying to implement section access on an app. Here is my code:

Section Access;

Load * INLINE [

ACCESS, USERID, CATEGORY

USER, DOMAIN\user1, 0102

ADMIN, DOMAIN\administrator, *

];

Section Application;

Sales:

Load

SalesAmount,

CATEGORY,

.

.

.

I checked the OSuser() and the result was DOMAIN and USER ID: user1.

As admin user it's working fine, however, the other user is getting Access Denied message. Any clue?

[Or]

I'd suggest confirming that the value 0102 actually exists in your data under Sales, and that it is recognized as text (if it's recognized as numeric, the leading 0 will be trimmed). You may want to explicitly format it as text(CATEGORY) as CATEGORY to make sure.

[dewan_abdullah]

I did confirm the values and yes it's under Sales. I believe it's text because when viewing the field in a table the leading 0 wasn't trimmed.

[dewan_abdullah]

I tried using text(CATEGORY) as CATEGORY, but it didn't work. Any other suggestion?

[marcus_sommer]

Just comment the section access statement to load the section access table visible within the application. Now create a table-box with these fields and some of the linked fields. Are really all expected data (number of records + values + formatting) there and if you select for the users and/or the category the dataset is appropriate filtered?

- Marcus  

[dewan_abdullah · Accepted solution]

I solved the issue by creating and loading a new table that has only the category field.

Thanks for the help @marcus_sommer  @Or