In sitecore get all child and grand child items using fast query

sitecore sitecore7
Soni picture Soni · Feb 27, 2014 · Viewed 11.5k times · Source

In sitecore i want to get all child and grand child which inherited form "Industrial Product template .

Below are the fast query , but its giving error Error : End of string expected at position 5.

Fast query:

_masterdb.SelectItems("query:/sitecore/content/Product Catalog/Industrial/Products/*[@@templatename='Industrial Product']")

Answer

user459491 picture user459491 · Feb 27, 2014

This is not fast query, you are using normal query . Please use something like : 

Sitecore.Data.Items.Item[] items = 
 database.SelectItems("fast:/sitecore/content/Product Catalog/Industrial/Products//*[@@templateid='yourTemplateId']");

Also please use @@templateid not @@templatename, I made some tests and it's faster using @@templateid.

Also have a look here about using FastQuery.

Related questions

Get Item in all languages in which it has a version

Say we have an Item Product(which has versions in en, jp, zh and 0 versions in ru). How can I get this item in en, jp and zh and not in ru. I tried the below code. Item tempItem = Sitecore.…

Read More
Sitecore: Detect user in Page Editor mode

Can I know how to detect user is in page editor mode using code? This is because, I have a component, when user browses from page editor, it will search in master_index folder instead of web_index folder.

Read More
Sitecore Lucene: content delivery server index not updating on publish

I created a custom search page using the default sitecore_web_index and everything seemed to work until I migrated to my test environment that has separate content management and content delivery servers. The index on the CD server is …

Read More