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

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Ariba Mehdi 160 on at

Like (0)

Report

Filter/find empty values in item list - how?

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!
Suggested answer

Govinda Kumar 2,211 Moderator on at

Like (0)

Report

Filter/find empty values in item list - how?

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

Brett F 344 on at

Like (0)

Report

Filter/find empty values in item list - how?

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

Helpful resources

News and Announcements

Check out the New Agent Creator Community

Quick Links

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

#1

Sohail Ahmed 1,452

#2

YUN ZHU 1,313 Super User 2025 Season 1

#3

Gerardo Rentería Ga... 1,083 Most Valuable Professional

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans