To configure SQL Query as a Question Type, configure your Service and choose “SQLQuery” as Type
SQL Server (1)
SQL Database (2)
SQL Query (3)
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
Make sure, the Query you are entering is, as simple, as possible. Do not use heavy commands like ORDER BY, DISTINCT or something similar.
Instead, build a View, where all your Information is ready, and only use simple Select in our Portal
Reason: Heavy Queries can also slow down our Portal, and that is something, no one wants.
Note: SQL Question Type is available since Version 2.5