I have pages with pagetype CoursePage.
This coursepage pagetype has a property of courseID (e.g. L01, C05, X03) and courseName (e.g. Parasites, Flea worms).
Is there a way to query these records directly from MSSQL? Just want to get all coursepages with their courseid and coursename details.
From what tables are these details stored?
Instead of querying the DB directly I would use FindPagesWithCriteria instead.
Hope this helps.
If you know some SQL it should be fairly easy for you to write a SELECT...JOIN for the following tables:
tblPageType, tblPageDefinition and tblProperty
Using the relations:
tblPageDefinition.fkPageTypeID = tblPageType.pkID
tblProperty.fkPageDefinitionID = tblPageDefinition.pkID