The issue with the way Joomla sets up its user
Groups by default is that super users etc are descendants of the public group, so if we set a prefilter to 'apply to 'public' then the prefilter will apply to everyone, and not just guest users.
To get round this problem you should
- Create a new user group called 'front end'
- Create a new viewing access level called 'front end' which is applicable only users in the 'front end' group
- Set the "Users global config" -> "component" -> "Guest user group" option to "Front end"
Then I edited the list and set the prefilter 'Apply to' to 'Front end'
You may also want to edit your user
Groups so that they are parented to the public user group and not chained (e.g. public->author->admin->superadmin)
An other possiblity to give admins access to all records:
add a second prefilter (OR) with a condition always true (e.g. where id >= 0) and apply to (super)admin