Find components on CM side

Question

I need to find components on CM side that satisfy the following conditions:

• From target publication
• Based on a target schema
• Tagged with target keyword

This should be done using tom.net

Currently I have:

1. Keyword GetListUsingItems to get all items and then parse returned items to find ones matching other criteria
2. GetListItems on Content folder with schema filter and then parse returned items to find ones matching target keyword

Is it possible to do this with a single query? If not, what would be, performance wise, most optimal way to search for these components?

Answer 1

It's gonna be something like this:

var filter = new ClassifiedItemsFilter();
filter.ItemTypes = new[] { ItemType.Component };
filter.BasedOnSchemas = new[] { schema };
var components = keyword.GetClassifiedItems(filter);

In TOM.NET you have no control over queries, all the actions are executed just in time, but this code should go to database only once (provided you already have your keyword and schema). It will display you only items from "keyword" publication, I'm not sure, however, if shared components will be shown.

Answer 2

Not clear from the question what do you really want to do with this ultimately; why you really need to code for it.If the requirement is simple that you need to see a list of all components from a specific publication which is based on a particular schema and tagged with a keyword, this can be done out-of-the-box from the SDL Tridion CME itself using the Advanced search feature. Below snapshot shows this:

This will work if your parameters (Schema, Keywords and Publication) are fixed (or a small list) - In this case you can save the search as Virtual Folder and can further use it just like a Folder (even through code).

If your requirement is where the parameters (Schema, Keyword) are coming as input dynamically based on some criteria, then you may choose the above code mentioned by Andrey