Best way to query about all content instances of a content type assigned to a site

David_GarcA­a_GonzAlez

Hi all.

I wanted to show all the content instances of a content type assigned to a selected site. What is the best way to do this query??.

Thanks!!

This code is too slowly. What could be the problem?:

 

ContentInstanceWhereClause wClause = new ContentInstanceWhereClause();

                wClause.setMatchAny(true);
            
                while (siteChannelsIterator.hasNext()) {

                    ContentInstanceWhereClause wClause2 = new ContentInstanceWhereClause();

                    wClause2.setMatchAny(true);

                    wClause2.checkChannel(ObjectQueryOp.EQUAL, new ChannelRef(
                            (Channel) siteChannelsIterator.next()));

                    query.addWhereClause(wClause2);
                }
 

                long queryTime = System.currentTimeMillis();

                IPagingList servicesPagingList = QueryManager.execute(query);

David_GarcA­a_GonzAlez

Finally, I changed to use SearchQuery. It takes only 2 seconds to execute the query. The code looks like this:

 

SearchQuery searchQuery = new SearchQuery();

SearchFilterSet servicioFilterSet = SearchFilterSet .asCIFilterSet(CONTENT_TYPE_XML_NAME);

ObjectIdFilter filter = new ObjectIdFilter(SearchMgmtAttr.SITE); GUID[] sitesGUID = new GUID[1];

sitesGUID[0]=site.getId();

filter.equalsAny(sitesGUID);

servicioFilterSet.addSearchAttributeFilter(filter); searchQuery.getData().addFilterSet(servicioFilterSet);

long queryTime = System.currentTimeMillis();

IPagingList result = searchQuery.execute();