Owner and team table in SQL

(0) Share

Report

Posted on by Community Member

Hi all,

I'm writing a query in SQL to return all records owned by a certain user. I want to extend this to be able to say return all records owned by anyone in a certain team.

Does anyone know how to do this in SQL?

Thanks very much in advance.

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Hosk on at

Like (0)

Report

I would do the query in advanced find and then look at the fetchxml it may give you some ideas of how the data is linked

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

This did the trick! Thanks. The SQL is:

select

t.Name,

tm.SystemUserId,

su.FullName

from

Team t

left join TeamMembership tm on t.TeamId = tm.TeamId

left join SystemUser su on tm.SystemUserId = su.SystemUserId

Was this reply helpful? Yes No