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

2

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:

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,203 Super User 2024 Season 1 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 191 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

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans