استعمال میں مواد کی قسم کی سائٹ -- خرابی کرتے ہوئے مواد کی قسم حذف کر رہا ہے

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

• KKelaiya

  مئی 31, 2010 پر 5:17 PM

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

• Udayakumar Ethirajulu

  جون 2, 2010 پر 6:56 ہوں

  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 :

  سسٹم کو استعمال کرتے ہوئے;
  System.Collections.Generic کا استعمال کرتے ہوئے;
  Microsoft.SharePoint کا استعمال کرتے ہوئے;

  namespace Test
  {
  class ConsoleApp
  {
  static void Main(سٹرنگ[] args)
  {
  کا استعمال کرتے ہوئے (SPSite siteCollection = new SPSite(“HTTP://لوکل ہوسٹ”))
  {
  کا استعمال کرتے ہوئے (SPWeb webSite = siteCollection.OpenWeb())
  {
  // Get the obsolete content type.
  SPContentType obsolete = webSite.ContentTypes[“Test”];

  اگر (obsolete != null) // We have a content type.
  {
  IList usages = SPContentTypeUsage.GetUsages(obsolete);
  اگر (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);
  }
  ورنہ // The content type is not in use.
  {
  // Delete it.
  Console.WriteLine(“Deleting content type {0}…”, obsolete.Name);
  webSite.ContentTypes.Delete(obsolete.Id);
  }
  }
  ورنہ // 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′)