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/find empty valu...

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

Unanswered

Filter/find empty values in item list - how?

(1) Share

Report

Report

Posted on by CU16070803-0

I'm trying to find all items that has a specific field without any data in it.

For instance, I want to find all items that has no value in the GTIN-field.

How can I do this without having to extracting all the items into an excel list and filter it there?

Thank you!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Brett F 450 on at

Like (0)

Report

A filter of 2 single quotes will filter to only items where the field is blank, like this:

2 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Govinda Kumar 2,304 Moderator on at

Like (0)

Report

For string field, you can filter the empty string like we do in AL code with single quotation marks ('')...

Was this reply helpful? Yes No
Suggested answer

Ariba Mehdi 166 on at

Like (0)

Report

If you want to find it through development in AL, try this code to filter out the records where the field is empty. Here the [fieldname] can be replaced by the actual fieldname.

var
recordItem: Record Item;

begin

recordItem.setfilter([fieldname], '=%1', ' ');

recordItem.findset();

end;

Hope this helps!

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 3,229

#2

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans