Programatically Find Teams and Team Members in SalesLogix

Question: How can I programatically find all of the Teams and Teams members in SalesLogix?
 
Answer: You can try using this SQL statement for an overview of Team members and types:
 
SELECT sysdba.SECCODE.SECCODEID, sysdba.SECCODE.SECCODEDESC AS TEAMNAME, SECCODE_1.SECCODEDESC AS MEMBERNAME,
TYPE = CASE
WHEN SECCODE_1.SECCODETYPE = ‘G’ THEN ‘Team’
WHEN SECCODE_1.SECCODETYPE = ‘U’ THEN ‘User’
WHEN SECCODE_1.SECCODETYPE = ‘D’ THEN ‘Department’
WHEN SECCODE_1.SECCODETYPE = ‘S’ THEN ‘System’
ELSE SECCODE_1.SECCODETYPE
END,
sysdba.SECPROFILE.PROFILEDESCRIPTION
FROM sysdba.SECCODE SECCODE_1 RIGHT OUTER JOIN
sysdba.SECCODEJOINS ON SECCODE_1.SECCODEID = sysdba.SECCODEJOINS.CHILDSECCODEID RIGHT OUTER JOIN
sysdba.SECCODE ON sysdba.SECCODEJOINS.PARENTSECCODEID = sysdba.SECCODE.SECCODEID LEFT OUTER JOIN
sysdba.SECPROFILE ON sysdba.SECCODEJOINS.PROFILEID = sysdba.SECPROFILE.PROFILEID
WHERE (sysdba.SECCODE.SECCODETYPE = ‘G’)
ORDER BY TEAMNAME, TYPE, MEMBERNAME

Ryan Farley also wrote a blog post about determining if a user is a member of a team that may be helpful: /article/determining-if-a-user-is-a-member-of-a-team-in-saleslogix-web/

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!