bsl-language-server icon indicating copy to clipboard operation
bsl-language-server copied to clipboard

[FP] Query text must be correct (CASE WHEN &QueryParameter)

Open vkostyanetsky opened this issue 2 years ago • 1 comments

Диагностика

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

Скриншоты

firefox_W5pO5ii0x9

vkostyanetsky avatar Feb 23 '23 13:02 vkostyanetsky

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

nixel2007 avatar Feb 27 '23 05:02 nixel2007