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

TeddyH 12,868 Super User 2024 Season 1 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 74,141 Super User 2024 Season 2 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... 291,419 Super User 2024 Season 2

#2

Martin Dráb 230,492 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans