web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Filtering for Blank Re...
Finance | Project Operations, Human Resources, ...
Unanswered

Filtering for Blank RecID's in Table Browser View

(0) ShareShare
ReportReport
Posted on by GGR_AVC 14
How do you filter for blank RecId's in the Table Browser view?
 
In this screenshot, filters for the ZipCode column work as expected.
 
However, in the ZipCodeRecId field, I did not find a way to filter for blank records
 
I tried expressions like:
 
/ /
!//
 
//
 
Thanks in advance.
I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 297,611 Super User 2025 Season 2 on at
    Filtering for Blank RecID's in Table Browser View
    Hi GGR AVC,
     
    As the (reference) record ID field is of type Integer 64, an empty value has the value 0. You can just set 0 as filter criteria for blank record ID values.
  • Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    Filtering for Blank RecID's in Table Browser View
    Hi,
    The link below contains a question similar to yours and related discussions. You can check the discussions for reference.
    dynamics ax 2012 - Filter Blanks when link is by RefRecId - Stack Overflow
    Best Regards,
    Hana

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 823 User Group Leader

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 673 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 491 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans