External Content Type missing fields RRS feed

  • Question

  • I've created an external content type using SharePoint Designer 2010. Instead of basing it off a table, I used a view. However, the view contains some columns that use the MAX aggregate function.

    The view returns properly in SQL. When Adding CRUD operations in designer, I can check or uncheck these fields. Additionally, the tab for the External Content Type shows these fields.

    When I look at the List Settings, it only shows the non-aggregated fields. I also don't see these fields in central admin.

    Monday, January 31, 2011 8:44 PM