Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Adding new field to entity, then to view, will not show data

Posted on by 15

So I added a new field to an existing entity, let's call the field SpecialName, entity name = Application. It's just a single line of text field.

Checked the view in sql server, and saw that the field was there, in the view and the base table, Perfect so far.

Now I want to bring back data, so for a test, I manually altered the view in sql server, by changing myBaseTableName.SpecialName to 'test' SpecialName.

Manually ran the view in sql server and sure enough, every single row had the word 'test' in that column. Still perfect.

Added this new field to a new view using CRM. A copy of an associated view that only had 2 fields. So now my new view has 3 fields total, published.

Tried using the new view in CRM, and the 2 existing fields return data as expected, just like the view it was copied from, and the new field name (column) is there, but, no data.

Refreshed, republished, etc., you name it, still no data.

Why?

*This post is locked for comments

  • jfine Profile Picture
    jfine 15 on at
    RE: Adding new field to entity, then to view, will not show data

    "What do you mean with altered the sql?"

    I mean I altered the view, changed the SQL, etc., "by changing myBaseTableName.SpecialName to 'test' SpecialName." If I run the view manually, it works fine. All this is doing is replacing a column in the view with static data, and keeping the column name the same.

    This should work. And I'm looking for the reason why it does not. Sure I can beat on the view using the official way, but this column need to be a special case statement eventually, but in any case, adding static data to the view directly using SQL server should not change the way the CRM view retrieves data since the column name is the same. Makes 0 sense.

  • Suggested answer
    Temmy Wahyu Raharjo Profile Picture
    Temmy Wahyu Raharjo 2,914 on at
    RE: Adding new field to entity, then to view, will not show data

    What do you mean with altered the sql? Don't change directly from SQL. If you want to custom the view, use the official way. If your table got relationship, you can directly refer to the attribute easily.

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

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans