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!

Need hosting? I use and recommend a Digital Ocean SSD VPS server! Check out my referral link below:

Get an awesome virtual SSD server cheap!
blog comments powered by Disqus