Query Problem. Please Help!!!!

[mehranrezaei]

I have a custom content type with a Taxonomy Field and the TagsPart attached.
I want to query for content items that contain one of the terms in a given term list and are tagged with all the tags in a list.
Is it possible to write such a query with IContentQuery?

I think for this purpose I need to create a subquery on ContentTagRecord, but I can't find a way to combine these queries using ContentManager.Query.

Can someone write an example of such a query?

[sebastienros]

Not sure but worst case scenario you can always use custom SQL queries.

[mehranrezaei]

@sebastienros Thank you for your reply.
The problem with using SQL queries is that the output of the query is not in the form of entities. In particular, in this case I need to work with content item data, its parts, ....

[Skrypt]

When you click on "Return Documents" option it returns ContentItems.

[mehranrezaei]

@Skrypt I did not understand your point! Where is Return Documents option when I query using TransactionManager?