Follow

Configure SQL Question Type

To configure SQL Query as a Question Type, configure your Service and choose "SQLQuery" as Type

 

SQL Server (1)

  • Type in the Name of your SQL Server

SQL Database (2)

  • Enter the Name of your Database

SQL Query (3)

  • enter your SQL Query
  • It is not possible to enter "select *"
  • You have to enter a single column name to return

Authentication (4)

  • Is SQL Windows Authentication, the logged on Windows User is used
  • SQL Authentication, Ente Usernamen and Password tor SQL Authentication

Make sure the User has access to the SQL Server and to the Database

The SQL Query will run each time a User is selecting this related Service

The Result will look like this

Note: SQL Question Type is available since Version 2.5

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk