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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Hide information for some field in Data Entity ?

(1) ShareShare
ReportReport
Posted on by 405
 Hi everyone,
 
About data entity, can we make some fields blank for string or zero for integer based on certain condition ?
Is there any method we can use to put the condition ?
 
The intention is to use this data entity in OData, so when it is called, some information in the field needs to be blank based on certain condition. But we can't use OData query filtering on this case, so wondering how to do it by code.
 
Can I get some advice how to achieve this ?
 
Thanks.
I have the same question (0)
  • Suggested answer
    Martin Dráb Profile Picture
    240,339 Most Valuable Professional on at
  • Teevo Profile Picture
    405 on at
    Hi Martin,
     
    Just to confirm, for the computed column, means we should create one by one for those field that we want to make it blank ? 
    May I ask if there is another way ? since my fields is quite large.
     
    Thanks
  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    26,826 Super User 2026 Season 1 on at
    Hi @Teevo,
     
    as Martin said, the perfect solution is to use computed columns and virtual fields.
    yes, you must create fields one by one.
     
    Best regards,
    Mohamed Amine MAHMOUDI
     
  • Layan Jwei Profile Picture
    8,282 Super User 2026 Season 2 on at
    Hi Teevo,

    is the condition the same for all fields?
  • Suggested answer
    Navneeth Nagrajan Profile Picture
    2,675 Super User 2026 Season 2 on at
    Hi,

    Agree with Martin and Mohammad Amine. You can refer to some same examples -
    1. For computed columns:
    Refer to PurchaseLineDiscountAgreementEntity -  vendorAccountNumberComputedColumnDefinition; itemNumberComputedColumnDefinition
     
    2. For virtual fields:
    Refer to CustomerPaymentJournalLineSettledInvoiceEntity -  invoiceAccount() method.
     
    Hope this helps. Happy to answer questions, if any.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

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

#1
SajeedMullaji Profile Picture

SajeedMullaji 312

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 284 Super User 2026 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 258 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans