Jump to content

Record Level Access - <No Access> records appear!


This topic is 2877 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi,

 

I hope someone can help me. I've create a script (posted below) which uses the Get(AccountName) function to look up the users account name in a table and return the department they sit in (as a FK). I then use this to perform a find on my layout and return only the records that the person has access to view.

 

This works, however, instead of just returning the 5 or so records I want (as it does if I were to perform a find on the actual layout manually) it returns all the records but has <No Access> populated for all the other records.

 

Can anyone tell me if I've missed out a step in the script or something else so I can figure out why it's not working.

 

Many Thanks in advance.

 

 

post-112258-0-60323500-1421330288_thumb.

Link to comment
Share on other sites

have you stepped through your script with Script Debugger to see if the IF actually works?

 

Also, in your search for $dept, use "==" & $dept otherwise you may get more results than you expect (if you look for dept 1, you would also get dept 11, 110,...) unless you do the "exact" search with "=="

Link to comment
Share on other sites

The Show All records command does not respect the record-level security in terms of the found set.

Instead of Show All, do a Find where the ID is >0 (or *).

This will use the security settings to return only records accessible to the user.

Link to comment
Share on other sites

This topic is 2877 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.