SQL Server Lists
Last updated
Was this helpful?
Last updated
Was this helpful?
The SQL Server list answer type allows you to create a list based on existing table stored inside a SQL Server database.
Type name
display name of the list.
Layout
defines how the list will be rendered either as a dropdown list or as autocomplete field that will filter the list based on the respondent entry.
Language
you may define a different list for each languages. This is very handy if you use your type in a survey and what to show different items based on the respondent language.
Database connection string
to your SQL Server database.
SQL query
Actual query that will be execute to retrieve the list items. You may also add to generate dynamic queries.
Hide on empty query results
Do not render the list if no results are returned by the query. This property can be used along .