Skip to content

Instantly share code, notes, and snippets.

@spy86

spy86/sitecore_lock.sql

Created December 18, 2018 19:11
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save spy86/004b4cf54a848e4aadbe1ef05f373d40 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save spy86/004b4cf54a848e4aadbe1ef05f373d40 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sitecore_lock.sql
SELECT i.ID AS ItemID, i.Name AS ItemName, FieldItem.Name AS FieldName, f.Value AS FieldValue,
TemplateItem.ID AS TemplateID, TemplateItem.Name AS TemplateName
FROM dbo.Items i
INNER JOIN dbo.Fields f ON i.ID = f.ItemId
INNER JOIN dbo.Items FieldItem ON FieldItem.ID = f.FieldId
INNER JOIN dbo.Items TemplateItem ON TemplateItem.ID = i.TemplateID
WHERE FieldItem.Name = '__Lock'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment