Getting a List of Alternative Forms

I forget why I needed to do this, but I was doing some heavy development around Kentico’s BizForm’s at the time and needed to pull back a list of alternative forms for a given BizForm. It’s not very complex, but it might not be obvious if you’re not familiar with Kentico’s database structure and their use of classes.

Anyway, here is the code:

SELECT ca.FormID, ca.FormDisplayName
FROM CMS_Class cc
JOIN CMS_AlternativeForm ca ON ca.FormClassID = cc.ClassID
WHERE cc.ClassName = 'BizForm.ContactUs'

Let me know if this helped you!