web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... setting filter using C...

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

Answered

setting filter using C/al in report request page

(0) Share

Report

Report

Posted on by MedInfoTech

1,392

Hello,

Please how to put a value like "xx001" in No. Field filter when i Check the Lab6 Boolean in dynamics nav report using C/AL.

I know that i should put some Code in Lab6- on validate trigger but i dont know the statement

Thank's in advance

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Bilal Haider 442 on at

Like (1)

Report
Copy link

Link copied!

Hi,

It is very simple.

Suppose the DataItem that you hide in image has name Customer.

Use the following code in OnValidate trigger of Lab on Request page:

IF Lab = TRUE THEN

Customer.SETFILTER("No.",'10000') //to put filter

ELSE

Customer.SETFILTER("No.",''); //to clear filter

RequestOptionsPage.UPDATE; //to update request page

It should work as it is tested code.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 1,926 Super User 2026 Season 1

#2

YUN ZHU 1,158 Super User 2026 Season 1

#3

Khushbu Rajvi. 533 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans