Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Investigate issue of users not being in any organizations #1015

Open
anaelizabethenriquez opened this issue Oct 29, 2024 · 0 comments
Open
Labels
bug Something isn't working data integrity Standard-OA-workflow Related to the standard OA workflow (reminder emails, waivers, OA URLs, but not files from AI)

Comments

@anaelizabethenriquez
Copy link
Collaborator

anaelizabethenriquez commented Oct 29, 2024

The comment below, from #943, outlines a problem with a user not receiving an OA reminder email because they are not in an organization in RMD. In theory, everyone who has an RMD account should (at a minimum) be in the overarching "The Pennsylvania State University" organization, because anyone who can have an RMD account should be a PSU affiliate (or have been one in the past, in which case they'd have an Inactive status).

If needed, we could solve this by changing the database query that leads to OA reminder emails, so that being in an organization is not a prereq for these. Better, IMO, would be to fix the underlying data and whatever process is leading to Active users not being in any organization.

@anaelizabethenriquez There isn't a view for admins to see who is queued up for an email, but I can check from the backend. This user is not listed to receive an email. It appears there's an issue with our database query to determine who needs an email. If the user is not part of an organization, they get filtered out. This is the case for this user — no organization. Adding this user to an organization should fix the problem in the short term, but we may want to open an issue to fix the database query. That's assuming we want oa notification emails going out to users not associated with an organization.

Also, we'll probably want to figure out why this user is not associated with an organization.

Originally posted by @ajkiessl in #943 (comment)

@anaelizabethenriquez anaelizabethenriquez changed the title @anaelizabethenriquez There isn't a view for admins to see who is queued up for an email, but I can check from the backend. This user is not listed to receive an email. It appears there's an issue with our database query to determine who needs an email. If the user is not part of an organization, they get filtered out. This is the case for this user — no organization. Adding this user to an organization should fix the problem in the short term, but we may want to open an issue to fix the database query. That's assuming we want oa notification emails going out to users not associated with an organization. Fix the database query for who receives OA reminder emails, to include users not in organizations Oct 29, 2024
@anaelizabethenriquez anaelizabethenriquez added bug Something isn't working data integrity Standard-OA-workflow Related to the standard OA workflow (reminder emails, waivers, OA URLs, but not files from AI) labels Oct 29, 2024
@anaelizabethenriquez anaelizabethenriquez added this to the Next dev cycle milestone Oct 29, 2024
@anaelizabethenriquez anaelizabethenriquez changed the title Fix the database query for who receives OA reminder emails, to include users not in organizations Investigate issue of users not being in any organizations Oct 29, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working data integrity Standard-OA-workflow Related to the standard OA workflow (reminder emails, waivers, OA URLs, but not files from AI)
Projects
None yet
Development

No branches or pull requests

1 participant