How to examine Collection membership

  • Updated

Why is my collection not loading?

The Collection may not load because some of its content is in a status other than published.

This query lets you examine your collection by listing its content. Update the nav_id value to the collection ID (available in the collection properties).

SELECT content_id,content_status,content_type,end_date,* FROM content WHERE content_id in (select content_id from nav_to_content_tbl WHERE nav_id = 4 AND content_language = 1033)