Using Treelist Values to Query a Sitecore Item

Posted by kirk.burleson on Stack Overflow See other posts from Stack Overflow or by kirk.burleson
Published on 2010-03-16T21:04:49Z Indexed on 2010/03/17 10:21 UTC
Read the original article Hit count: 629

Filed under:

sitecore

|

query

|

treelist

|

rss

I have an item named All Recipes that contains recipes named R1, R2, and R3. I have another item named My Recipes that has a treelist field named Recipes and it contains selected values R2 and R3 from the All Recipes item. The query I'm trying to write is for the Items field of an RSS Feed.

What is the query syntax to show the items in All Recipes that appear in the Recipes field of My Recipes?

© Stack Overflow or respective owner

Related posts about sitecore

Access sitecore settings programatically (Sitecore 6)

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a way to get to sitecore settings through code. The specific setting I'm interested in is the data Folder path. >>> More
Sitecore not resolving rich text editor URLS in page renders

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi We're having issues inserting links into rich text in Sitecore 6.1.0. When a link to a sitecore item is inserted, it is outputted as: http://domain/~/link.aspx?_id=8A035DC067A64E2CBBE2662F6DB53BC5&_z=z Rather than the actual resolved url: http://domain/path/to/page.aspx This article confirms… >>> More
Tricks and Optimizations for you Sitecore website

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
When working with Sitecore there are some optimizations/configurations I usually repeat in order to make my app production ready. Following is a small list I have compiled from experience, Sitecore documentation, communicating with Sitecore Engineers etc. This is not supposed to be technically complete… >>> More
Sitecore Rich Text Html Editor Profile - set global default

as seen on Stack Overflow - Search for 'Stack Overflow'
OK I can't believe this can't be found anywhere so I'm asking the question. Is there a way to set the default Html Editor Profile in Sitecore so I don't have the override the Source field on each individual Rich Text field? e.g. I want to make this the default option for the Html editor: /sitecore/system/Settings/Html… >>> More
Using Treelist Values to Query a Sitecore Item

as seen on Stack Overflow - Search for 'Stack Overflow'
I have an item named All Recipes that contains recipes named R1, R2, and R3. I have another item named My Recipes that has a treelist field named Recipes and it contains selected values R2 and R3 from the All Recipes item. The query I'm trying to write is for the Items field of an RSS Feed. What… >>> More

Related posts about query

sort mysql query by filtered query

as seen on Stack Overflow - Search for 'Stack Overflow'
I have two mysql queries: $sql = "SELECT * FROM content WHERE threadName LIKE '%$filter%' ORDER BY lastUpdated desc"; and $sql = "SELECT * FROM content ORDER BY lastUpdated desc"; The end result is to have all rows returned from a particular table 'content' but have those that match the variable… >>> More
How to use PHPunit's Database Test Case Methods of Query to compare with doctrine query

as seen on Stack Overflow - Search for 'Stack Overflow'
How to use PHPunit's Database Test Case Methods of Query to compare with doctrine query i m using phpunit with doctrine framework .. i want to test my doctrine query with phpunit query with using phpunit framework methods.. any buddy with Doctrine Query and PhpUnit Query plz Contact... //Bhavin… >>> More
Converting sql query to EF query - nested query in from

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey guys Just wondering how the following sql query would look in linq for Entity Framework... SELECT KPI.* FROM KeyPerformanceIndicator KPI INNER JOIN ( SELECT SPP.SportProgramPlanId FROM SportProgramPlan PSPP INNER JOIN SportProgramPlan ASPP … >>> More
Sql Query - Limiting query results

as seen on Stack Overflow - Search for 'Stack Overflow'
I am quite certain we cannot use the LIMIT clause for what I want to do - so wanted to find if there are any other ways we can accomplish this. I have a table which captures which user visited which store. Every time a user visits a store, a row is inserted into this table. Some of the fields are shopping_id… >>> More
hql equivalent query to this sql query

as seen on Stack Overflow - Search for 'Stack Overflow'
Select top 1 from <tablename> what is hql query for the above ? >>> More