select * from dbo.SharedFields where 1=1 and ItemId = 'SublayoutGuid' and FieldId = 'E42081B6-8A95-4A11-89CE-DF70ED502F57'
dbo.ItemTree
/*--- Query 1 ---*/ select ItemPath ,FilePath = Value ,[SharedFields.ID] = f.ID from dbo.SharedFields f inner join dbo.ItemTree t on f.ItemId = t.ID where 1=1 and FieldId = 'E42081B6-8A95-4A11-89CE-DF70ED502F57' and t.ItemPath like '/sitecore/layout/sublayouts/globalpayments%' order by ItemPath /*--- Query 2 ---*/ select * from dbo.SharedFields f where f.Id = '[SharedFields.ID] from first query' /*--- Query 3 ---*/ update dbo.SharedFields set Value = 'new value' where ID = '[SharedFields.ID] from first query'
Inherits
<%@ Control %>
ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.