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:blog comments powered by Disqus