Skip to main content

Notifications

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

Use DataItemTableView with TableExtension Field Columns?

(0) ShareShare
ReportReport
Posted on by 35

Hello everyone, 

I am trying to use 'DataItemTableView' on a dataitem and filter where a field added to that table by a tableextension is >0. In short, can you filter by a non-native table field -- or put differently -- a field added to that dataitem table by a tableextension?

Thanks!

Chris 

  • Suggested answer
    RE: Use DataItemTableView with TableExtension Field Columns?

    Hi Chris,

    Yes you can. If you have added a new field to a standard table using TableExtension, it will be able to use in 'DataItemTableView'.

    pastedimage1669091872613v1.png

    However I agree with Zhu as it cannot be used in ReportExtensions and to overcome from it you can Copy and create a new report with same code lines and continue as it will then allow you to Customize the 'DataItemTableView' as it is a Customized Report copied from a standard report.

    Thanks

    Please do verify if this helps you.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,036 Super User 2024 Season 2 on at
    RE: Use DataItemTableView with TableExtension Field Columns?

    Hi, Of course you can.

    For example,

    pastedimage1669077480243v2.png

    Note: Since the DataItemTableView property cannot be customized, this cannot be done in ReportExtension.

    pastedimage1669077295712v1.png

    Hope this helps.

    Thanks.

    ZHU

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

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans