0

What I'm hoping to accomplish is something that would populated the SQL dropdown with all active users of another project.

The code below uses the a smart variable that only returns the current users. I was hoping to find a way that brings back a list of all active users.

SELECT DISTINCT [user-name] FROM redcap_data WHERE project_id = '450'
Vivek-Prakash-US
  • 21
  • 2

1 Answers1

0

I figured it out with help from the REDCap consortium forum.

SELECT DISTINCT username FROM redcap_user_rights WHERE project_id='450'
Vivek-Prakash-US
  • 21
  • 2
  • To limit this to active users only, you could join this with the redcap_user_information table on username, and filter for "redcap_user_information. user_suspended_time IS NULL" – Jangari Mar 17 '22 at 00:00