News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV forum How to disable filters...

Microsoft Dynamics NAV forum

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.

Categories:

Development / Customization / SDK

All responses Img

All responses (4)

Answers Img

Answers (0)

Suggested answer

TeddyH 12,861 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 69,933 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... 290,554 Super User 2024 Season 2

#2

Martin Dráb 228,588 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans