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!