12-05-2018, 07:30 PM
(This post was last modified: 12-05-2018, 07:31 PM by Moomintroll.)
Is there a way to exclude certain users from the results shown on the view_all_users page?
I've looked over the site using various search terms but nothing seems to address the issue.
I need this for two reasons:
First, although GDPR requires a 'Forget Me' option, if a financial transaction is made there is a separate requirement to keep a record for 10 years (I think), so straight deletion is not an option.
Second, for similar reasons, it would be useful for active members of a society to be able to withhold their names from such a public directory (even one that is restricted to other members).
I'm reasonably sure I can create a column in the users table that could contain a 0, 1 or 2 code, but its the retrieval query in the view_all_users page that I'm stumped by.
I've found these lines:
...but I'm not sure what they're doing.
Cheers in advance!
I've looked over the site using various search terms but nothing seems to address the issue.
I need this for two reasons:
First, although GDPR requires a 'Forget Me' option, if a financial transaction is made there is a separate requirement to keep a record for 10 years (I think), so straight deletion is not an option.
Second, for similar reasons, it would be useful for active members of a society to be able to withhold their names from such a public directory (even one that is restricted to other members).
I'm reasonably sure I can create a column in the users table that could contain a 0, 1 or 2 code, but its the retrieval query in the view_all_users page that I'm stumped by.
I've found these lines:
Code:
$userQ = $db->query("SELECT * FROM users LEFT JOIN profiles ON users.id = user_id ");
// group active, inactive, on naughty step
$users = $userQ->results();
Cheers in advance!