Istifadə Site İçerik Tipi - Hata məzmun Tipi silmek

2 comments to Site Content Type in Use – Error while Deleting Content Type

• KKelaiya

  May 31, 2010 at 5:17 pm

  How to find in which libraries this content type is used?

• Udayakumar Ethirajulu

  Iyun 2, 2010 at 6:56 tarixinə

  Refer to the discussion in my forum :
  http://www.mstechblogs.com/Forums/viewtopic.php?f=8&p=12&sid=cee7f065bed1fc88d9759c66b373d4dd#p12

  You can use Object Model to find :

  sistemi istifadə edərək;
  System.Collections.Generic istifadə;
  Microsoft.SharePoint istifadə;

  namespace Test
  {
  class ConsoleApp
  {
  static void Main(sim[] args)
  {
  istifadə (SPSite siteCollection = new SPSite(“http://localhost”))
  {
  istifadə (SPWeb webSite = siteCollection.OpenWeb())
  {
  // Get the obsolete content type.
  SPContentType obsolete = webSite.ContentTypes[“Test”];

  əgər (obsolete != Null) // We have a content type.
  {
  IList usages = SPContentTypeUsage.GetUsages(obsolete);
  əgər (usages.Count > 0) // It is in use.
  {
  Console.WriteLine(“The content type is in use in the following locations:”);
  foreach (SPContentTypeUsage usage in usages)
  Console.WriteLine(usage.Url);
  }
  başqa // The content type is not in use.
  {
  // Delete it.
  Console.WriteLine(“Deleting content type {0}…”, obsolete.Name);
  webSite.ContentTypes.Delete(obsolete.Id);
  }
  }
  başqa // No content type found.
  {
  Console.WriteLine(“The content type does not exist in this site collection.”);
  }
  }
  }
  Console.Write(“\nPress ENTER to continue…”);
  Console.ReadLine();
  }
  }
  }

  Other Option would be using SQL query (beware its bit risky)

  SELECT *
  FROM AllUserData
  WHERE (tp_DirName LIKE ‘%’)
  AND ((tp_ContentType = ‘Document’) and tp_ListId=’C8723B19-0DAB-4F19-B195-3399D5375752′)

  You will find items referenced by content type. Delete this referenced items using query below.

  DELETE
  FROM AllUserData
  WHERE (tp_DirName LIKE ‘%’)
  AND ((tp_ContentType = ‘Document’) and tp_ListId=’C8723B19-0DAB-4F19-B195-3399D5375752′)