News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to disable filters...

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

Suggested answer

How to disable filters by cal.

(0) Share

Report

Report

Posted on by Ambarish@1993

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.

All responses Img

All responses (4)

Answers Img

Answers (0)

Suggested answer

Teddy Herryanto (Th... 13,033 Moderator on at

Like (1)

Report

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 10 on at

Like (0)

Report

RE: How to disable filters by cal.

If we clear record then all filters will clear please suggest the another solutions
YUN ZHU 77,981 Super User 2025 Season 1 on at

Like (0)

Report

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 6,562 on at

Like (0)

Report

RE: How to disable filters by cal.

Just write

rec.setrange(field2)

This will remove the filter.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2

Martin Dráb 231,375 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans