Programmatically Identify Field Level Security Profile in SalesLogix

Question: I would like to be able to programmatically identify the field level
security profile that is applied to the current record in SalesLogix.  Is it possible to do this?

Answer: This should help you:

SELECT A.*, S.PROFILEDESCRIPTION
FROM ACCOUNT A
INNER JOIN SECRIGHTS SR
ON A.SECCODEID = SR.SECCODEID
AND SR.ACCESSID = ‘UDEMOA00000I’
INNER JOIN SECPROFILE S
ON SR.PROFILEID = S.PROFILEID

 

 

 

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!