all things Sitecore related

Sitecore Rock’s Query Analyzer handy queries

By on November 28, 2012 in Sitecore, Sitecore Rocks, Tips and Tricks with 11 Comments

Hi there,

Tonight I was busy with Sitecore Rock’s Query Analyzer identifying a wrongly configured item. I thought I should share a couple of handy queries to quickly identify certain items.

Identify which sublayouts have the Datasource Location filled:

select @@name, @#Datasource Location# from /#sitecore#/#layout#/#Sublayouts#//* order by #Datasource Location# desc

Identify which template fields use the ‘query:’ statement in the source:

select @@name, @Source from /sitecore/templates/#User Defined#//*[contains(@Source, ‘query:’)]  order by Source desc

Identify which template fields have configured something in the in the source:

select @@name, @Source from /sitecore/templates/#User Defined# //*  order by Source desc

Identify which template fields have configured an HTML Editor Profile in the source, very handy to easy get them equal:

select @@name, @Source from /sitecore/templates/#User Defined# //*[contains(@Source, ‘/sitecore/system/Settings/Html Editor Profiles’)]  order by Source desc

More info and queries:

http://vsplugins.sitecore.net/Sitecore-Query-Analyzer-Samples.ashx, where you can find simple, advanced, update and delete examples

More info also on John West’s blog:

http://www.sitecore.net/Community/Technical-Blogs/John-West-Sitecore-Blog/Posts/2011/07/Sitecore-Rocks-Queries.aspx

Query Analyzer is a really nifty and handy tool, which can save you so much time. Make sure you get familiar with it

gr,

Robbert

 

About the Author

About the Author: I'm a Freelance and passionate Sitecore Developer living in The Netherlands. Running my own company Kayee Internet & Software Oplossingen. I am specialized since 2008 in Sitecore and Umbraco implementations. Sitecore MVP since 2011. Founder and member of the Dutch Sitecore User Group. You can follow me on twitter: @kayeeNL. My website: http://www.kayee.nl .

Subscribe

If you enjoyed this article, subscribe now to receive more just like it.

There Are 11 Brilliant Comments

Trackback URL | Comments RSS Feed

Sites That Link to this Post

  1. NewGuid (@new_guid) | November 28, 2012
  2. @Sitecore_US | November 28, 2012
  3. @RichardHauer | November 29, 2012
  4. Marc Duiker (@marcduiker) | November 29, 2012
  5. Pieter Brinkman (@pieterbrink123) | November 29, 2012
  6. Martina Welander (@sitecoremartina) | November 29, 2012
  7. @wonaldng | November 29, 2012
  8. @ericjanvputten | November 29, 2012
  9. @SitecoreRocks | November 29, 2012
  10. @wesleydasilva | November 29, 2012
  11. Find missing Sitecore help text - ASP.Net & Sitecore Blog | April 23, 2013

Post a Comment

Your email address will not be published. Required fields are marked *

Top