web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Business Central forum / AL Range Filter
Business Central forum

AL Range Filter

(0) ShareShare
ReportReport
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:
Other
  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,172 Most Valuable Professional on at

    The filter is equivalent to the following code:

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

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans