Section Access Incomplete Visualization

[derrydavis]

Using Section Access to OMIT a column in an app but the work around to hide the data item when it's not available is not working. Here's what we've tried so far:

1. Use FieldNumber to check for the column and then hide / show the column based on it.
2. Use a variable of 'count(FIELD)' to hide / show the column. 
3. And I think we used FieldCount in a variable to hide / show the data item

Each of the option always returns a '1' for the FIELD, whether it's in the SA script or not. When it's set under the OMIT column it doesn't show up in the app. But anywhere it's used it shows Incomplete Visualization. Using the hide/show component does work because any option always returns '1' as if the column is there. Any idea why it always returns a '1'?

Example:

Section Access -

ACCESS, USERID, GROUP, SA_ACCOUNT, OMIT
ADMIN, INTERNAL\SA_SCHEDULER, *,
ADMIN, INTERNAL\SA_REPOSITORY, *,
USER,*, ROLES.USERS, *,ARCHIVEDROLE

Load script that always returns 1.

Let vIFieldNumber = FieldNumber('ARCHIVEDROLE', 'Table1');

Variable that always returns 1

=Count('ARCHIVEDROLE')

[derrydavis]

A thought occurred to me, does this app need to be owned by SA for it to work properly? And in a stream other than my own work stream? I'll be testing that theory out soon.

[derrydavis]

Publishing to a stream and changing owners did not fix the issue.

[derrydavis · Accepted solution]

User error, did not have the right code in place. Hide / Show based on the count of the field being omitted works.