Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

How to disable filters by cal.

(0) ShareShare
ReportReport
Posted on by 10

Dear All,

Suppose we apply two filters 

rec.setrange(field1,fieldref);//line 1

rec.setrange(field2.fieldref);//line 2

How to disable filter for line 2 by C/AL.

Note-Please suggest the best solution for the above.

  • Suggested answer
    TeddyH Profile Picture
    TeddyH 12,868 Super User 2024 Season 1 on at
    RE: How to disable filters by cal.

    Don't clear the record. Just do what other suggested. If you don't put any value, it will clear the filter.

    rec.setrange(field2);

  • Ambarish@1993 Profile Picture
    Ambarish@1993 10 on at
    RE: How to disable filters by cal.

    If we clear record then all filters will clear please suggest the another solutions

  • YUN ZHU Profile Picture
    YUN ZHU 74,141 Super User 2024 Season 2 on at
    RE: How to disable filters by cal.

    Hi, try this.

    Set: SETRANGE(Field,From,To)

    Clear: SETRANGE(Field)

    Hope this will help.

    Thanks.

    ZHU

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 6,562 on at
    RE: How to disable filters by cal.

    Just write

    rec.setrange(field2)

    This will remove the filter.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,419 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,492 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans