SQLBot Version
SQLBot V1.7.0
Run Mode
Is it running in a Docker container
Describe the bug
查询结果只能显示最多三列的数值,超过三列的数值显示不出来
Screenshots

Additional context
查询的SQL如下:
SELECT TOP 1000 CAST([t].[Date] AS DATE) AS [date],
[t].[time] AS [hour],
[t].[InOutDoor] AS [entry_exit],
SUM([t].[InNum]) AS [total_in_count],
CASE
WHEN CAST([t].[Date] AS DATE) = DATEADD(DAY, -1, CAST('2026-03-27' AS DATE)) THEN '昨天'
WHEN CAST([t].[Date] AS DATE) = DATEADD(YEAR, -1, DATEADD(DAY, -1, CAST('2026-03-27' AS DATE))) THEN '去年同期'
ELSE '其他'
END AS [period_type]
FROM [dbo].[v_traffic] [t]
WHERE [t].[Mallcode] = 'SMJJ'
AND (CAST([t].[Date] AS DATE) = DATEADD(DAY, -1, CAST('2026-03-27' AS DATE))
OR CAST([t].[Date] AS DATE) = DATEADD(YEAR, -1, DATEADD(DAY, -1, CAST('2026-03-27' AS DATE))))
AND [t].[InOutDoor] LIKE '%入%'
GROUP BY CAST([t].[Date] AS DATE),
[t].[time],
[t].[InOutDoor]
ORDER BY [period_type],
[entry_exit],
[hour]
SQLBot Version
SQLBot V1.7.0
Run Mode
Is it running in a Docker container
Describe the bug
查询结果只能显示最多三列的数值,超过三列的数值显示不出来
Screenshots
Additional context
查询的SQL如下:
SELECT TOP 1000 CAST([t].[Date] AS DATE) AS [date],
[t].[time] AS [hour],
[t].[InOutDoor] AS [entry_exit],
SUM([t].[InNum]) AS [total_in_count],
CASE
WHEN CAST([t].[Date] AS DATE) = DATEADD(DAY, -1, CAST('2026-03-27' AS DATE)) THEN '昨天'
WHEN CAST([t].[Date] AS DATE) = DATEADD(YEAR, -1, DATEADD(DAY, -1, CAST('2026-03-27' AS DATE))) THEN '去年同期'
ELSE '其他'
END AS [period_type]
FROM [dbo].[v_traffic] [t]
WHERE [t].[Mallcode] = 'SMJJ'
AND (CAST([t].[Date] AS DATE) = DATEADD(DAY, -1, CAST('2026-03-27' AS DATE))
OR CAST([t].[Date] AS DATE) = DATEADD(YEAR, -1, DATEADD(DAY, -1, CAST('2026-03-27' AS DATE))))
AND [t].[InOutDoor] LIKE '%入%'
GROUP BY CAST([t].[Date] AS DATE),
[t].[time],
[t].[InOutDoor]
ORDER BY [period_type],
[entry_exit],
[hour]