Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Custom fields missing from Filtered Views? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    We've added a dozen or so fields to a custom entity, and can see them in the entity view, but the FilteredEntity view is not updated.  Isn't that supposed to be automatically updated when a new field is added/removed?
    -jeff
    Tuesday, October 25, 2011 5:24 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    Sorry guys; the filtered view is ordered, while the extension table and view are not...I just wasn't looking in the correct place.  Thanks!!
    • Edited by jammerjam Thursday, October 27, 2011 2:21 PM
    • Marked as answer by jammerjam Thursday, October 27, 2011 2:21 PM
    Thursday, October 27, 2011 1:56 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Is this CRM 4.0 or 2011?  Do you have the newest rollup's applied?
    Jamie Miley
    Check out my about.me profile!
    http://mileyja.blogspot.com
    Linked-In Profile
    Follow Me on Twitter!
    Tuesday, October 25, 2011 6:01 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    This is CRM 4.0, with the latest rollups applied.  We've published the entity in question.
    -jeff
    Wednesday, October 26, 2011 1:42 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    In SQL can you check if the fields exist in entityExtensionBase table. This table contains custom fields that are defined for an entity.

    HTH

    Sam

    Web: http://www.inogic.com
    Blog: http://inogic.blogspot.com
    Email: news@inogic.com
    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
    Wednesday, October 26, 2011 3:34 PM
  • Question
    Sign in to vote
    1
    Sign in to vote
    Usually publishing isn't required for the attributes to be in the tables, just to show them on the forms.  I agree that you should check in sql whether or not they are in the extensionbase tables.
    Jamie Miley
    Check out my about.me profile!
    http://mileyja.blogspot.com
    Linked-In Profile
    Follow Me on Twitter!
    Wednesday, October 26, 2011 3:39 PM
    Moderator
  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi,

    Make sure that you are using the correct filtered view name, CRM also create another view for the entity with teh same name of entity i.e. account , contact etc

    Try accessing using the entity name i.e.

    SELECT * FROM account

    also make sure that the view has not been manually modified and try publishing CRM customizations and see if changes are relfected into the filtered views or not.

    Jehanzeb Javeed

    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
    Wednesday, October 26, 2011 5:25 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Sorry guys; the filtered view is ordered, while the extension table and view are not...I just wasn't looking in the correct place.  Thanks!!
    • Edited by jammerjam Thursday, October 27, 2011 2:21 PM
    • Marked as answer by jammerjam Thursday, October 27, 2011 2:21 PM
    Thursday, October 27, 2011 1:56 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I tthink somehow my answer was the same that Make sure that you are using the correct filtered view name and hope if you find any of above reply useful then will mark as answer.

    Jehanzeb Javeed

    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
    Thursday, October 27, 2011 2:25 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Yes, feel free to come back and mark additional answers and/or other items as helpful.  I think we all contributed to how you would research this problem. :)

    Thanks!

    Jamie Miley
    Check out my about.me profile!
    http://mileyja.blogspot.com
    Linked-In Profile
    Follow Me on Twitter!
    Thursday, October 27, 2011 3:31 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Guys,

    We are facing a similar issue. After importing soultion in another environment. The following are missing.

    1. Few attributes are missing in FilteredView and Entity view (Not the Views displayed in CRM) of a custom entity. So, getting an SQL error, when we try to retrieve a record with all columns.

    2. For another custom entity, view is not created.

    The required columns are added in ExtensionBase but missing from view.

    These views should be created while importing and publishing the solution nd not sure how they are missed.

    Any resolutions?? I even tried to publish all customizations but got no luck.

    Friday, September 21, 2012 6:21 AM