I need list of all projects for a user who is logged-in, in jira cloud. I've tried following options. But it gives me detail of all projects but not for a particular user.
We have the similar query for JDC with MSSQL. I have not tried the API but I explored the DB query and found this one useful. This list all the projects which a user have access to. You need to put the user-id of the user in the 2nd last line.
select * from project where id in(
SELECT DISTINCT PID
FROM projectroleactor
WHERE PROJECTROLEID =10000
AND ROLETYPE LIKE 'atlassian-group-role-actor'
AND ROLETYPEPARAMETER IN
(
SELECT DISTINCT parent_name FROM cwd_membership WHERE child_name LIKE '<userid>'
))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.