I have a report (SQL code below) that now does not workbecuase we upgraded form v.316 to 5.1.
Can someone tell me what tblUsers got changed to?
Is there a web service that I can use that will retrieve the desired data (see SQL below).
Thanks
BTD
SELECT DISTINCT
tblusers.name, tblrepositories.name AS Repository, CASE WHEN tblsecurityassignments.securityrights = 1 OR
tblsecurityassignments.securityrights = 3 OR
tblsecurityassignments.securityrights = 7 THEN 'Y' ELSE 'N' END AS ReadRights, CASE WHEN tblsecurityassignments.securityrights = 3 OR
tblsecurityassignments.securityrights = 7 THEN 'Y' ELSE 'N' END AS CheckOutInRights,
CASE WHEN tblsecurityassignments.securityrights = 7 THEN 'Y' ELSE 'N' END AS AddRemoveDeleteRights
FROM tblsecurityassignments INNER JOIN
tblusers ON tblsecurityassignments.userid = tblusers.userid INNER JOIN
tblrepositories ON tblsecurityassignments.repid = tblrepositories.repid
WHERE tblusers.active = 1 AND (tblsecurityassignments.securityrights <> 0)
ORDER BY tblusers.name, Repository
Where did tblUsers go?
Moderator: SourceGear
Re: Where did tblUsers go?
I figured it out. tblUsers still exists. its in sgmaster. Once I figured this out the revised SQL was easy.