SQL Server Lists

The SQL Server list answer type allows you to create a list based on existing table stored inside a SQL Server database.

🔅 SQL Server lists properties

  • 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 multi-language survey and what to show different items based on the respondent language.

  • Database connection string connection string to your SQL Server database.

  • SQL query Actual query that will be execute to retrieve the list items. You may also add parameters 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 parent / child related lists.

The SQL query must return as a first column the value that will be used as the list item value which will be saved along respondent answers and as a second column the text that will be used as the list item text that will be displayed to the respondentSELECT ValueColumn, TextColumn FROM table

Last updated

(c) 2024 Data Illusion Zumbrunn. All rights reserved. Reproduction strictly forbidden.