Month: July 2010

SharePoint 2010: BCS Error – The Field provided as input but cannot be found on the ‘Updater/Creator’ method

Problem:

When you deploy your BCS nodel and try to update/create your entity, the updatercreator form will show you below error.

The Field named ‘myEntityID’ is provided as input but cannot be found on the ‘Updater/Creator’ method signature for Method with Name ‘UpdatemyEntity’ on Entity (External Content Type) with Name ‘myEntity’ in Namespace ‘myBDCModel’.

Solution:

Go to your BCS Model in visual studio.

Make sure you have set creator/updater property = true for all fields that you want to include in update/create operation.

SharePoint 2010: get All checked out documents report with checkedOut column

Problem:


How to achieve a report to retrieve All checked out documents in site collection with Checked out column.
I hope this help you to understand choosing right approach to solve your problem.

Workaround:

Content and Structure Reports
Lets start with what SharePoint gives in-Built option – Content and Structure Reports.
These are really good, ready to use reports. You can customize the filter condition here but no option to customize the report columns.
Checked Out To Not Equal to and you are done for getting all checked out documents.
But if you need to choose the ‘checked out to whom’, then this will not work.
SSRS
Lets look at to SSRS (SQL SERVER Reporting Service) with SharePoint :
You will get full customization for filter condition and report columns also.
But it is limited to one list/library. So this will also not work for our problem.
Content Query Web Part
Content query web part is the right choice for this problem.
Few reference to start with this:
  1. http://www.the-north.com/sharepoint/post/Further-Customise-CQWP-to-Display-Draft-and-Checked-Out-Pages-By-User.aspx
  2. http://www.the-north.com/sharepoint/post/Embed-CAML-Queries-into-the-Content-Query-Webpart—Finding-Draft-Publishing-Content.aspx
  3. http://www.heathersolomon.com/blog/articles/customitemstyle.aspx
  4. http://blogs.msdn.com/b/ecm/archive/2006/10/25/configuring-and-customizing-the-content-query-web-part.aspx
Your Custom webPart
This will give you full control to everything.
To solve our problem you will need to use SPSiteDataQuery.

Hope that helps…

How to retrieve all Master pages for your site

Master Page Gallery is a page library that holds all master pages for your site.

  • Get the Master Page Gallery.
  • Compare all items with the content type Id of “Master Page” content type id
  • 0x0101050038D0E9CC383A4C4B8647D37D80458A8A is content type id for master page.
  • All matching items are the master page.