Getting dropdown field values from sql query under content types

Hii,

I want to populate a dropdown field in a content type using data from a SQL query.

For example, I need to fetch data like FormName and FormDisplayName from the CMS_Form table and show it in a dropdown, filtered by the current site.

In Kentico 13, this was possible queries, but in Xperience by Kentico (XbyK), direct SQL in fields don’t seem to be supported.

What is the recommended way to achieve this in XbyK?

Should I use a custom form component, or is there any built-in approach for dynamic dropdown values?

Thanks

Environment

  • Xperience by Kentico version: [30.11.2]

  • .NET version: [8|9]

  • Execution environment: [SaaS|Private cloud (Azure/AWS/Virtual machine)]

  • Link to relevant Xperience by Kentico documentation

Answers

I would recommend using the DropDownComponent's DataProviderType property and implement custom dropdown provider which can be used to fill the drop down options dynamically. For more details please see this guide.

To response this discussion, you have to login first.