Finding Course Pages and Module Pages separately

[MikeRichards]

I was wondering if anyone has found a good way to find course pages (pages that are not directly associated with a learning module) in CD2? I was hoping that content_tags would have a way to do it with content_type and tag_type. So far the best route I have found seems to be pages defined in wiki_pages that do not have a matching record in content_tags.

Before I continued down this route I wanted to see if perhaps I missed something and there was an attribute out there to separate these two types of pages. Ideally I prefer explicitly searching for values over relying on the absence of them, since there can be other factors in play that could cause the absence.

[stimme · Accepted solution]

@MikeRichards I think the route you identified is the correct and only way to distinguish pages in modules and pages not in modules. No column in wiki_pages indicates whether the page is include in one or more course modules.

[MikeRichards]

Thanks.

I had suspected this was the case but was hoping that I was wrong. I may see if there is a way to suggest it as a feature request. Since in the event of not having a matching record in content_tags, either means it is a course page, the record is missing because of eventual consistency, or the record could have been lost in one of the many ETL/ELT stages it will go through to get from the Canvas operation database to their data warehouse, and then ultimately to our data warehouse.