'Is there a way to populate an sql dropdown field with active users in another project?
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'
Solution 1:[1]
I figured it out with help from the REDCap consortium forum.
SELECT DISTINCT username FROM redcap_user_rights WHERE project_id='450'
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Vivek-Prakash-US |