Skip to main content

Notifications

Business Central forum
Suggested answer

Use DataItemTableView with TableExtension Field Columns?

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 

Categories:
  • 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 69,510 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

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans