I need to find all templates that use a defined field type.
What is the best way to do it ?
As field types are not linked with item's ID you cannot use Link Database for that.
PowerShell
You could iterate through all fields in PowerShell and find those with particular field type
SQL
Open SQL Management studio Execute something like that
SELECT TOP 1000
[ItemId]
,[FieldId]
,[Value]
,[Created]
,[Updated]
FROM [sc_sitecore_master].[dbo].[SharedFields]
WHERE FieldId = '{AB162CC0-DC80-4ABF-8871-998EE5D7BA32}' AND Value = 'MY FIELD NAME'
where
MY FIELD NAMEis a file type name
-
-
{AB162CC0-DC80-4ABF-8871-998EE5D7BA32}in this case is an id of Type field (Sitecore field), notice that query is executed againsSharedFieldstable notItems– Alan Płócieniak Feb 20 '17 at 12:29
I used a variation of Balaji's answer to search for data templates that contain a particular field type (in this case "link"), rather than for content with the field type. This also pops up the results in SPE's nice data grid for printing as HTML or exporting to a spreadsheet.
Get-ChildItem -Path "/sitecore/templates" -Recurse | Where-Object {$_.Fields["{AB162CC0-DC80-4ABF-8871-998EE5D7BA32}"] -like "link"} | Show-ListView -Property FullPath, Id
If you have powershell extension, you can try
Get-ChildItem -Path "/sitecore/content" -Recurse | Where-Object {$_.Fields["{AB162CC0-DC80-4ABF-8871-998EE5D7BA32}"] -like "Text"}
- 'Text' is a field type name
answered Feb 20 '17 at 12:43
