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... Filter view on a Page ...

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

Suggested answer

Filter view on a Page with empty filters

(2) Share

Report

Report

Posted on by Magicrevette

215

Hello,

I would like some pages in BC opens with some filters already shown, but with no value. Like this :

So users don't have to search for the fields they filter with the most everytime they open a page.

Is it possible ?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 89,902 Super User 2025 Season 2 on at

Like (0)

Report

Filter view on a Page with empty filters

Hi, I think this has something to do with the initialization of field types.
For example, decimal or integer: 0

Date: 0D

Time: 0T

DateTime:0DT

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No
Magicrevette 215 on at

Like (1)

Report

Filter view on a Page with empty filters

Thanks for your answers.

The setrange(field, '') solution works well, but only for Text and Code datatype fields. It doesn't work for other datatypes.

Does anybody has an idea for these kind of fields ?

Was this reply helpful? Yes No
Jun Wang 8,152 Super User 2025 Season 2 on at

Like (0)

Report

Filter view on a Page with empty filters

just add the filters you need.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 89,902 Super User 2025 Season 2 on at

Like (0)

Report

Filter view on a Page with empty filters

Hi, this can be done through customization, but it cannot be empty. It must have at least a certain value, such as *

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Brett F 426 on at

Like (1)

Report

Filter view on a Page with empty filters

You want to type in ''

'' is empty text. Note: this is 2 single quotes, not one double quote.

https://learn.microsoft.com/en-us/dynamics365/business-central/ui-enter-criteria-filters

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Responsible AI policies for the Community

Quick Links

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

#1

Sohail Ahmed 2,869 Super User 2025 Season 2

#2

Sumit Singh 2,484

#3

Jeffrey Bulanadi 2,242

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans