I want to get all items with CT derived from some ParentCT using FullTextSqlQuery by ContentTypeId. And there are no results returned.
Query looks like:
SELECT ContentTypeId FROM SCOPE() WHERE CONTAINS(ContentTypeId, '"0x01*"')
Where:
- ContentTypeId is the managed property associated with both of crawled properties. (There are 2 crawled propetries with same name - "ContentTypeId")
- '0x01' - some parent CT id
Also:
- Index have been reseted
- Full crawl have been done
- Crawled property settings => "Include values for this property in the search index" checked in both of crawled propetries named "ContentTypeId"
- Crawled property settings => "Content using this property" => "Sample documents:" has
There are zero documents in the index using this property
in both of crawled propetries named "ContentTypeId"