News and Announcements icon

Dynamics 365 CommunityForums Business Central forum AL Range Filter

Business Central forum

Suggested answer

AL Range Filter

(0) Share

Report

Report

Posted on by dickson kimeu

249

I have below T-SQL Code, wondering how i can get the equivalent on this in AL

DECLARE @projectvalue DECIMAL;
SET @projectvalue=20000;
SELECT ISNULL(Amount,0) FROM PROJECTS WHERE RangeFrom<=@projectvalue and RangeTo>=@projectvalue

Categories:

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Stefano Demiliani 37,160 Most Valuable Professional on at

Like (0)

Report

RE: AL Range Filter

The filter is equivalent to the following code:

SETFILTER(RangeFrom,’<=%1’,ProjectValue);

SETFILTER(RangeTo,’>=%1’,ProjectValue);

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,353 Super User 2024 Season 2

#2

Martin Dráb 228,251 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans