No Need to read Section ACCESS.
Indeed, do create a boolean column "PAYMENTSALLOWED" (upper case in the section access)
This column don't required to be linked to the datamodel.
Add in Section Application,
LOAD NTAME ,
Since Section access is applied at opening you get for each user one island table with a single boolean value you can use in the condition Show
i also require exactly the mentioned case. I now got the table with my NTNAME's listed also in the section access in my application.
The table has about 50 NTNAME's. How do i manage to compare the NTNAME's with OSUSER function and the boolean flag to decide if i hide or show an object for the user?
No idea how to search the NTNAME attribute for the corresponding OSUSER.
In your load script do it like this:
LOAD if(upper(OSUser())=NTNAME,SEENAMES) as SEENAMES
where not IsNull(if(upper(OSUser())=NTNAME,SEENAMES));
SA is the name I gave to my section access table,
I'm using upper because my access list has the NT all in capitals, seenames has TRUE/FALSE value. Doing this you'll get 1 unique value, then you can use it as it was a variable. For example in conditional show: SEENAMES = 'TRUE'
thanks for the reply. But your example only checks OSUSER() on script load runtime isn't it?
So if i use the example the load statement just extracts my NTNAME but i need to have all users with true flag extracted and then they have to be checked in the show condition online as this is a server application.