SQL Query

TABLE OF CONTENTS

• Introduction to Question Type
• Settings

Introduction to Question Type

You Data is stored in a SQL Database. We got you covered.

Settings

• SQL Server
  • Enter the Name or IP of the SQL Server

• SQL Port
  
  • Enter the Port for the SQL Connection. Standard is 1433

• SQL Database
  • The Name of the SQL Database you want to connect

• Authentication
  • Here you can choose between 3 Modes
    • SQL Authentication: Please enter User and Password
    • Windows Authentication: The logged in User is used to authenticate
    • App Pool Identity: The Service Account from au2mater App Pool is used

When you use Windows Auth here, make sure your environment is configured to accept "Double-Hop" authentication. You can read this for more Details: Kerberos-Double-Hop-Authentifizierung mit Microsoft Edge (Chromium) - Internet Information Services | Microsoft Learn

• SQL Query
  • Enter the SQL Query you want to execute. You can also use Advanced Placeholder in the Query.

See our How to use Advanced Placeholders for more Details

• Show Columns to Send & Show
  
  • Here, you need to select the Columns you want to show and the Columns you want to send to the automation.
  • For advanced Placeholders, the "Column to Send" will be sent to the related Question.

When all SQL related Informations and the Query are coreect, there is a green Checkmark as an indicator next to the SQL Query

• Selection Type
  • When the SQL Query returns multiple Options to select from, configure whether the user can select a single value or multiple values.
    

• Prepop Table Design
  • When you select "Prepop Table" on the "Show Result as" Setting, you can decide the Style of the Table Design.

• Prepop Title
  • When a user executes the SQL query, the custom Title is shown at the front as the Title of the Prepop Table.

• Prepop Description
  • When a user executes the SQL query, the custom Description is shown at the front as a Description of the Prepop Table.

• Visibility

See our How to configure dynamic Forms for more Details