A way to export from Relay or query the db for a list of users that have access to an individual profile?

  • 2
  • Question
  • Updated 4 years ago
A user wants a list of users that have access to their profile.  I don't think the feature is there in Relay.  I'd settle for querying the db as a quick workaround.
Photo of Douglas Tyson

Douglas Tyson

  • 2 Posts
  • 0 Reply Likes

Posted 4 years ago

  • 2
Photo of Douglas Tyson

Douglas Tyson

  • 2 Posts
  • 0 Reply Likes
Anybody know the query to generate a list of users for a single profile?
Photo of Walter Pelowski

Walter Pelowski, Customer Solutions Engineer

  • 226 Posts
  • 19 Reply Likes
You can just go to the Profiles page as an admin and while on a profile click the "Associated Users" step.  If you're asking about a using a SQL query specifically, this will do it for you.

-- Returns the Profile Title, the User's Display Name, User's Username, and User's email address for a given profile search
SELECT profTitle, userDisplayName, userName, userEmail
FROM tblProfile
INNER JOIN tblUserProfile ON usprProfile_profId = profId
INNER JOIN tblUser ON usprUser_userId = userId
WHERE profTitle LIKE '%Name%' -- OR profId = 15
ORDER BY userEmail

Please let me know if you have any questions.

This conversation is no longer open for comments or replies.