boxi create list of value

Document ID : KB000110100
Last Modified Date : 09/08/2018
Show Technical Document Details
Introduction:
In boxi 4.1 , we have a web I report. Need to create a list 
Question:
In boxi 4.1 , we have a web I report. We create a query to return a list, the syntax is wrong
Environment:
Windows 2012
Boxi 4.1sp3
Answer:
Use the BI launchpad togenerate the query to see the syntax. If any modification is required, use the validate to check the sql statement
1
2
3
User-added image
User-added image
User-added image
User-added image