bsl-language-server
bsl-language-server copied to clipboard
[FP] Query text must be correct (CASE WHEN &QueryParameter)
Диагностика
Query text must be correct
Версия
1.11.0
Описание ложного срабатывания диагностики
Проблема воспроизводится, если в тексте запроса есть условие вида CASE WHEN &QueryParameter
Пример кода
SELECT ALLOWED
PRESENTATION(CashAssets.Article) AS CashFlowItemDescription,
SUM(CashAssets.Amount) AS Amount,
CashAssets.Article AS CashFlowItem
FROM
AccumulationRegister.CashAssets AS CashAssets
WHERE
CashAssets.RecordType = &RecordTypeIn
AND CashAssets.Period BETWEEN &StartDate AND &EndDate
AND CASE
WHEN &EntityEnable
THEN CashAssets.Entity IN (&Entity)
ELSE TRUE
END
AND CASE
WHEN &ArticleEnable
THEN CashAssets.Article IN HIERARCHY (&Article)
ELSE TRUE
END
GROUP BY
CashAssets.Article
Скриншоты

@theshadowco можешь глянуть?